PURREQNITM_D - T_PURCHASEREQN T_PURCHASEREQNITEM
T_PURCHASEREQN T_PURCHASEREQNITEM information is stored in SAP table PURREQNITM_D.
It is part of development package APPL_MM_PUR_REQ_PROFNL in software component MM-PUR-REQ. This development package consists of objects that can be grouped under "S4HANA Artefacts : Manage Professional Purchase Requisition".
It is part of development package APPL_MM_PUR_REQ_PROFNL in software component MM-PUR-REQ. This development package consists of objects that can be grouped under "S4HANA Artefacts : Manage Professional Purchase Requisition".
Fields for table PURREQNITM_D
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | |
| DRAFTUUID | UUID serving as key (parent key, root key) | X | /BOBF/UUID | RAW | 16 | |
| PARENTDRAFTUUID | UUID serving as key (parent key, root key) | /BOBF/UUID | RAW | 16 | ||
| PURCHASEREQUISITION | Purchase requisition number | VDM_PURCHASEREQUISITION | CHAR | 20 | ||
| PURCHASEREQUISITIONITEM | Item number of purchase requisition | VDM_PURCHASEREQUISITIONITEM | NUMC | 10 | ||
| PURCHASEREQUISITIONITEMFOREDIT | Item number of purchase requisition | VDM_PURCHASEREQUISITIONITEM | NUMC | 10 | ||
| PURCHASINGDOCUMENT | Purchase order number | BSTNR | CHAR | 20 | ||
| PURCHASINGDOCUMENTITEM | Purchase order item number | BSTPO | NUMC | 10 | ||
| PURREQNRELEASESTATUS | Requisition Processing State | BANPR | CHAR | 4 | ||
| PURCHASEREQUISITIONTYPE | Purchase Requisition Document Type | BBSRT | CHAR | 8 | ||
| PURCHASINGDOCUMENTITEMCATEGORY | Item category in purchasing document | PSTYP | CHAR | 2 | ||
| PURCHASEREQUISITIONITEMTEXT | Short Text | TXZ01 | CHAR | 80 | ||
| ACCOUNTASSIGNMENTCATEGORY | Account Assignment Category | KNTTP | CHAR | 2 | ||
| MATERIAL | Material Number | MATNR | CHAR | 80 | ||
| MANUFACTURERMATERIAL | Material number corresponding to manufacturer part number | EMATN | CHAR | 80 | ||
| MANUFACTURERPARTPROFILE | Mfr part profile | MPROF | CHAR | 8 | ||
| MANUFACTURERPARTNMBR | Manufacturer Part Number | MFRPN | CHAR | 80 | ||
| MATERIALGROUP | Material Group | MATKL | CHAR | 18 | ||
| PURCHASINGDOCUMENTCATEGORY | Purchasing Document Category | BSTYP | CHAR | 2 | ||
| REQUESTEDQUANTITY | Purchase requisition quantity | BAMNG | QUAN | 7 | ||
| BASEUNIT | Purchase requisition unit of measure | BAMEI | UNIT | 6 | ||
| PURCHASEREQUISITIONPRICE | Price in Purchase Requisition | BAPRE | CURR | 6 | ||
| PURREQNPRICEQUANTITY | Price unit | EPEIN | DEC | 3 | ||
| MATERIALGOODSRECEIPTDURATION | Goods receipt processing time in days | WEBAZ | DEC | 2 | ||
| RELEASECODE | Release Indicator | FRGKZ | CHAR | 2 | ||
| PURCHASEREQUISITIONRELEASEDATE | Purchase Requisition Release Date | FRGDT | DATS | 16 | ||
| PURCHASINGORGANIZATION | Purchasing organization | EKORG | CHAR | 8 | ||
| PURCHASINGGROUP | Purchasing Group | EKGRP | CHAR | 6 | ||
| PLANT | Plant | EWERK | CHAR | 8 | ||
| SOURCEOFSUPPLYISASSIGNED | Assigned Source of Supply | DZUGBA | CHAR | 2 | ||
| SUPPLYINGPLANT | Supplying (issuing) plant in case of stock transport order | RESWK | CHAR | 8 | ||
| ORDEREDQUANTITY | Quantity ordered against this purchase requisition | BSMNG | QUAN | 7 | ||
| PURREQNLIMITCONSUMPTIONAMT | Consumption Value for Limit Items | MMPUR_REQ_LMT_CNSMPN_VALUE | CURR | 7 | ||
| DELIVERYDATE | Item delivery date | EINDT | DATS | 16 | ||
| CREATIONDATE | Requisition (request) date | BADAT | DATS | 16 | ||
| PROCESSINGSTATUS | Processing status of purchase requisition | BANST | CHAR | 2 | ||
| PURCHASINGINFORECORD | Number of purchasing info record | INFNR | CHAR | 20 | ||
| SUPPLIER | Desired Vendor | WLIEF | CHAR | 20 | ||
| ISDELETED | Deletion Indicator in Purchasing Document | ELOEK | CHAR | 2 | ||
| FIXEDSUPPLIER | Fixed Vendor | FLIEF | CHAR | 20 | ||
| REQUISITIONERNAME | Name of requisitioner/requester | AFNAM | CHAR | 24 | ||
| PURREQNSSPREQUESTOR | Requestor | MMPUR_REQ_D_REQUESTOR | CHAR | 120 | ||
| CREATEDBYUSER | Name of Person Responsible for Creating the Object | ERNAM | CHAR | 24 | ||
| PURREQCREATIONDATE | Requisition (request) date | BADAT | DATS | 16 | ||
| MANUALDELIVERYADDRESSID | Manual address number in purchasing document item | ADRNR_MM | CHAR | 20 | ||
| ITEMDELIVERYADDRESSID | Number of delivery address | ADRN2 | CHAR | 20 | ||
| DELIVERYADDRESSID | Address | ADRNR | CHAR | 20 | ||
| PURREQNITEMCURRENCY | Currency Key | WAERS | CUKY | 10 | ||
| MATERIALPLANNEDDELIVERYDURN | Planned Delivery Time in Days | PLIFZ | DEC | 2 | ||
| DELIVDATECATEGORY | Category of delivery date | LPEIN | CHAR | 2 | ||
| MULTIPLEACCTASSGMTDISTRIBUTION | Distribution Indicator for Multiple Account Assignment | VRTKZ | CHAR | 2 | ||
| PARTIALINVOICEDISTRIBUTION | Partial invoice indicator | TWRKZ | CHAR | 2 | ||
| STORAGELOCATION | Storage location | LGORT_D | CHAR | 8 | ||
| PURCHASECONTRACT | Number of principal purchase agreement | KONNR | CHAR | 20 | ||
| PURREQNSOURCEOFSUPPLYTYPE | Purchasing Document Category | BSTYP | CHAR | 2 | ||
| PURCHASECONTRACTITEM | Item number of principal purchase agreement | KTPNR | NUMC | 10 | ||
| CONSUMPTIONPOSTING | Consumption posting | KZVBR | CHAR | 2 | ||
| PURREQNORIGIN | Creation indicator (purchase requisition/schedule lines) | ESTKZ | CHAR | 2 | ||
| ISPURREQNBLOCKED | Purchase Requisition Blocked | BLCKD | CHAR | 2 | ||
| LANGUAGE | Language Key | SPRAS | LANG | 2 | ||
| ISCLOSED | Purchase requisition closed | EBAKZ | CHAR | 2 | ||
| RELEASEISNOTCOMPLETED | Release Not Yet Completely Effected | FRGRL | CHAR | 2 | ||
| SERVICEPERFORMER | Service Performer | SERVICEPERFORMER | CHAR | 20 | ||
| PRODUCTTYPE | Product Type Group | PRODUCT_TYPE | CHAR | 4 | ||
| PURCHASEREQUISITIONSTATUS | Release State | FRGZU | CHAR | 16 | ||
| RELEASESTRATEGY | Release strategy in the purchase requisition | FRGST | CHAR | 4 | ||
| PERFORMANCEPERIODSTARTDATE | Start Date for Period of Performance | MMPUR_SERVPROC_PERIOD_START | DATS | 16 | ||
| PERFORMANCEPERIODENDDATE | End Date for Period of Performance | MMPUR_SERVPROC_PERIOD_END | DATS | 16 | ||
| SUPPLIERMATERIALNUMBER | Material Number Used by Supplier | IDNLF | CHAR | 70 | ||
| BATCH | Batch Number | CHARG_D | CHAR | 20 | ||
| MATERIALREVISIONLEVEL | Revision Level | REVLV | CHAR | 4 | ||
| MINREMAININGSHELFLIFE | Minimum Remaining Shelf Life | MHDRZ | DEC | 3 | ||
| GOODSRECEIPTISEXPECTED | Goods Receipt Indicator | WEPOS | CHAR | 2 | ||
| INVOICEISEXPECTED | Invoice receipt indicator | REPOS | CHAR | 2 | ||
| GOODSRECEIPTISNONVALUATED | Goods Receipt, Non-Valuated | WEUNB | CHAR | 2 | ||
| REQUIREMENTTRACKING | Requirement Tracking Number | BEDNR | CHAR | 20 | ||
| MRPCONTROLLER | MRP Controller | DISPO | CHAR | 6 | ||
| TAXCODE | Tax on sales/purchases code | MWSKZ | CHAR | 4 | ||
| PURCHASEREQUISITIONISFIXED | Purchase requisition is fixed | BAFIX | CHAR | 2 | ||
| PURCHASINGDOCUMENTSUBTYPE | Control indicator for purchasing document type | BSAKZ | CHAR | 2 | ||
| PURREQNCATALOG | Technical Key of a Web Service (for Example - a Catalog) | BBP_WS_SERVICE_ID | CHAR | 40 | ||
| PURREQNCATALOGITEM | Catalog Item Id | MMPUR_REQ_D_CATALOGITEM | CHAR | 80 | ||
| PURREQNCROSSCATALOGITEM | Catalog Item Key | MMPUR_CAT_D_ITM_KEY | INT4 | 4 | ||
| USERDESCRIPTION | User Description | VDM_USERDESCRIPTION | CHAR | 160 | ||
| EXPECTEDOVERALLLIMITAMOUNT | Expected Value of Overall Limit | COMMITMENT | CURR | 7 | ||
| OVERALLLIMITAMOUNT | Overall Limit | SUMLIMIT | CURR | 7 | ||
| PURCHASEREQNITEMUNIQUEID | Key to identify purchase requisition item | MM_PUR_PR_ITEM_KEY | CHAR | 30 | ||
| PURCHASEORDERPRICETYPE | Use Requisition Price in Purchase Order | BPUEB | CHAR | 2 | ||
| ISPURREQNOVRLREL | Overall release of purchase requisitions | GSFRG | CHAR | 2 | ||
| ITEMNETAMOUNT | PURREQNITEMCURRENCY | CURR | 8 | |||
| EXTERNALAPPROVALSTATUS | External Processing Status | MMPUR_REQ_EXTAPPRVLSTS | CHAR | 2 | ||
| COMMITMENTITEM | Commitment Item | FIPOS | CHAR | 28 | ||
| FUNDSCENTER | Funds Center | FISTL | CHAR | 32 | ||
| FUND | Fund | BP_GEBER | CHAR | 20 | ||
| GRANTID | Grant | GM_GRANT_NBR | CHAR | 40 | ||
| FUNCTIONALAREA | Functional Area | FKBER | CHAR | 32 | ||
| EARMARKEDFUNDSDOCUMENT | Document Number for Earmarked Funds | KBLNR | CHAR | 20 | ||
| EARMARKEDFUNDSDOCUMENTITEM | Earmarked Funds: Document Item | KBLPOS | NUMC | 6 | ||
| BUDGETPERIOD | Budget Period | FM_BUDGET_PERIOD | CHAR | 20 | ||
| COSTCENTER | Cost Center | KOSTL | CHAR | 20 | ||
| GLACCOUNT | G/L Account Number | SAKNR | CHAR | 20 | ||
| WBSELEMENT | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 16 | ||
| FUNDEDPROGRAM | CHAR | 48 | ||||
| FUNDMGMTISACTIVE | Truth Value: True/False | ABAP_BOOLEAN | CHAR | 2 | ||
| PURREQNREWORKCOMMENTTEXT | Note Text | MMPUR_NOTE_TEXT | STRG | 8 | ||
| PURREQNREJECTIONISCANCELLED | Truth Value: True/False | ABAP_BOOLEAN | CHAR | 2 | ||
| ISOUTLINE | Is Outline | MMPUR_REQ_IS_OUTLINE | CHAR | 2 | ||
| PURCHASINGPARENTITEM | Parent Item No | MMPUR_REQ_PARENT_ITEM_NO | NUMC | 10 | ||
| PURREQNITEMOUTLINETYPE | Outline Type | MMPUR_REQ_OUTLINE_TYPE | CHAR | 2 | ||
| PURGCONFIGURABLEITEMNUMBER | Hierarchy Number | EXLIN | CHAR | 80 | ||
| PURGEXTERNALSORTNUMBER | External Sort Number | EXSNR | NUMC | 10 | ||
| PURCHASINGSIBLINGHIERARCHYITEM | Sibling Item of Hierarchy | MMPUR_SIBLING_HIER_ITEM | NUMC | 10 | ||
| HIERARCHYNODE | Hierarchy node | RSNODEEXT | SSTR | 8 | ||
| HIERARCHYPARENTNODE | Hierarchy node | RSNODEEXT | SSTR | 8 | ||
| HIERARCHYLEVEL | INT4 | 4 | ||||
| HIERARCHYNODESUBTREESIZE | INT4 | 4 | ||||
| HIERARCHYDRILLSTATE | CHAR | 44 | ||||
| HIERARCHYNODEORDINALNUMBER | INT8 | 8 | ||||
| HASACTIVEENTITY | Draft - Indicator - Has active document | SDRAFT_HAS_ACTIVE | CHAR | 2 | ||
| .INCLUDE | SDRAFT_WRITE_DRAFT_ADMIN | 0 | ||||
| DRAFTENTITYCREATIONDATETIME | Draft Created On | SDRAFT_CREATED_AT | DEC | 11 | ||
| DRAFTENTITYLASTCHANGEDATETIME | Draft Last Changed On | SDRAFT_LAST_CHANGED_AT | DEC | 11 | ||
| DRAFTADMINISTRATIVEDATAUUID | Technical ID for the Administrative Data of a Draft Document | SDRAFT_ADMIN_UUID | RAW | 16 | ||
| DRAFTENTITYCONSISTENCYSTATUS | Draft - Consistency Status | SDRAFT_CONSISTENCY_STATUS | CHAR | 2 | ||
| DRAFTENTITYOPERATIONCODE | Draft - Operation Code | SDRAFT_OPERATION_CODE | CHAR | 2 | ||
| .INCLUDE | EBAN_INCL_EEW_PS | 0 | ||||
| .INCLUDE | CI_EBANDB | 0 | ||||
| DUMMY_EBAN_INCL_EEW_PS | Data element for purchase requisition extensibility | EBAN_INCL_EEW | CHAR | 2 |