| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | ACCTNO | Returnable packaging account | nvarchar | 12 | 0 | CHAR | (N' ') | No | | RL_ACCTNO | Allow NULL? |
| 3 | RET_MATNR | Returnable packaging | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | MARA | RL_RET_MATNR | Allow NULL? |
| 4 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001 | BUKRS | Allow NULL? |
| 5 | PRPSHPA | Assignment ID of Main Partner Relationship | nvarchar | 12 | 0 | NUMC | (N'000000000000') | Yes | RLPSHPA | RL_PRPSHPA | Allow NULL? |
| 6 | PP_VALFROM | Valid from date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RL_VALFROM | Allow NULL? |
| 7 | PP_VALTO | Valid-to date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RL_VALTO | Allow NULL? |
| 8 | MEINS | Base Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | MEINS | Allow NULL? |
| 9 | ACCTME | Account Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RL_ACCTME | Allow NULL? |
| 10 | ROLEACM | Role of location in account statement | char | 1 | 0 | CHAR | (N' ') | Yes | | RL_ROLEACM | Allow NULL? |
| 11 | ACCTBAL | Current Account Balance in Base Unit of Measure | decimal | 13 | 3 | QUAN | ((0)) | Yes | | RL_ACCTBAL | |
| 12 | SEQNO | Posting sequence number of returnable packaging account | int | 10 | 0 | INT4 | ((0)) | Yes | | RL_SEQNO | Allow NULL? |
| 13 | OTYPE | Object type | nvarchar | 2 | 0 | CHAR | (N' ') | No | * | RL_OTYPE | Allow NULL? |
| 14 | OBJID | Processor ID in organizational management | nvarchar | 12 | 0 | CHAR | (N' ') | No | | RL_ACTORID | Allow NULL? |
| 15 | ACCTSTATE | Returnable Packaging Account Status | char | 1 | 0 | CHAR | (N' ') | No | | RL_ACCTSTATE | Allow NULL? |
| 16 | VKORG | Sales organization | nvarchar | 4 | 0 | CHAR | (N' ') | No | TVKO | RL_VKORG | Allow NULL? |
| 17 | VTWEG | Distribution channel | nvarchar | 2 | 0 | CHAR | (N' ') | No | TVTW | RL_VTWEG | Allow NULL? |
| 18 | NRART | Type of partner number | nvarchar | 2 | 0 | CHAR | (N' ') | No | TVPA | RL_NRART | Allow NULL? |
| 19 | PARNR | Output Partner | nvarchar | 10 | 0 | CHAR | (N' ') | No | | RL_PARNR | Allow NULL? |
| 20 | ACST_CTRL | Statement control for returnable packaging account | char | 1 | 0 | CHAR | (N' ') | Yes | | RL_ACST_CTRL | Allow NULL? |
| 21 | CPCTRL | Procedure for returnable packaging account matching | char | 1 | 0 | CHAR | (N' ') | Yes | | RL_CPCTRL | Allow NULL? |
| 22 | ACST_CREATE_CTRL | Control for Creation and Sending of RP Account Statements | char | 1 | 0 | CHAR | (N' ') | Yes | | RL_ACST_CREATE_CTRL | Allow NULL? |
| 23 | KONNR | Number of Outline Agreement | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | EKKO | RL_KONNR | Allow NULL? |
| 24 | KTPNR | Item Number of Outline Agreement | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | EKPO | RL_KTPNR | Allow NULL? |
| 25 | PLANING | Indicator Quantity Below Reorder Point Quantity | char | 1 | 0 | CHAR | (N' ') | Yes | | RL_PLANING | Allow NULL? |
| 26 | PLANING_CTRL | Planning Type for Returnable Packaging Account | char | 1 | 0 | CHAR | (N' ') | Yes | | RL_PLANING_CTRL | Allow NULL? |
| 27 | REORDBAL | Reorder Point Quantity in Base Unit of Quantity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | RL_REORDBAL | |
| 28 | ORDQUAN | Purchase Order Quantity in Base Unit of Quantity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | RL_ORDQUAN | |
| 29 | REF_PURCH_DOC | Reference Document for Purchasing Document | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | RL_REFPURCH_DOC | Allow NULL? |
