| 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 | BANFN | Purchase Requisition Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | | BANFN | Allow NULL? |
| 3 | BNFPO | Item Number of Purchase Requisition | nvarchar | 5 | 0 | NUMC | (N'00000') | No | * | BNFPO | Allow NULL? |
| 4 | BSART | Purchase Requisition Document Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BBSRT | Allow NULL? |
| 5 | BSTYP | Purchasing Document Category | char | 1 | 0 | CHAR | (N' ') | Yes | | BSTYP | Allow NULL? |
| 6 | BSAKZ | Control indicator for purchasing document type | char | 1 | 0 | CHAR | (N' ') | Yes | | BSAKZ | Allow NULL? |
| 7 | LOEKZ | Deletion Indicator in Purchasing Document | char | 1 | 0 | CHAR | (N' ') | Yes | | ELOEK | Allow NULL? |
| 8 | STATU | Processing status of purchase requisition | char | 1 | 0 | CHAR | (N' ') | Yes | | BANST | Allow NULL? |
| 9 | ESTKZ | Creation Indicator (Purchase Requisition/Schedule Lines) | char | 1 | 0 | CHAR | (N' ') | Yes | | ESTKZ | Allow NULL? |
| 10 | FRGKZ | Release Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | * | FRGKZ | Allow NULL? |
| 11 | FRGZU | Release status | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | FRGZU | Allow NULL? |
| 12 | FRGST | Release Strategy in Purchase Requisition | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | FRGST | Allow NULL? |
| 13 | EKGRP | Purchasing Group | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | EKGRP | Allow NULL? |
| 14 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM | Allow NULL? |
| 15 | ERDAT | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AEDAT | Allow NULL? |
| 16 | AFNAM | Name of Requisitioner/Requester | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AFNAM | Allow NULL? |
| 17 | TXZ01 | Short Text | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | TXZ01 | Allow NULL? |
| 18 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | * | MATNR | Allow NULL? |
| 19 | EMATN | Material Number Corresponding to Manufacturer Part Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | * | EMATN | Allow NULL? |
| 20 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | EWERK | Allow NULL? |
| 21 | LGORT | Storage Location | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | LGORT_D | Allow NULL? |
| 22 | BEDNR | Requirement Tracking Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | BEDNR | Allow NULL? |
| 23 | MATKL | Material Group | nvarchar | 9 | 0 | CHAR | (N' ') | Yes | * | MATKL | Allow NULL? |
| 24 | RESWK | Supplying (Issuing) Plant in Stock Transport Order | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | RESWK | Allow NULL? |
| 25 | MENGE | Purchase Requisition Quantity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | BAMNG | |
| 26 | MEINS | Purchase Requisition Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | BAMEI | Allow NULL? |
| 27 | BUMNG | Shortage (stock undercoverage) quantity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | BUMNG | |
| 28 | BADAT | Requisition (Request) Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BADAT | Allow NULL? |
| 29 | LPEIN | Category of Delivery Date | char | 1 | 0 | CHAR | (N' ') | Yes | * | LPEIN | Allow NULL? |
| 30 | LFDAT | Item Delivery Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | EINDT | Allow NULL? |
| 31 | FRGDT | Purchase Requisition Release Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FRGDT | Allow NULL? |
| 32 | WEBAZ | Goods Receipt Processing Time in Days | decimal | 3 | 0 | DEC | ((0)) | Yes | | WEBAZ | |
| 33 | PREIS | Price in Purchase Requisition | decimal | 11 | 2 | CURR | ((0)) | Yes | | BAPRE | |
| 34 | PEINH | Price Unit | decimal | 5 | 0 | DEC | ((0)) | Yes | | EPEIN | |
| 35 | PSTYP | Item Category in Purchasing Document | char | 1 | 0 | CHAR | (N' ') | Yes | * | PSTYP | Allow NULL? |
| 36 | KNTTP | Account Assignment Category | char | 1 | 0 | CHAR | (N' ') | Yes | * | KNTTP | Allow NULL? |
| 37 | KZVBR | Consumption Posting | char | 1 | 0 | CHAR | (N' ') | Yes | | KZVBR | Allow NULL? |
| 38 | KFLAG | Acct.asst.changeable | char | 1 | 0 | CHAR | (N' ') | Yes | | KFLAG | Allow NULL? |
| 39 | VRTKZ | Distribution indicator for multiple account assignment | char | 1 | 0 | CHAR | (N' ') | Yes | | VRTKZ | Allow NULL? |
| 40 | TWRKZ | Partial Invoice Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | TWRKZ | Allow NULL? |
| 41 | WEPOS | Goods Receipt Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | WEPOS | Allow NULL? |
| 42 | WEUNB | Goods Receipt, Non-Valuated | char | 1 | 0 | CHAR | (N' ') | Yes | | WEUNB | Allow NULL? |
| 43 | REPOS | Invoice Receipt Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | REPOS | Allow NULL? |
| 44 | LIFNR | Desired Vendor | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | WLIEF | Allow NULL? |
| 45 | FLIEF | Fixed Vendor | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | FLIEF | Allow NULL? |
| 46 | EKORG | Purchasing Organization | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | EKORG | Allow NULL? |
| 47 | VRTYP | Purchasing Document Category | char | 1 | 0 | CHAR | (N' ') | Yes | | BSTYP | Allow NULL? |
| 48 | KONNR | Number of Principal Purchase Agreement | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KONNR | Allow NULL? |
| 49 | KTPNR | Item Number of Principal Purchase Agreement | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | * | KTPNR | Allow NULL? |
| 50 | INFNR | Number of Purchasing Info Record | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | INFNR | Allow NULL? |
| 51 | ZUGBA | Assigned Source of Supply | char | 1 | 0 | CHAR | (N' ') | Yes | | DZUGBA | Allow NULL? |
| 52 | QUNUM | Number of Quota Arrangement | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | QUNUM | Allow NULL? |
| 53 | QUPOS | Quota Arrangement Item | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | QUPOS | Allow NULL? |
| 54 | DISPO | MRP Controller (Materials Planner) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | DISPO | Allow NULL? |
| 55 | SERNR | BOM explosion number | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | * | SERNR | Allow NULL? |
| 56 | BVDAT | Date of last resubmission | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BVDAT | Allow NULL? |
| 57 | BATOL | Resubmission Interval of Purchase Requisition | decimal | 3 | 0 | DEC | ((0)) | Yes | | BATOL | |
| 58 | BVDRK | Number of resubmissions | decimal | 7 | 0 | DEC | ((0)) | Yes | | BVDRK | |
| 59 | EBELN | Purchase Order Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | BSTNR | Allow NULL? |
| 60 | EBELP | Purchase Order Item Number | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | * | BSTPO | Allow NULL? |
| 61 | BEDAT | Purchase Order Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BEDAT | Allow NULL? |
| 62 | BSMNG | Quantity Ordered Against this Purchase Requisition | decimal | 13 | 3 | QUAN | ((0)) | Yes | | BSMNG | |
| 63 | LBLNI | Entry Sheet Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | LBLNI | Allow NULL? |
| 64 | BWTAR | Valuation Type | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | BWTAR_D | Allow NULL? |
| 65 | XOBLR | Item affects commitments | char | 1 | 0 | CHAR | (N' ') | Yes | | XOBLR | Allow NULL? |
| 66 | EBAKZ | Purchase Requisition Closed | char | 1 | 0 | CHAR | (N' ') | Yes | | EBAKZ | Allow NULL? |
| 67 | RSNUM | Number of Reservation/Dependent Requirement | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | * | RSNUM | Allow NULL? |
| 68 | SOBKZ | Special Stock Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | * | SOBKZ | Allow NULL? |
| 69 | ARSNR | Settlement reservation number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | ARSNR | Allow NULL? |
| 70 | ARSPS | Item number of the settlement reservation | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | ARSPS | Allow NULL? |
| 71 | FIXKZ | Purchase Requisition is Fixed | char | 1 | 0 | CHAR | (N' ') | Yes | | BAFIX | Allow NULL? |
| 72 | BMEIN | Purchase Order Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | BSTME | Allow NULL? |
| 73 | REVLV | Revision Level | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | REVLV | Allow NULL? |
| 74 | VORAB | Advance procurement: project stock | char | 1 | 0 | CHAR | (N' ') | Yes | | VORAB | Allow NULL? |
| 75 | PACKNO | Package number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | * | PACKNO | Allow NULL? |
| 76 | KANBA | Kanban Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | KBNKZ | Allow NULL? |
| 77 | BPUEB | Adopt Requisition Price in Purchase Order | char | 1 | 0 | CHAR | (N' ') | Yes | | BPUEB | Allow NULL? |
| 78 | CUOBJ | Configuration (internal object number) | nvarchar | 18 | 0 | NUMC | (N'000000000000000000') | Yes | | CUOBJ | Allow NULL? |
| 79 | FRGGR | Release group | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | FRGGR | Allow NULL? |
| 80 | FRGRL | Release Not Yet Completely Effected | char | 1 | 0 | CHAR | (N' ') | Yes | | FRGRL | Allow NULL? |
| 81 | AKTNR | Promotion | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | WAKTION | Allow NULL? |
| 82 | CHARG | Batch Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | CHARG_D | Allow NULL? |
| 83 | UMSOK | Special Stock Indicator for Physical Stock Transfer | char | 1 | 0 | CHAR | (N' ') | Yes | * | UMSOK | Allow NULL? |
| 84 | VERID | Production Version | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | VERID | Allow NULL? |
| 85 | FIPOS | Commitment Item | nvarchar | 14 | 0 | CHAR | (N' ') | Yes | * | FIPOS | Allow NULL? |
| 86 | FISTL | Funds Center | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | * | FISTL | Allow NULL? |
| 87 | GEBER | Fund | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | BP_GEBER | Allow NULL? |
| 88 | KZKFG | Origin of Configuration | char | 1 | 0 | CHAR | (N' ') | Yes | | KZCUH | Allow NULL? |
| 89 | SATNR | Cross-Plant Configurable Material | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | * | SATNR | Allow NULL? |
| 90 | MNG02 | Committed Quantity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | MNG06 | |
| 91 | DAT01 | Committed Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DAT05 | Allow NULL? |
| 92 | ATTYP | Material Category | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | ATTYP | Allow NULL? |
| 93 | ADRNR | Manual address number in purchasing document item | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | ADRNR_MM | Allow NULL? |
| 94 | ADRN2 | Number of delivery address | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | ADRN2 | Allow NULL? |
| 95 | KUNNR | Customer | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | EKUNNR | Allow NULL? |
| 96 | EMLIF | Vendor to be supplied/who is to receive delivery | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | EMLIF | Allow NULL? |
| 97 | LBLKZ | Subcontracting vendor | char | 1 | 0 | CHAR | (N' ') | Yes | | LBLKZ | Allow NULL? |
| 98 | KZBWS | Valuation of Special Stock | char | 1 | 0 | CHAR | (N' ') | Yes | | KZBWS | Allow NULL? |
| 99 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS | Allow NULL? |
| 100 | IDNLF | Material Number Used by Vendor | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | IDNLF | Allow NULL? |
| 101 | GSFRG | Overall release of purchase requisitions | char | 1 | 0 | CHAR | (N' ') | Yes | | GSFRG | Allow NULL? |
| 102 | MPROF | Manufacturer Part Profile | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | MPROF | Allow NULL? |
| 103 | KZFME | Units of measure usage | char | 1 | 0 | CHAR | (N' ') | Yes | | KZWSO | Allow NULL? |
| 104 | SPRAS | Language Key | char | 1 | 0 | LANG | (N' ') | Yes | * | SPRAS | Allow NULL? |
| 105 | TECHS | Parameter Variant/Standard Variant | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | TECHS | Allow NULL? |
| 106 | MFRPN | Manufacturer Part Number | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | MFRPN | Allow NULL? |
| 107 | MFRNR | Number of a Manufacturer | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | MFRNR | Allow NULL? |
| 108 | EMNFR | External manufacturer code name or number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | EMNFR | Allow NULL? |
| 109 | FORDN | Framework Order | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | SFORDN | Allow NULL? |
| 110 | FORDP | Item of framework order | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | * | FORDP | Allow NULL? |
| 111 | PLIFZ | Planned Delivery Time in Days | decimal | 3 | 0 | DEC | ((0)) | Yes | | PLIFZ | |
| 112 | BERID | MRP Area | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | BERID | Allow NULL? |
| 113 | UZEIT | Delivery Date Time-Spot | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | LZEIT | Allow NULL? |
