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
Datos Maestros
/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)
Jerarquías
/BI0/H Hierarchy
/BI0/I Hierarchy SID structure (time independent)
/BI0/J Hierarchy Interval
/BI0/K Hierarchy SID
Objetos Temporales(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 Convenios de Nomenclatura
All InfoAreas are created sub InfoAreas under the one InfoArea “/CPMB/BPC” within the DataWarehousingWorkbench (RSA1).La nomenclatura adoptada para las tablas dinámicas es la siguiente:
• 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 App can be found in table: UJA_APPL
Las siguientes Propiedades se comparten entre diferentes AppSets. Son las siguiente
• /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