CNTRLPCITMTP_D

Transparent Table Application Table
93 Fields 1 CDS Views

I_CENTRALPURCHASECONTRACTTP I_CNTRLPURCHASECONTRACTITEMTP

CNTRLPCITMTP_D is an SAP database table in S/4HANA. I_CENTRALPURCHASECONTRACTTP I_CNTRLPURCHASECONTRACTITEMTP. It contains 93 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_CePuCoItemHierDraftSource view from BASIC Source View for Draft CCTR Hierarchy

Fields (93)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY draftuuid /BOBF/UUID Key
parentdraftuuid /BOBF/UUID Key
centralpurchasecontractitem VDM_CNTRLPURCHASECONTRACTITEM Item in Central Purchase Contract
centralpurchasecontract VDM_CENTRALPURCHASECONTRACT Central Purchase Contract
material MATNR Material
purchasecontractitemtext TXZ01 Short Text
contractnetpriceamount BPREI Net Price
orderpriceunit BBPRM Order Price Un.
volumeunit VOLEH Volume Unit
orderquantityunit BSTME Order Unit
materialgroup MATKL Material Group
customer EKUNNR Customer
subcontractor EMLIF Supplier
referencedeliveryaddressid MM_OA_REF_ADDRESS Reference Address
manualdeliveryaddressid AD_ADDRNUM Address Number
plant EWERK Plant
storagelocation VDM_STORAGE_LOCATION Storage Location
accountassignmentcategory KNTTP Acct Assgmt Cat
goodsreceiptisexpected WEPOS Goods Receipt
netpricequantity VDM_PRICE_UNIT Price Unit
multipleacctassgmtdistribution VRTKZ Distribution
partialinvoicedistribution TWRKZ Partial invoice
targetquantity KTMNG Target Quantity
targetamount DZWERT Target Value
documentcurrency WAERS Currency
ordpriceunittoorderunitdnmntr BPUMN Qty Conversion
orderpriceunittoorderunitnmrtr MM_OA_CONV_UNIT_NMRTR Qty. Conv. Numerator
purchasingdocumentitemcategory PSTYP Item Category
suppliermaterialnumber IDNLF Supp. Mat. No.
evaldrcptsettlmtisallowed XERSY ERS
underdelivtolrtdlmtratioinpct UNTTO Underdel. Tol.
priceistobeprinted PRSDR Print Price
supplierconfirmationcontrolkey BSTAE Conf. Control
overdelivtolrtdlmtratioinpct UEBTO Overdeliv. Tol.
unlimitedoverdeliveryisallowed UEBTK Unlimited
invoiceisexpected REPOS Invoice Receipt
invoiceisgoodsreceiptbased WEBRE GR-Based IV
purgdocpricedate PREDT Price Date
isinforecordupdated SPINF InfoUpdate
purgdocreleaseorderquantity NORAM Rel. order qty.
purgdocorderacknnumber LABNR Order Acknowl.
purgdocestimatedprice SCHPR Estimated Price
isinfoatregistration MM_OA_INFOATREGN InfoAtReg.
nodaysreminder1 MAHN1 1st Rem./Exped.
nodaysreminder2 MAHN2 2nd Rem./Exped.
nodaysreminder3 MAHN3 3rd Rem./Exped.
stocktype INSMK Stock Type
taxcode MWSKZ Tax Code
requirementtracking BEDNR Tracking Number
isorderacknrqd KZABS Acknowl. Reqd.
shippinginstruction EVERS Shipping Instr.
goodsreceiptisnonvaluated WEUNB GR Non-Valuated
serviceperformer SERVICEPERFORMER Service Performer
producttype PRODUCT_TYPE Product Type Group
materialtype MTART Material Type
formattedpurchasecontractitem abap.char
purchaserequisition BANFN Purchase Req.
purchaserequisitionitem BNFPO Requisn. item
purchasingcontractdeletioncode ELOEK Del. Indicator
textisdeleted BOOLEAN Boolean Variable (X = True, - = False, Space = Unknown)
outlineagrmtitmblockedtext BOOLEAN Boolean Variable (X = True, - = False, Space = Unknown)
purgdocitmblkrsncode BLK_REASON_ID Block Reason ID
purgdocitemrenegotiationstatus MEPROC_RENOGSTATE Renegotiation Status
purchasingcentralmaterial MM_PUR_HUB_MATNR Material
cntrlpurcontritmtargetamount ME_PUR_HUB_ITM_TARGET_VAL Item Target Value
procmthubrefcdconnectedsystem MM_PUR_SOURCE_SYS Source Connected Sys
isendofpurposeblocked EOPBLOCKED Busin. Purp. Cmpltd.
purchasingdocumentitemuniqueid PURCHASINGDOCUMENTITEMUNIQUEID Document Item
cntrlpurcontrgrconsumptionpct abap.dec
releaseorderitemquantityunit BSTME Order Unit
cntrlpurcontractgrquantity abap.quan
releaseordercurrency WAERS Currency
cntrlpurcontractgramount abap.curr
purchasingparentitem UEBPO H-Lev. Item
isstatisticalitem STAPO Statistical
hierarchynode RSNODEEXT Hier.node
hierarchyparentnode RSNODEEXT Hier.node
hierarchylevel abap.int4
hierarchynodesubtreesize abap.int4
hierarchydrillstate abap.char
hierarchynodeordinalnumber abap.int8
isoutline XFELD Checkbox
purgconfigurableitemnumber EXLIN Hierarchy Number
purgdocaggrgdsubitemcategory UPVOR Sub-items
purgexternalsortnumber EXSNR External Sort No.
hasactiveentity SDRAFT_HAS_ACTIVE Has active
draftentitycreationdatetime SDRAFT_CREATED_AT Draft Created On
draftentitylastchangedatetime SDRAFT_LAST_CHANGED_AT Draft Last Changed On
draftadministrativedatauuid SDRAFT_ADMIN_UUID Draft Adminv Data ID
draftentityconsistencystatus SDRAFT_CONSISTENCY_STATUS Consistency Status
draftentityoperationcode SDRAFT_OPERATION_CODE Draft - Operation Code
dummy_ekpo_incl_eew_ps EKPO_INCL_EEW Ext. Include

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- I_CENTRALPURCHASECONTRACTTP I_CNTRLPURCHASECONTRACTITEMTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CNTRLPCITMTP_D (
    MANDT,                           -- Client [MANDT]
    DRAFTUUID,                       -- Key [/BOBF/UUID]
    PARENTDRAFTUUID,                 -- Key [/BOBF/UUID]
    CENTRALPURCHASECONTRACTITEM,     -- Item in Central Purchase Contract [VDM_CNTRLPURCHASECONTRACTITEM]
    CENTRALPURCHASECONTRACT,         -- Central Purchase Contract [VDM_CENTRALPURCHASECONTRACT]
    MATERIAL,                        -- Material [MATNR]
    PURCHASECONTRACTITEMTEXT,        -- Short Text [TXZ01]
    CONTRACTNETPRICEAMOUNT,          -- Net Price [BPREI]
    ORDERPRICEUNIT,                  -- Order Price Un. [BBPRM]
    VOLUMEUNIT,                      -- Volume Unit [VOLEH]
    ORDERQUANTITYUNIT,               -- Order Unit [BSTME]
    MATERIALGROUP,                   -- Material Group [MATKL]
    CUSTOMER,                        -- Customer [EKUNNR]
    SUBCONTRACTOR,                   -- Supplier [EMLIF]
    REFERENCEDELIVERYADDRESSID,      -- Reference Address [MM_OA_REF_ADDRESS]
    MANUALDELIVERYADDRESSID,         -- Address Number [AD_ADDRNUM]
    PLANT,                           -- Plant [EWERK]
    STORAGELOCATION,                 -- Storage Location [VDM_STORAGE_LOCATION]
    ACCOUNTASSIGNMENTCATEGORY,       -- Acct Assgmt Cat [KNTTP]
    GOODSRECEIPTISEXPECTED,          -- Goods Receipt [WEPOS]
    NETPRICEQUANTITY,                -- Price Unit [VDM_PRICE_UNIT]
    MULTIPLEACCTASSGMTDISTRIBUTION,  -- Distribution [VRTKZ]
    PARTIALINVOICEDISTRIBUTION,      -- Partial invoice [TWRKZ]
    TARGETQUANTITY,                  -- Target Quantity [KTMNG]
    TARGETAMOUNT,                    -- Target Value [DZWERT]
    DOCUMENTCURRENCY,                -- Currency [WAERS]
    ORDPRICEUNITTOORDERUNITDNMNTR,   -- Qty Conversion [BPUMN]
    ORDERPRICEUNITTOORDERUNITNMRTR,  -- Qty. Conv. Numerator [MM_OA_CONV_UNIT_NMRTR]
    PURCHASINGDOCUMENTITEMCATEGORY,  -- Item Category [PSTYP]
    SUPPLIERMATERIALNUMBER,          -- Supp. Mat. No. [IDNLF]
    EVALDRCPTSETTLMTISALLOWED,       -- ERS [XERSY]
    UNDERDELIVTOLRTDLMTRATIOINPCT,   -- Underdel. Tol. [UNTTO]
    PRICEISTOBEPRINTED,              -- Print Price [PRSDR]
    SUPPLIERCONFIRMATIONCONTROLKEY,  -- Conf. Control [BSTAE]
    OVERDELIVTOLRTDLMTRATIOINPCT,    -- Overdeliv. Tol. [UEBTO]
    UNLIMITEDOVERDELIVERYISALLOWED,  -- Unlimited [UEBTK]
    INVOICEISEXPECTED,               -- Invoice Receipt [REPOS]
    INVOICEISGOODSRECEIPTBASED,      -- GR-Based IV [WEBRE]
    PURGDOCPRICEDATE,                -- Price Date [PREDT]
    ISINFORECORDUPDATED,             -- InfoUpdate [SPINF]
    PURGDOCRELEASEORDERQUANTITY,     -- Rel. order qty. [NORAM]
    PURGDOCORDERACKNNUMBER,          -- Order Acknowl. [LABNR]
    PURGDOCESTIMATEDPRICE,           -- Estimated Price [SCHPR]
    ISINFOATREGISTRATION,            -- InfoAtReg. [MM_OA_INFOATREGN]
    NODAYSREMINDER1,                 -- 1st Rem./Exped. [MAHN1]
    NODAYSREMINDER2,                 -- 2nd Rem./Exped. [MAHN2]
    NODAYSREMINDER3,                 -- 3rd Rem./Exped. [MAHN3]
    STOCKTYPE,                       -- Stock Type [INSMK]
    TAXCODE,                         -- Tax Code [MWSKZ]
    REQUIREMENTTRACKING,             -- Tracking Number [BEDNR]
    ISORDERACKNRQD,                  -- Acknowl. Reqd. [KZABS]
    SHIPPINGINSTRUCTION,             -- Shipping Instr. [EVERS]
    GOODSRECEIPTISNONVALUATED,       -- GR Non-Valuated [WEUNB]
    SERVICEPERFORMER,                -- Service Performer [SERVICEPERFORMER]
    PRODUCTTYPE,                     -- Product Type Group [PRODUCT_TYPE]
    MATERIALTYPE,                    -- Material Type [MTART]
    FORMATTEDPURCHASECONTRACTITEM,   -- abap.char
    PURCHASEREQUISITION,             -- Purchase Req. [BANFN]
    PURCHASEREQUISITIONITEM,         -- Requisn. item [BNFPO]
    PURCHASINGCONTRACTDELETIONCODE,  -- Del. Indicator [ELOEK]
    TEXTISDELETED,                   -- Boolean Variable (X = True, - = False, Space = Unknown) [BOOLEAN]
    OUTLINEAGRMTITMBLOCKEDTEXT,      -- Boolean Variable (X = True, - = False, Space = Unknown) [BOOLEAN]
    PURGDOCITMBLKRSNCODE,            -- Block Reason ID [BLK_REASON_ID]
    PURGDOCITEMRENEGOTIATIONSTATUS,  -- Renegotiation Status [MEPROC_RENOGSTATE]
    PURCHASINGCENTRALMATERIAL,       -- Material [MM_PUR_HUB_MATNR]
    CNTRLPURCONTRITMTARGETAMOUNT,    -- Item Target Value [ME_PUR_HUB_ITM_TARGET_VAL]
    PROCMTHUBREFCDCONNECTEDSYSTEM,   -- Source Connected Sys [MM_PUR_SOURCE_SYS]
    ISENDOFPURPOSEBLOCKED,           -- Busin. Purp. Cmpltd. [EOPBLOCKED]
    PURCHASINGDOCUMENTITEMUNIQUEID,  -- Document Item [PURCHASINGDOCUMENTITEMUNIQUEID]
    CNTRLPURCONTRGRCONSUMPTIONPCT,   -- abap.dec
    RELEASEORDERITEMQUANTITYUNIT,    -- Order Unit [BSTME]
    CNTRLPURCONTRACTGRQUANTITY,      -- abap.quan
    RELEASEORDERCURRENCY,            -- Currency [WAERS]
    CNTRLPURCONTRACTGRAMOUNT,        -- abap.curr
    PURCHASINGPARENTITEM,            -- H-Lev. Item [UEBPO]
    ISSTATISTICALITEM,               -- Statistical [STAPO]
    HIERARCHYNODE,                   -- Hier.node [RSNODEEXT]
    HIERARCHYPARENTNODE,             -- Hier.node [RSNODEEXT]
    HIERARCHYLEVEL,                  -- abap.int4
    HIERARCHYNODESUBTREESIZE,        -- abap.int4
    HIERARCHYDRILLSTATE,             -- abap.char
    HIERARCHYNODEORDINALNUMBER,      -- abap.int8
    ISOUTLINE,                       -- Checkbox [XFELD]
    PURGCONFIGURABLEITEMNUMBER,      -- Hierarchy Number [EXLIN]
    PURGDOCAGGRGDSUBITEMCATEGORY,    -- Sub-items [UPVOR]
    PURGEXTERNALSORTNUMBER,          -- External Sort No. [EXSNR]
    HASACTIVEENTITY,                 -- Has active [SDRAFT_HAS_ACTIVE]
    DRAFTENTITYCREATIONDATETIME,     -- Draft Created On [SDRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Draft Last Changed On [SDRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- Draft Adminv Data ID [SDRAFT_ADMIN_UUID]
    DRAFTENTITYCONSISTENCYSTATUS,    -- Consistency Status [SDRAFT_CONSISTENCY_STATUS]
    DRAFTENTITYOPERATIONCODE,        -- Draft - Operation Code [SDRAFT_OPERATION_CODE]
    DUMMY_EKPO_INCL_EEW_PS,          -- Ext. Include [EKPO_INCL_EEW]
    PRIMARY KEY (MANDT, DRAFTUUID)
);

Learn More