| 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 | POL_ID | Order List Item Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | | WRF_POHF_POL_ID | Allow NULL? |
| 3 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T161 | ESART | Allow NULL? |
| 4 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001 | BUKRS | Allow NULL? |
| 5 | EKORG | Purchasing Organization | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T024E | EKORG | Allow NULL? |
| 6 | EKGRP | Purchasing Group | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T024 | BKGRP | Allow NULL? |
| 7 | LIFNR | Vendor Account Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | LFA1 | ELIFN | Allow NULL? |
| 8 | PSTYP | Item Category for Seasonal Procurement | char | 1 | 0 | CHAR | (N' ') | Yes | | WRF_POHF_PSTYP | Allow NULL? |
| 9 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS | Allow NULL? |
| 10 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001W | EWERK | Allow NULL? |
| 11 | MATKL | Material Group | nvarchar | 9 | 0 | CHAR | (N' ') | Yes | * | MATKL | Allow NULL? |
| 12 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | MARA | MATNR | Allow NULL? |
| 13 | TXZ01 | Short Text | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | TXZ01 | Allow NULL? |
| 14 | IDNLF | Material Number Used by Vendor | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | IDNLF | Allow NULL? |
| 15 | MENGE | Purchase Order Quantity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | BSTMG | |
| 16 | BSTME | Purchase Order Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | BSTME | Allow NULL? |
| 17 | MEINS | Base Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | MEINS | Allow NULL? |
| 18 | BPRME | Order Price Unit (Purchasing) | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | BBPRM | Allow NULL? |
| 19 | BPUMZ | Numerator for Conversion of Order Price Unit into Order Unit | decimal | 5 | 0 | DEC | ((0)) | Yes | | BPUMZ | |
| 20 | BPUMN | Denominator for Conv. of Order Price Unit into Order Unit | decimal | 5 | 0 | DEC | ((0)) | Yes | | BPUMN | |
| 21 | UMREZ | Numerator for Conversion of Order Unit to Base Unit | decimal | 5 | 0 | DEC | ((0)) | Yes | | UMBSZ | |
| 22 | UMREN | Denominator for Conversion of Order Unit to Base Unit | decimal | 5 | 0 | DEC | ((0)) | Yes | | UMBSN | |
| 23 | NETPR | Net Price in Purchasing Document (in Document Currency) | decimal | 11 | 2 | CURR | ((0)) | Yes | | BPREI | |
| 24 | PEINH | Price Unit | decimal | 5 | 0 | DEC | ((0)) | Yes | | EPEIN | |
| 25 | LATEST_PO_DATE | Latest Order Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | WRF_POHF_LATEST_PO_DATE | Allow NULL? |
| 26 | EINDT | Item Delivery Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | EINDT | Allow NULL? |
| 27 | SATNR | Cross-Plant Configurable Material | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | MARA | SATNR | Allow NULL? |
| 28 | ATTYP | Material Category | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | ATTYP | Allow NULL? |
| 29 | AKTNR | Promotion | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | WAKH | WAKTION | Allow NULL? |
| 30 | SAISO | Season Category | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T6WSP | SAISO | Allow NULL? |
| 31 | SAISJ | Season Year | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | SAISJ | Allow NULL? |
| 32 | AUREL | Relevant to Allocation Table | char | 1 | 0 | CHAR | (N' ') | Yes | | AUREL | Allow NULL? |
| 33 | UPTYP | Subitem Category, Purchasing Document | char | 1 | 0 | CHAR | (N' ') | Yes | * | UPTYP | Allow NULL? |
| 34 | UPVOR | Subitems Exist | char | 1 | 0 | CHAR | (N' ') | Yes | | UPVOR | Allow NULL? |
| 35 | UEB_ID | Higher Lvel Order List Item Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | WRF_POHF_UEB_ID | Allow NULL? |
| 36 | STAPO | Item is statistical | char | 1 | 0 | CHAR | (N' ') | Yes | | STAPO | Allow NULL? |
| 37 | FIXPO | Firm Deal Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | WRF_POHF_FIXPO | Allow NULL? |
| 38 | NOROUND | No Rounding | char | 1 | 0 | CHAR | (N' ') | Yes | | WRF_POHF_NOROUND | Allow NULL? |
| 39 | HIER_ID | Hierarchy | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | WRF_HIER_CNT | Allow NULL? |
| 40 | HIER_NODE | Hierarchy Node | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | WRF_STRUC_NODE | Allow NULL? |
| 41 | ROLLOUT | Rollout in a Season | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | SAITY | Allow NULL? |
| 42 | KEYFIG | Key Figure ID | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | WRF_KEYFIG | Allow NULL? |
| 43 | PRICE_FIX | Price Fixing Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | WRF_POHF_PRICE_FIX | Allow NULL? |
| 44 | CON_EBELN | Contract Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | WRF_POHF_CON_EBELN | Allow NULL? |
| 45 | CON_EBELP | Item Number of Superior Contract | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | * | WRF_POHF_CON_EBELP | Allow NULL? |
| 46 | OTB_STATUS | OTB Check Status | char | 1 | 0 | CHAR | (N' ') | Yes | | WRF_POTB_STATUS | Allow NULL? |
| 47 | LOEKZ | Deletion Indicator in Order List | char | 1 | 0 | CHAR | (N' ') | Yes | | WRF_POHF_POL_LOEKZ | Allow NULL? |
| 48 | CUOBJ | Configuration (internal object number) | nvarchar | 18 | 0 | NUMC | (N'000000000000000000') | Yes | | CUOBJ | Allow NULL? |
| 49 | INCO1 | Incoterms (Part 1) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | INCO1 | Allow NULL? |
| 50 | INCO2 | Incoterms (Part 2) | nvarchar | 28 | 0 | CHAR | (N' ') | Yes | | INCO2 | Allow NULL? |
| 51 | SUBMI | Collective Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | SUBMI | Allow NULL? |
| 52 | WERKS_SUBMI | Plant Store in Collective Numbering | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | WRF_POHF_WKSUB | Allow NULL? |
| 53 | LTSNR | Vendor Subrange | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | WYT1 | LTSNR | Allow NULL? |
| 54 | UZEIT | Time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | UZEIT | Allow NULL? |
| 55 | DL_ID | Date Line ID (GUID) | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | | WRF_PSCD_DL_ID | Allow NULL? |
| 56 | HANDOVER_DATE | Transfer Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | WRF_PSCD_HANDOVER_DATE | Allow NULL? |
| 57 | NO_SCEM | Purchase Order Not Transferred to SCEM | char | 1 | 0 | CHAR | (N' ') | Yes | | WRF_PSCD_NO_SCEM | Allow NULL? |
| 58 | DNG_DATE | Creation Date of Reminder Message Record | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | WRF_PCTR_DNG_DATE | Allow NULL? |
| 59 | DNG_TIME | Creation Time of Reminder Message Record | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | WRF_PCTR_DNG_TIME | Allow NULL? |
| 60 | SOURCE_ID | Origin Profile | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | WRFT_POHF_SOURCE | WRF_POHF_SOURCE_ID | Allow NULL? |
| 61 | SOURCE_KEY | Key in Source System | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | WRF_POHF_SOURCE_KEY | Allow NULL? |
| 62 | SOURCE_UEBID | Higher Level Key in Source System | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | WRF_POHF_SOURCE_UEBID | Allow NULL? |
| 63 | TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TIMESTAMP | |
| 64 | UNAME | User Name in User Master Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | XUBNAME | Allow NULL? |
| 65 | PROGRAMM | ABAP Program Name | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | * | PROGRAMM | Allow NULL? |
