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.
-
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.