Transaction Data

Find here all the Reporting Layer (RL) views and its included Harmonization Layer (HL) views included in this content package.

Inbound Layer (IL) views are not listed here explicitly as they mainly serve as projection views on top of the local tables already listed above without any advanced logic.

The following applies to all Inbound Layer views (if applicable):
  • date type fields delivered as type time stamp from the source side are transformed to type date in the Inbound Layer (IL) using the TO_DATE() function (e.g. TO_DATE(CREATIONDATE)).

  • Calculated Column:

    Calculated Fields

    Definition

    Region

    CASE

    WHEN COUNTRYCODE IN ('AG','AI','AR','AW','BB','BL','BO','BQ','BR','BS','BV','BZ','CL','CO','CR','CU','CW','DM','DO','EC','FK', 'GD','GF','GP','GS','GT','GY','HN','HT','JM','KN','KY','LC','MF','MQ','MS','MX','NI','PA','PE','PR','PY','SR','SV','SX','TC','TT','UY','VC','VE','VG','VI') THEN 'LA'

    WHEN COUNTRYCODE IN ('BM','CA','GL','PM','US') THEN 'NA'

    WHEN COUNTRYCODE IN ('AS','AQ','AU','BD','BT','IO','BN','KH','CN','CX','CC','CK','FJ','PF','TF','GU','HM','HK','IN','ID','JP','KI','KV','KR','KG','LA','MO','MY','MV','MH','FM','MN','MM','NR','NP','NC','NZ','NU','NF','MP','PK','PW','PG','PH','PN','WS','SG','SB','LK','TW','TJ','TH','TL','TK','TO','TM','TV','UM','UZ','VU','VN','WF') THEN 'APAC'

    WHEN COUNTRYCODE IN ('AF','AX','AL','DZ','AD','AO','AM','AT','AZ','BH','BY','BE','BJ','BA','BW','BV','BG','BF','BI','CM','CV','CF','TD','KM','CD','CG','CI','HR','CY','CZ','DK','DJ','EG','GQ','ER','EE','ET','FK','FO','FI','FR','GA','GM','GE','DE','GH','GI','GR','GL','GG','GN','GW','VA','HU','IS','IR','IQ','IE','IM','IL','IT','JE','JO','KZ','KE','KW','LV','LB','LS','LR','LY','LI','LT','LU','MK','MG','MW','ML','MT','MR','MU','YT','MD','MC','ME','MA','MZ','NA','NL','NE','NG','NO','OM','PS','PL','PT','QA','RE','RO','RU','RW','SH','SM','ST','SA','SN','RS','SC','SL','SK','SI','SO','ZA','GS','SS','ES','SD','SJ','SZ','SE','CH','SY','TZ','TG','TN','TR','UG','UA','AE','GB','EH','YE','ZM','ZW') THEN ('EMEA')

    ELSE 'Other'

    END

  • All business names of the fields are adjusted to be more descriptive and readable.

  • Fields that are not deemed necessary for the SAP Datasphere models on top are hidden in the projection. If needed, they can be unhidden again.