| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdvanced Returns Management |
1 | MSR_D_APPROVAL | Multistep returns: Approval | 7 | DOC_NR | Document Number | nvarchar | 30 | 0 | | |
2 | MSR_D_EXECUTED | Advanced Returns Management # Tracking of Executed Steps | 7 | DOC_NR | Document Number | nvarchar | 30 | 0 | | |
3 | MSR_D_FIN_STATUS | Advanced Returns Management - Next Financial Steps | 16 | DOC_NR | Document Number | nvarchar | 30 | 0 | | |
4 | MSR_D_HEAD | Advanced Returns Management - Tracking Header Data | 10 | DOC_NR | Document Number | nvarchar | 30 | 0 | | |
5 | MSR_D_NEXTPLANTS | Multi-step returns - next plants | 7 | DOC_NR | Document Number | nvarchar | 30 | 0 | | |
TOPBrazil |
6 | PA0465 | HR master record infotype 0465 | 57 | DOC_NR | Document number | nvarchar | 40 | 0 | | |
7 | PB0465 | HR master record infotype 0465 | 57 | DOC_NR | Document number | nvarchar | 40 | 0 | | |
TOPIntercompany Data Exchange |
8 | TINV_DOC_SHORT | Extract of Bill Receipt (Evaluation System): Bill Document | 4 | DOC_NR | Consecutive Number of Document for a Document Header | int | 10 | 0 | | |
9 | TINV_INV_DOC | Billing Doc. Data | 4 | DOC_NR | Consecutive Number of Document for a Document Header | int | 10 | 0 | | |
TOPPerishables Procurement |
10 | FIP_D_ORDER_LINE | Order lines for FIP | 3 | DOC_NR | document number | nvarchar | 10 | 0 | | |
TOPSAP Retail Store |
11 | TREC_FORC_COMPL | Temporary data for the receiving forecast | 3 | DOC_NR | Purchase Order Number | nvarchar | 10 | 0 | | |