Transform
Naming Conventions
BackOffice follows a very strict naming convention that provides a methodology for creating names that each member of the team can understand.
Every table has two names: informal and formal. Use the informal table name, such as MARC or MARA when naming objects. Use the formal table name, such as ttMARC or ttMARA, when naming a Target rule.
Use the naming convention:
tr[InformalTableName]_[FieldName]_Sel, displayed as: trMARA_MAKTXUpdSel.
The formal table name for this table is ttMAKT. Note that the informal table naming convention in this example does not produce trttMAKT_MAKTXUpdSel, rather it should produce the following name trMAKT_MAKTXUpdSel. This informal table name rule is also used when naming Source rules, Source/Target reports and Target exports.
Item |
Naming Convention |
Source System ID |
[Source System Name]_[Location] NOTE: Location is optional. |
Source Report |
sv[InformalTableName]_[FieldName]_[Description]Sel |
Sub-View for Source Reports |
sv[InformalTableName]_[FieldName]_[AdditionalActionDescription][010]Sel or sv[InformalTableName]_[FieldName]_[AdditionalActionDescription][020]Sel |
Source Table |
st[TargetTableName]_[SourceSystemID]_[SourceTableName] |
Source Repository |
sdb[Source SystemID] |
Source Rule |
View: sr[InformalTableName]_[FieldName]UpdSel Stored Procedure: sr[InformalTableName]_[FieldName]Upd If Field Groups are being used: View: sr[InformalTableName]_[FieldName]_[FieldGroup]UpdSel Stored Procedure: Sr[InformalTableName]_[FieldName]_[FieldGroup]Upd
If Field Groups are being used: For Manual Rules (System won’t generate a namespace for these): View: sr[InformalTableName]_[FieldName]_[FieldGroup]_[AdditionalDescription]UpdSel Stored Procedure: sr[InformalTableName]_[FieldName]_[FieldGroup]_[AdditionalDescription]Upd |
Sub-View for Source Rules |
For Manual Rules only [System won’t generate a namespace for these]: sr[InformalTableName]_[FieldName]_[AdditionalDescription]_[010]UpdSel or sr[InformalTableName]_[FieldName]_[AdditionalDescription]_[020]UpdSel Final registered rule: sr[InformalTableName]_[FieldName]_[AdditionalDescription]UpdSel |
Target Table |
tt[TargetName] |
Target Source |
st[Target Name]_[Source System ID] |
Target Rule |
View: tr[InformalTableName]_[FieldName]UpdSel Stored Procedure: tr[InformalTableName]_[FieldName]Upd If Field Groups are being used: View: tr[InformalTableName]_[FieldName]_[FieldGroup]UpdSel Stored Procedure: tr[InformalTableName]_[FieldName]_[FieldGroup]Upd
If Field Groups are not being used: For Manual Rules (System won’t generate a namespace for these): View: tr[InformalTableName]_[FieldName]_[FieldGroup]_[AdditionalDescription]UpdSel Stored Procedure: tr[InformalTableName]_[FieldName]_[FieldGroup]_[AdditionalDescription]Upd |
Target Report |
tv[InformalTableName]_[FieldName]_[Description]Sel or tv[InformalTableName]_[Fieldname]Sel or tv[InformalTableName]_[Description]Sel
For Manual Reports the same naming convention should be followed. |
Target Export |
tx[InformalTableName]_[Description]Sel tx[InformalTableName]_[FieldName]Sel or tx[InformalTableName]_[Description]BDC |
Import Packages (Created in Assemble) |
#Database#%#Source#%.imp |
Export packages (Created in Assemble) |
#Database#%#Source#%.exp |
Was this article helpful?
Sorry about that.
Why wasn't this helpful? (check all that apply)
Thanks for your feedback.
Want to tell us more?
Send an email to our authors to leave your feedback.
Great!
Thanks for your feedback.