| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | MEV_D_AD_ITEM | Period-End Valuation: Accruals Document Item | 2 | GUID_ITEM | Period-End Valuation: GUID as RAW 16 | varbinary | 16 | 0 | | |
2 | MEV_D_AD_ITEM_MM | Period-End Valuation: Accruals Document Item MM | 2 | GUID_ITEM | Period-End Valuation: GUID as RAW 16 | varbinary | 16 | 0 | | |
3 | MEV_D_AD_ITEM_SD | Period-End Valuation: Accruals Document Item SD | 2 | GUID_ITEM | Period-End Valuation: GUID as RAW 16 | varbinary | 16 | 0 | | |
4 | MEV_D_WL_ITEM | Period-end valuation: Worklist item | 2 | GUID_ITEM | Period-End Valuation: GUID as RAW 16 | varbinary | 16 | 0 | | |
5 | MEV_D_WL_MM | Period-end valuation: Worklist - Materials Management Data | 2 | GUID_ITEM | Period-End Valuation: GUID as RAW 16 | varbinary | 16 | 0 | | |
6 | MEV_D_WL_SD | Period-end valuation: Worklist - Sales and Distribution Data | 2 | GUID_ITEM | Period-End Valuation: GUID as RAW 16 | varbinary | 16 | 0 | | |
TOPProfitability Analysis |
7 | COPA_CRM_CEERROR | CO-PA: Incoming AE Records from CRM with Errors | 3 | GUID_ITEM | | nvarchar | 32 | 0 | | |
8 | COPA_CRM_GUIDMAP | Mapping Table CRM GUIDS - CO-PA Document Numbers | 3 | GUID_ITEM | | nvarchar | 32 | 0 | | |
9 | COPA_GUID_MAP | Mapping Table between CRM GUIDS and CO-PA Database Structure | 7 | GUID_ITEM | | nvarchar | 32 | 0 | | |