| 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 | T000 | MANDT | Allow NULL? |
| 2 | REFBT | Reference document category (conversion exit; c.f. REFBTYP) | nvarchar | 3 | 0 | NUMC | (N'000') | No | | CO_REFBTYP | Allow NULL? |
| 3 | REFBN | Reference Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | | CO_REFBN | Allow NULL? |
| 4 | RFPOS | Item number of reference document | nvarchar | 5 | 0 | NUMC | (N'00000') | No | | CC_RFPOS | Allow NULL? |
| 5 | RFKNT | Account assignment number of reference document | nvarchar | 5 | 0 | NUMC | (N'00000') | No | | CC_RFKNT | Allow NULL? |
| 6 | RFTRM | Deadline item of reference document | nvarchar | 5 | 0 | NUMC | (N'00000') | No | | CC_RFTRM | Allow NULL? |
| 7 | RFART | Reference document type | char | 1 | 0 | CHAR | (N' ') | No | | CC_RFART | Allow NULL? |
| 8 | LIFNR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | CHAR | (N' ') | No | LFA1 | LIFNR | Allow NULL? |
| 9 | LEDNR | Ledger for Controlling objects | nvarchar | 2 | 0 | CHAR | (N' ') | No | | LEDNR | Allow NULL? |
| 10 | OBJNR | Object number | nvarchar | 22 | 0 | CHAR | (N' ') | No | ONR00 | J_OBJNR | Allow NULL? |
| 11 | HRKFT | CO key subnumber | nvarchar | 14 | 0 | CHAR | (N' ') | No | * | CO_SUBKEY | Allow NULL? |
| 12 | RFORG | Reference Organizational Units | nvarchar | 10 | 0 | CHAR | (N' ') | No | | AWORG | Allow NULL? |
| 13 | RFTYP | Reference Transaction | nvarchar | 5 | 0 | CHAR | (N' ') | No | TTYP | AWTYP | Allow NULL? |
| 14 | RFSYS | Logical system of source document | nvarchar | 10 | 0 | CHAR | (N' ') | No | TBDLS | AWSYS | Allow NULL? |
| 15 | VRGNG | CO Business Transaction | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | CO_VORGANG | Allow NULL? |
| 16 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | GJAHR | Allow NULL? |
| 17 | WRTTP | Value Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | CO_WRTTP | Allow NULL? |
| 18 | VERSN | Version | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TKA09 | VERSN | Allow NULL? |
| 19 | SAKTO | Cost element | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | SAKTO | Allow NULL? |
| 20 | VBUND | Company ID of trading partner | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T880 | RASSC | Allow NULL? |
| 21 | PARGB | Trading partner's business area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TGSB | PARGB | Allow NULL? |
| 22 | BEKNZ | Debit/credit indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | BEKNZ | Allow NULL? |
| 23 | TWAER | Transaction Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | TWAER | Allow NULL? |
| 24 | UNAME | User Name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | UNAME | Allow NULL? |
| 25 | BLDAT | Document Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CO_BLDAT | Allow NULL? |
| 26 | BUDAT | Expected debit date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CO_PODAT | Allow NULL? |
| 27 | PERIO | Period | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | CO_PERIO | Allow NULL? |
| 28 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001 | BUKRS | Allow NULL? |
| 29 | KOKRS | Controlling Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TKA01 | KOKRS | Allow NULL? |
| 30 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | MARA | MATNR | Allow NULL? |
| 31 | MATKL | Material Group | nvarchar | 9 | 0 | CHAR | (N' ') | Yes | T023 | MATKL | Allow NULL? |
| 32 | SGTXT | Segment text | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | CO_SGTXT | Allow NULL? |
| 33 | GESMNG | Planned quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MENGE1 | |
| 34 | MEINH | Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | CO_MEINH | Allow NULL? |
| 35 | MEGBTR | Total Quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MEGXXX | |
| 36 | MBGBTR | Total quantity entered | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MBGXXX | |
| 37 | MEINB | Posted Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | MEINB | Allow NULL? |
| 38 | WKURS | Exchange Rate | decimal | 9 | 5 | DEC | ((0)) | Yes | | WKURS | |
| 39 | ORGWTH | Planned value in local currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | WERTH1 | |
| 40 | WHGBTR | Total value in local currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | WHGXXX | |
| 41 | ORGWTK | Planned value in controlling area currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | WERTK1 | |
| 42 | WKGBTR | Total Value in Controlling Area Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | WKGXXX | |
| 43 | ORGWTT | Planned value in transaction currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | WERTT1 | |
| 44 | WTGBTR | Total Value in Transaction Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | WTGXXX | |
| 45 | ORGWTO | Planned value in object currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | WERTO1 | |
| 46 | WOGBTR | Total Value in Object Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | WOGXXX | |
| 47 | ORGWTL | Planned value in ledger currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | WERTL1 | |
| 48 | WLGBTR | Total value in ledger currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | WLGXXX | |
| 49 | LOEKZ | Deletion Indicator in Purchasing Document | char | 1 | 0 | CHAR | (N' ') | Yes | | ELOEK | Allow NULL? |
| 50 | DABRZ | Reference Date for Settlement | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DABRBEZ | Allow NULL? |
| 51 | TIMESTMP | Seconds since 1.1.1990,0:00 GMT * 10000 | decimal | 16 | 0 | DEC | ((0)) | Yes | | RKE_TSTMP | |
