Naming Conventions
Prefix: /BI0/ Business Content
object
Prefix: /BIC/ Object created by
the customer
InfoCubes
/BI0/F Fact table for
InfoCubes
/BI0/E Fact table for InfoCubes
(compressed)
/BI0/L Validity data table for
inventory InfoCubes
/BI0/DN Characteristics Dimension
(N is the dimension number)
/BI0/DP Data Packet
/BI0/DT Time Dimension
/BI0/DU Unit Dimension
ODS
/BI0/A00 Active table
/BI0/A40 Activation queue
/BI0/B<10 gen. digits>
ChangeLog
Master Data
/BI0/S Master Data SID
/BI0/P Master Data
/BI0/T Master Data Text
/BI0/X Navigational attribute
(time independent)
/BI0/Y Navigational attribute
(time dependent)
Hierarchies
/BI0/H Hierarchy
/BI0/I Hierarchy SID structure
(time independent)
/BI0/J Hierarchy Interval
/BI0/K Hierarchy SID
Temporary objects (stored in
PSAPTEMP)
/BI0/01 Table for intermediate
results for query execution
/BI0/02 Table for intermediate
results for query execution - hierarchies
/BI0/03 Table for intermediate results
for query execution
/BI0/04 Stored procedures during
compression of InfoCube
/BI0/F2<5 gen.
digits>,
/BI0/E2<5 gen. digits>
Temporary fact table of an aggregate used during the changerun
BPC Naming Convention:
All InfoAreas are created sub InfoAreas
under the one InfoArea “/CPMB/BPC” within the DataWarehousingWorkbench (RSA1).
The naming convention of the
dyanmic tables are as follows:
• Journal
/1CPMB/appset_prefix+appl_prefix+JRDT
• Audit
/1CPMB/appset_prefix+appl_prefix+AD
• Audit
archive /1CPMB/appset_prefix+appl_prefix+AD_A
• Workstatus
/1CPMB/LKWS+appset_prefix+appl_prefix
• Comment
/1CPMB/appset_prefix+appl_prefix+CMT
• Comment
archive /1CPMB/appset_prefix+appl_prefix+CMTA
The appset_prefix for an AppSet
can be found in table: UJA_APPSET_INFO
The appl_prefix for an AppSet can
be found in table: UJA_APPL
The following Properties are
shared across AppSets and are
• /CPMB/ACCTYPE
• /CPMB/CALC
• /CPMB/RATETYP
• /CPMB/YEAR
• /CPMB/CURR
• /CPMB/ENTITY
• /CPMB/REPORT
• /CPMB/FLOWTYP
• /CPMB/TILEVEL
• /CPMB/PERIOD
No comments:
Post a Comment