Types of Mappings

There are three types of mappings:

  • 1 to 1 mapping

     

    I

    I

    I

    I

    I

    I

    		              

    Level

    I_FSItem

    I_Subitem

    I_SubItemCategory

    I_ConsolidationUnit

    I_PartnerConsolidationUnit

    I_Amount

    FinancialStatementItem

    SubitemCategory

    Subitem

    ConsolidationUnit

    PartnerConsolidationUnit

    AmountInLocalCurrency

    AmountInLocalCurrencyCurrency

    0

    		            

    [I_FSItem]

    [I_SubitemCategory]

    |I_Subitem]

    [I_ConsolidationUnit]

    [I_PartnerConsolidationUnit]

    [I_Amount]

    "EUR"

  • 1 to N mapping

     

    I

    I

    I

    I

    		          

    Level

    Consolidation TransactionType

    GLAccount

    CompanyCodeCurrency

    AmountInCompanyCodeCurrency

    SubitemCategory

    Subitem

    AmountInLocalCurrencyCurrency

    AmountInLocalCurrency

    ConsolidationUnit

    0

    955

    141200

    		    

    1

    955

    [CompanyCodeCurrency]

    [AmountInCompanyCodeCurrency]

    "S3009"

    0

    955

    161200

    		    

    1

    950

    [CompanyCodeCurrency]

    [AmountInCompanyCodeCurrency]

    "S3009"

    0

    955

    151100

    		    

    1

    960

    [CompanyCodeCurrency]

    [AmountInCompanyCodeCurrency]

    "S3009"

    Transaction Type is mapped to Subitem Category + Subitem

    		          

  • N to 1 mapping

     

    I

    I

    I

    		      

    Level

    Account

    Functional Area

    AmountInCompanyCodeCurrency

    FS Item

    AmountInLocalCurrency

    >ConsolidationUnit

    0

    41110000

    SALES

    		  

    411100

    [AmountInCompanyCodeCurrency]

    S3009

    0

    41110000

    COGS

    		  

    421100

    [AmountInCompanyCodeCurrency]

    S3009
     

    Account and Functional Area are mapped to FS Item

    		      

  • Example with functions (CLEAN)

     

    I

    I

    I

    I

    I

    I

    I

    I

    I

    I

    		                          

    Level

    I_FSItem

    I_Amount

    I_SubItem

    I_Segment

    I_FunctionalArea

    I_SubitemCategory

    I_Material

    I_ProfitCenter

    I_CostCenter

    I_AssignmentReference

    FinancialStatementItem

    SubitemCategory

    SubItem

    Material

    AssignmentReference

    FunctionalArea

    Segment

    ProfitCenter

    CostCenter

    AmountInLocalCurrencyCurrency

    AmountInLocalCurrency

    ControllingArea

    ConsolidationUnit

    0

    		                    

    [I_FSItem]

    [I_SubitemCategory]

    CLEAN([I_SubItem];'X')

    [I_Material]

    [I_AssignmentReference]

    [I_FunctionalArea]

    [I_Segment]

    CLEAN([I_ProfitCenter];'X')

    CLEAN([I_CostCenter];'X')

    "USD"

    [I_Amount]

    "A000"

    "S3011"