| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | EC_CLIENT | Allow NULL? |
| 2 | REQNO | Requirement Coverage Request Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | EC_REQNO | Allow NULL? |
| 3 | REQSLINE | Temporary Item Number of Requirement Coverage Request | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | REQSLINE | Allow NULL? |
| 4 | REQLLINE | Administrative line number of requirement coverage request | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | REQLLINE | Allow NULL? |
| 5 | DOC_TYPE | Purchase Requisition Document Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BBSRT | Allow NULL? |
| 6 | PUR_GROUP | Purchasing Group | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | EKGRP | Allow NULL? |
| 7 | CREATED_BY | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM | Allow NULL? |
| 8 | PREQ_NAME | Name of Requisitioner/Requester | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AFNAM | Allow NULL? |
| 9 | PREQ_DATE | Requisition (Request) Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BADAT | Allow NULL? |
| 10 | SHORT_TEXT | Short Text | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | TXZ01 | Allow NULL? |
| 11 | MATERIAL | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | * | MATNR | Allow NULL? |
| 12 | PUR_MAT | Material Number Corresponding to Manufacturer Part Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | * | EMATN | Allow NULL? |
| 13 | PLANT | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | EWERK | Allow NULL? |
| 14 | STORE_LOC | Storage Location | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | LGORT_D | Allow NULL? |
| 15 | TRACKINGNO | Requirement Tracking Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | BEDNR | Allow NULL? |
| 16 | MAT_GRP | Material Group | nvarchar | 9 | 0 | CHAR | (N' ') | Yes | * | MATKL | Allow NULL? |
| 17 | SUPPL_PLNT | Supplying (Issuing) Plant in Stock Transport Order | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | RESWK | Allow NULL? |
| 18 | QUANTITY | Purchase Requisition Quantity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | BAMNG | |
| 19 | UNIT | Purchase Requisition Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | BAMEI | Allow NULL? |
| 20 | DEL_DATCAT | Date type (day, week, month, interval) | char | 1 | 0 | CHAR | (N' ') | Yes | | LPEIN_INT | Allow NULL? |
| 21 | DELIV_DATE | Item Delivery Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | EINDT | Allow NULL? |
| 22 | REL_DATE | Purchase Requisition Release Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FRGDT | Allow NULL? |
| 23 | C_AMT_BAPI | Price in purchase requisition | decimal | 23 | 4 | DEC | ((0)) | Yes | | BAPREBAPI | |
| 24 | PRICE_UNIT | Price Unit | decimal | 5 | 0 | DEC | ((0)) | Yes | | EPEIN | |
| 25 | ITEM_CAT | Item Category in Purchasing Document | char | 1 | 0 | CHAR | (N' ') | Yes | * | PSTYP | Allow NULL? |
| 26 | ACCTASSCAT | Account Assignment Category | char | 1 | 0 | CHAR | (N' ') | Yes | * | KNTTP | Allow NULL? |
| 27 | DISTRIB | Distribution indicator for multiple account assignment | char | 1 | 0 | CHAR | (N' ') | Yes | | VRTKZ | Allow NULL? |
| 28 | PART_INV | Partial Invoice Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | TWRKZ | Allow NULL? |
| 29 | GR_IND | Goods Receipt Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | WEPOS | Allow NULL? |
| 30 | GR_NON_VAL | Goods Receipt, Non-Valuated | char | 1 | 0 | CHAR | (N' ') | Yes | | WEUNB | Allow NULL? |
| 31 | IR_IND | Invoice Receipt Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | REPOS | Allow NULL? |
| 32 | DES_VENDOR | Desired Vendor | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | WLIEF | Allow NULL? |
| 33 | FIXED_VEND | Fixed Vendor | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | FLIEF | Allow NULL? |
| 34 | PURCH_ORG | Purchasing Organization | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | EKORG | Allow NULL? |
| 35 | AGREEMENT | Number of Principal Purchase Agreement | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KONNR | Allow NULL? |
| 36 | AGMT_ITEM | Item Number of Principal Purchase Agreement | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | * | KTPNR | Allow NULL? |
| 37 | INFO_REC | Number of Purchasing Info Record | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | INFNR | Allow NULL? |
| 38 | QUOTA_ARR | Number of Quota Arrangement | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | QUNUM | Allow NULL? |
| 39 | QUOTARRITM | Quota Arrangement Item | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | QUPOS | Allow NULL? |
| 40 | VAL_TYPE | Valuation Type | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | BWTAR_D | Allow NULL? |
| 41 | SPEC_STOCK | Special Stock Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | * | SOBKZ | Allow NULL? |
| 42 | PO_UNIT | Purchase Order Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | BSTME | Allow NULL? |
| 43 | PCKG_NO | Package number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | * | PACKNO | Allow NULL? |
| 44 | KANBAN_IND | Kanban indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | KBNK1 | Allow NULL? |
| 45 | PO_PRICE | Adopt Requisition Price in Purchase Order | char | 1 | 0 | CHAR | (N' ') | Yes | | BPUEB | Allow NULL? |
| 46 | INT_OBJ_NO | Configuration (internal object number) | nvarchar | 18 | 0 | NUMC | (N'000000000000000000') | Yes | | CUOBJ | Allow NULL? |
| 47 | PROMOTION | Promotion | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | WAKTION | Allow NULL? |
| 48 | BATCH | Batch Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | CHARG_D | Allow NULL? |
| 49 | VEND_MAT | Material number used by vendor | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | | IDNLF22 | Allow NULL? |
| 50 | CURRENCY | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS | Allow NULL? |
| 51 | MANUF_PROF | Manufacturer Part Profile | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | MPROF | Allow NULL? |
| 52 | MANU_MAT | Manufacturer Part Number | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | MFRPN | Allow NULL? |
| 53 | MFR_NO | Number of a Manufacturer | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | MFRNR | Allow NULL? |
| 54 | MFR_NO_EXT | External manufacturer code name or number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | EMNFR | Allow NULL? |
| 55 | DEL_DATCAT_EXT | Category of Delivery Date | char | 1 | 0 | CHAR | (N' ') | Yes | * | LPEIN | Allow NULL? |
| 56 | CURRENCY_ISO | ISO Currency Code | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | BAPIISOCD | Allow NULL? |
| 57 | ITEM_CAT_EXT | Item Category in Purchasing Document | char | 1 | 0 | CHAR | (N' ') | Yes | | EPSTP | Allow NULL? |
| 58 | PREQ_UNIT_ISO | ISO code for unit of measure in purchase requisition | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | BAMEI_ISO | Allow NULL? |
| 59 | PO_UNIT_ISO | Order unit in ISO code | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | BSTME_ISO | Allow NULL? |
| 60 | FIXED_QUAN | Quantity is Fixed | char | 1 | 0 | CHAR | (N' ') | Yes | | FMENG | Allow NULL? |
| 61 | MOVEMENT | Goods Movement for Reservation Allowed | char | 1 | 0 | CHAR | (N' ') | Yes | | XWAOK | Allow NULL? |
| 62 | PROCESS_ID | Line already processed | char | 1 | 0 | CHAR | (N' ') | Yes | | BEAKZ | Allow NULL? |
| 63 | REQ_DATE | Requirement Date for the Component | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BDTER | Allow NULL? |
| 64 | RES_DATE | Base date for reservation | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BSTER | Allow NULL? |
| 65 | MOVE_TYPE | Movement Type (Inventory Management) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | BWART | Allow NULL? |
| 66 | MOVE_PLANT | Receiving/Issuing Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | UMWRK | Allow NULL? |
| 67 | MOVE_STLOC | Receiving/Issuing Storage Location | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | UMLGO | Allow NULL? |
| 68 | PRICE | Net price in purchasing document (in document currency) | decimal | 11 | 2 | CURR | ((0)) | Yes | | BBP_BPREI | |
| 69 | CATALOGID | Catalog ID from which the line was selected | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | CATALOG | Allow NULL? |
| 70 | AVAIL_QTY | Purchase Requisition Quantity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | BAMNG | |
| 71 | CO_CODE | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BUKRS | Allow NULL? |
| 72 | PRODUCT | Internal Unique ID of Product | varbinary | 16 | 0 | RAW | | Yes | | COMT_PRODUCT_GUID | |
| 73 | CATALOGITEM | Catalog Item (Unique Key) | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | CATALOGITEM | Allow NULL? |
| 74 | CATEGORY | Category GUID | varbinary | 16 | 0 | RAW | | Yes | | COMT_CATEGORY_GUID | |
| 75 | CATEGORY_ID | Category ID | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | COMT_CATEGORY_ID | Allow NULL? |
| 76 | CONFIG_KEY | Reference to Additional Configuration Data | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | OCI_CONFIG_KEY | Allow NULL? |
| 77 | LOGICAL_SYSTEM | Logical system | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | LOGSYS | Allow NULL? |
| 78 | PROC_GROUP | Responsible Purchasing Group | nvarchar | 14 | 0 | CHAR | (N' ') | Yes | | BBP_PROC_GROUP | Allow NULL? |
| 79 | PROC_ORG | Responsible Purchasing Organization | nvarchar | 14 | 0 | CHAR | (N' ') | Yes | | BBP_PROC_ORG | Allow NULL? |
| 80 | PCNUM | Procurement card number | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | * | BBPPCNUM | Allow NULL? |
| 81 | PCINS | Procurement card company | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BBPPCINS | Allow NULL? |
| 82 | PCDATE | Procurement card expiration date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BBPPCDATE | Allow NULL? |
| 83 | PCNAME | Name of procurement cardholder | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | BBPPCNAME | Allow NULL? |
| 84 | PARTNER | Business Partner Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | BU_PARTNER | Allow NULL? |
| 85 | PARTNER_GUID | Business Partner GUID | varbinary | 16 | 0 | RAW | | Yes | | BU_PARTNER_GUID | |
| 86 | GR_RCPT_GUID | Business Partner GUID | varbinary | 16 | 0 | RAW | | Yes | | BU_PARTNER_GUID | |
| 87 | IV_RCPT_GUID | Business Partner GUID | varbinary | 16 | 0 | RAW | | Yes | | BU_PARTNER_GUID | |
| 88 | LOGSYS_FI | Logical system | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | LOGSYS | Allow NULL? |
| 89 | PARTNER_PROD | Product Number of Vendor | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | BBP_PARTNER_PROD | Allow NULL? |
| 90 | EXT_QUOTE_ID | Number of an External RFx Response | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | BBP_EXT_QUOTE_ID | Allow NULL? |
| 91 | EXT_QUOTE_ITEM | Item of an External RFx Response | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | BBP_EXT_QUOTE_ITEM | Allow NULL? |
| 92 | SUBTYPE | Specification Purchase Item (e.g. Direct Material/Hierarch.) | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | BBP_I_SUBTYPE | Allow NULL? |
| 93 | CTR_GUID | Contract Template Item GUID | varbinary | 16 | 0 | RAW | | Yes | | BBP_CTR_I_GUID | |
| 94 | GR_RCPT_PLANT | Indicator: Goods Recipient is a Plant | char | 1 | 0 | CHAR | (N' ') | Yes | | BBP_GR_RCPT_PLANT | Allow NULL? |
| 95 | ORDERED_PROD | Product Name Entered | nvarchar | 54 | 0 | CHAR | (N' ') | Yes | | CRMT_ORDERED_PROD_DB | Allow NULL? |
| 96 | PRODUCT_SRC_SYS | Business Document Service: ID of Logical System | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | BBP_LOGSYS | Allow NULL? |
| 97 | TAX_CODE | Tax on Sales/Purchases Code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | BBP_MWSKZ | Allow NULL? |
