The CNTRLPCITMTP_D table in SAP ERP or S/4HANA stores I_CENTRALPURCHASECONTRACTTP I_CNTRLPURCHASECONTRACTITEMTP data. There are total 73 fields in CNTRLPCITMTP_D table. The I_CENTRALPURCHASECONTRACTTP I_CNTRLPURCHASECONTRACTITEMTP table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CNTRLPCITMTP_D table. It is in SAP S/4HANA Outline Agreements – Central Purchase Contract (APPL_MM_PUR_OA_CCTR) ABAP package and is part of the Vendor Outline Agreements (MM-PUR-OA) module.
SAP CNTRLPCITMTP_D Table Fields
Following is the list of fields that are available in SAP CNTRLPCITMTP_D table. The primary key fields of the table are MANDT (Client), DRAFTUUID (UUID serving as key (parent key, root key)).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| DRAFTUUID | UUID serving as key (parent key, root key) | /BOBF/UUID | RAW (16) | |
| PARENTDRAFTUUID | UUID serving as key (parent key, root key) | /BOBF/UUID | RAW (16) | |
| CENTRALPURCHASECONTRACTITEM | Central Purchase Contract Item | VDM_CNTRLPURCHASECONTRACTITEM | NUMC (5) | |
| CENTRALPURCHASECONTRACT | Central Purchase Contract | VDM_CENTRALPURCHASECONTRACT | CHAR (10) | |
| MATERIAL | Material Number | MATNR | CHAR (40) | |
| PURCHASECONTRACTITEMTEXT | Short Text | TXZ01 | CHAR (40) | |
| CONTRACTNETPRICEAMOUNT | Net Price in Purchasing Document (in Document Currency) | BPREI | CURR (11) | |
| ORDERPRICEUNIT | Order Price Unit (Purchasing) | BBPRM | UNIT (3) | |
| VOLUMEUNIT | Volume unit | VOLEH | UNIT (3) | |
| ORDERQUANTITYUNIT | Purchase Order Unit of Measure | BSTME | UNIT (3) | |
| MATERIALGROUP | Material Group | MATKL | CHAR (9) | |
| CUSTOMER | Customer | EKUNNR | CHAR (10) | |
| SUBCONTRACTOR | Supplier to be Supplied/Who is to Receive Delivery | EMLIF | CHAR (10) | |
| REFERENCEDELIVERYADDRESSID | Reference Delivery Address | MM_OA_REF_ADDRESS | CHAR (10) | |
| MANUALDELIVERYADDRESSID | Manual address number in purchasing document item | ADRNR_MM | CHAR (10) | |
| PLANT | Plant | EWERK | CHAR (4) | |
| STORAGELOCATION | Storage Location | VDM_STORAGE_LOCATION | CHAR (4) | |
| ACCOUNTASSIGNMENTCATEGORY | Account Assignment Category | KNTTP | CHAR (1) | |
| GOODSRECEIPTISEXPECTED | Goods Receipt Indicator | WEPOS | CHAR (1) | |
| NETPRICEQUANTITY | Price Unit | VDM_PRICE_UNIT | DEC (5) | |
| MULTIPLEACCTASSGMTDISTRIBUTION | Distribution Indicator for Multiple Account Assignment | VRTKZ | CHAR (1) | |
| PARTIALINVOICEDISTRIBUTION | Partial invoice indicator | TWRKZ | CHAR (1) | |
| TARGETQUANTITY | Target Quantity | KTMNG | QUAN (13) | |
| TARGETAMOUNT | Target Value for Outline Agreement in Document Currency | DZWERT | CURR (13) | |
| DOCUMENTCURRENCY | Currency Key | WAERS | CUKY (5) | |
| ORDPRICEUNITTOORDERUNITDNMNTR | Denominator for Conv. of Order Price Unit into Order Unit | BPUMN | DEC (5) | |
| ORDERPRICEUNITTOORDERUNITNMRTR | Numerator for Conversion of Order Price Unit into Order Unit | MM_OA_CONV_UNIT_NMRTR | DEC (5) | |
| PURCHASINGDOCUMENTITEMCATEGORY | Item category in purchasing document | PSTYP | CHAR (1) | |
| SUPPLIERMATERIALNUMBER | Material Number Used by Supplier | IDNLF | CHAR (35) | |
| EVALDRCPTSETTLMTISALLOWED | Evaluated Receipt Settlement (ERS) | XERSY | CHAR (1) | |
| UNDERDELIVTOLRTDLMTRATIOINPCT | Underdelivery Tolerance | UNTTO | DEC (3) | |
| PRICEISTOBEPRINTED | Price Printout | PRSDR | CHAR (1) | |
| SUPPLIERCONFIRMATIONCONTROLKEY | Confirmation Control Key | BSTAE | CHAR (4) | |
| OVERDELIVTOLRTDLMTRATIOINPCT | Overdelivery Tolerance | UEBTO | DEC (3) | |
| UNLIMITEDOVERDELIVERYISALLOWED | Unlimited Overdelivery Allowed | UEBTK | CHAR (1) | |
| INVOICEISEXPECTED | Invoice receipt indicator | REPOS | CHAR (1) | |
| INVOICEISGOODSRECEIPTBASED | Indicator: GR-Based Invoice Verification | WEBRE | CHAR (1) | |
| PURGDOCPRICEDATE | Date of Price Determination | PREDT | DATS (8) | |
| ISINFORECORDUPDATED | Indicator: Update Info Record | SPINF | CHAR (1) | |
| PURGDOCRELEASEORDERQUANTITY | Standard release order quantity | NORAM | QUAN (13) | |
| PURGDOCORDERACKNNUMBER | Order Acknowledgment Number | LABNR | CHAR (20) | |
| PURGDOCESTIMATEDPRICE | Indicator: Estimated Price | SCHPR | CHAR (1) | |
| ISINFOATREGISTRATION | Info at Registration | MM_OA_INFOATREGN | CHAR (1) | |
| NODAYSREMINDER1 | Number of Days for First Reminder/Expediter | MAHN1 | DEC (3) | |
| NODAYSREMINDER2 | Number of Days for Second Reminder/Expediter | MAHN2 | DEC (3) | |
| NODAYSREMINDER3 | Number of Days for Third Reminder/Expediter | MAHN3 | DEC (3) | |
| STOCKTYPE | Stock Type | INSMK | CHAR (1) | |
| TAXCODE | Tax on sales/purchases code | MWSKZ | CHAR (2) | |
| REQUIREMENTTRACKING | Requirement Tracking Number | BEDNR | CHAR (10) | |
| ISORDERACKNRQD | Order Acknowledgment Requirement | KZABS | CHAR (1) | |
| SHIPPINGINSTRUCTION | Shipping Instructions | EVERS | CHAR (2) | |
| GOODSRECEIPTISNONVALUATED | Goods Receipt, Non-Valuated | WEUNB | CHAR (1) | |
| SERVICEPERFORMER | Service Performer | SERVICEPERFORMER | CHAR (10) | |
| PRODUCTTYPE | Product Type Group | PRODUCT_TYPE | CHAR (2) | |
| MATERIALTYPE | Material type | MTART | CHAR (4) | |
| PURCHASEREQUISITION | Purchase Requisition Number | BANFN | CHAR (10) | |
| PURCHASEREQUISITIONITEM | Item number of purchase requisition | BNFPO | NUMC (5) | |
| PURCHASINGCONTRACTDELETIONCODE | Deletion indicator in purchasing document | ELOEK | CHAR (1) | |
| TEXTISDELETED | Boolean Variable (X = True, – = False, Space = Unknown) | BOOLEAN | CHAR (1) | |
| PURCHASINGCENTRALMATERIAL | Material of External System | MM_PUR_HUB_MATNR | CHAR (40) | |
| CNTRLPURCONTRITMTARGETAMOUNT | Target Value at Item Level in Procurement Hub | ME_PUR_HUB_ITM_TARGET_VAL | CURR (15) | |
| ISENDOFPURPOSEBLOCKED | Business Purpose Completed | EOPBLOCKED | CHAR (1) | |
| PURCHASINGDOCUMENTITEMUNIQUEID | Concatenation of EBELN and EBELP | PURCHASINGDOCUMENTITEMUNIQUEID | CHAR (15) | |
| RELEASEORDERITEMQUANTITYUNIT | Purchase Order Unit of Measure | BSTME | UNIT (3) | |
| RELEASEORDERCURRENCY | Currency Key | WAERS | CUKY (5) | |
| HASACTIVEENTITY | Draft – Indicator – Has active document | SDRAFT_HAS_ACTIVE | CHAR (1) | |
| DRAFTENTITYCREATIONDATETIME | Draft Created On | SDRAFT_CREATED_AT | DEC (21) | |
| DRAFTENTITYLASTCHANGEDATETIME | Draft Last Changed On | SDRAFT_LAST_CHANGED_AT | DEC (21) | |
| DRAFTADMINISTRATIVEDATAUUID | Technical ID for the Administrative Data of a Draft Document | SDRAFT_ADMIN_UUID | RAW (16) | |
| DRAFTENTITYCONSISTENCYSTATUS | Draft Consistency Status | SDRAFT_CONSISTENCY_STATUS | CHAR (1) | |
| DRAFTENTITYOPERATIONCODE | Draft – Operation Code | SDRAFT_OPERATION_CODE | CHAR (1) | |
| DUMMY_EKPO_INCL_EEW_PS | Data Element for Extensibility of Purchasing Document Item | EKPO_INCL_EEW | CHAR (1) |
