CNTRLPCTP_D

Transparent Table Application Table
74 Fields 1 CDS Views

I_CENTRALPURCHASECONTRACTTP I_CENTRALPURCHASECONTRACTTP

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_CntrlPurchaseContractDraft view from BASIC Central Purchase Contracts Draft View

Fields (74)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY draftuuid /bobf/uuid Key
centralpurchasecontract vdm_centralpurchasecontract Central Purchase Contract
purchasecontracttype esart Document Type
purchasingdocumentcategory ebstyp Doc. Category
creationdate mmpur_erdat Created On
supplier md_supplier Supplier
purchasingdocumentsubtype bsakz Control
companycode bukrs Company Code
purchasingorganization ekorg Purchasing Org.
purchasinggroup bkgrp Purch. Group
documentcurrency waers Currency
currency waers Currency
incotermsclassification inco1 Incoterms
incotermstransferlocation inco2 Incoterms 2
paymentterms farp_dzterm Payment Terms
cashdiscount1days dzbd1t Days 1
cashdiscount2days dzbd2t Days 2
netpaymentdays dzbd3t Days Net
cashdiscount1percent dzbd1p CD Percentage 1
cashdiscount2percent dzbd2p CD Percentage 2
purchasecontracttargetamount ktwrt Target Value
validitystartdate vdm_validitystart Validity Start
validityenddate vdm_validityend Validity End
releasecode frgke Release ind.
createdbyuser mmpur_ernam Created By
purchasingdocumentdeletioncode eloek Del. Indicator
iscancelled boolean Boolean Variable (X = True, - = False, Space = Unknown)
supplieraddressid ad_addrnum Address Number
supplyingsupplier llief Goods Supplier
invoicingparty lifre Invoicing Party
exchangerate wkurs Exchange Rate
exchangerateisfixed kufix Fixed Exch.Rate
quotationsubmissiondate ihran Quotation Date
supplierquotation angnr Quotation
releaseisnotcompleted frgrl Subj.to Release
correspncexternalreference ihrez Your Reference
correspncinternalreference unsez Our Reference
supplierrespsalespersonname everk Salesperson
supplierphonenumber telfnr0 Supplier Phone
incotermsversion incov Inco. Version
incotermslocation1 inco2_l Inco. Location1
incotermslocation2 inco3_l Inco. Location2
purchasingdocumentname vdm_purgdoc_name Purch. Doc. Name
lastchangedatetime changedatetime Last Changed
cntrlpurcontrflxbldistrisallwd boolean Boolean Variable (X = True, - = False, Space = Unknown)
purchasingparentdocument mmpur_parent_document_id Parent Document ID
procmthubcompanycodegroupingid mmpur_d_cc_grouping_id Grouping ID
purchasingprocessingstatus meprocstate Proc. State
isendofpurposeblocked eopblocked Busin. Purp. Cmpltd.
activepurchasingdocument ebeln_ad Active Purchase Doc
purgdocchangerequeststatus cr_stat Change Request Stat.
purchasingdocumentversion revno Version
purgdocischgvers xfeld Checkbox
userdescription vdm_userdescription Description
purchasingdocumenttypename batxt Description
changerequestnote val_text Short Description
accworkflowapprover mm_oa_approver_id User
accworkflowapproverfirstname mm_oa_approver_name Full Name
approvalstatusname val_text Short Description
approveruser sww_aagent Agent
purgcontractisinpreparation boolean Boolean Variable (X = True, - = False, Space = Unknown)
purchasingdocumentstatus val_text Short Description
cntrlpurcontrovrldistrststxt me_distribution_status Distribution Status
cntrlpurcontrstatuscriticality mm_pur_cpc_val_criticality Val Status Critic.
cntrlpurcontrvaliditystatus abap.char
cntrlpurcontrvaldtystatustext val_text Short Description
cntrlpurcontrishierroot boolean Boolean Variable (X = True, - = False, Space = Unknown)
purchasingdocversionreasoncode rscod Reason
purchasingdocversionreasontext mmpur_vers_rsntext Reason Description
purchasingdocumentorigin estak Status
isextpurgscenario boolean Boolean Variable (X = True, - = False, Space = Unknown)
purchasingitemhashierarchy boolean Boolean Variable (X = True, - = False, Space = Unknown)
hasactiveentity sdraft_has_active Has active

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_CENTRALPURCHASECONTRACTTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CNTRLPCTP_D (
    MANDT,                           -- Client [mandt]
    DRAFTUUID,                       -- Key [/bobf/uuid]
    CENTRALPURCHASECONTRACT,         -- Central Purchase Contract [vdm_centralpurchasecontract]
    PURCHASECONTRACTTYPE,            -- Document Type [esart]
    PURCHASINGDOCUMENTCATEGORY,      -- Doc. Category [ebstyp]
    CREATIONDATE,                    -- Created On [mmpur_erdat]
    SUPPLIER,                        -- Supplier [md_supplier]
    PURCHASINGDOCUMENTSUBTYPE,       -- Control [bsakz]
    COMPANYCODE,                     -- Company Code [bukrs]
    PURCHASINGORGANIZATION,          -- Purchasing Org. [ekorg]
    PURCHASINGGROUP,                 -- Purch. Group [bkgrp]
    DOCUMENTCURRENCY,                -- Currency [waers]
    CURRENCY,                        -- Currency [waers]
    INCOTERMSCLASSIFICATION,         -- Incoterms [inco1]
    INCOTERMSTRANSFERLOCATION,       -- Incoterms 2 [inco2]
    PAYMENTTERMS,                    -- Payment Terms [farp_dzterm]
    CASHDISCOUNT1DAYS,               -- Days 1 [dzbd1t]
    CASHDISCOUNT2DAYS,               -- Days 2 [dzbd2t]
    NETPAYMENTDAYS,                  -- Days Net [dzbd3t]
    CASHDISCOUNT1PERCENT,            -- CD Percentage 1 [dzbd1p]
    CASHDISCOUNT2PERCENT,            -- CD Percentage 2 [dzbd2p]
    PURCHASECONTRACTTARGETAMOUNT,    -- Target Value [ktwrt]
    VALIDITYSTARTDATE,               -- Validity Start [vdm_validitystart]
    VALIDITYENDDATE,                 -- Validity End [vdm_validityend]
    RELEASECODE,                     -- Release ind. [frgke]
    CREATEDBYUSER,                   -- Created By [mmpur_ernam]
    PURCHASINGDOCUMENTDELETIONCODE,  -- Del. Indicator [eloek]
    ISCANCELLED,                     -- Boolean Variable (X = True, - = False, Space = Unknown) [boolean]
    SUPPLIERADDRESSID,               -- Address Number [ad_addrnum]
    SUPPLYINGSUPPLIER,               -- Goods Supplier [llief]
    INVOICINGPARTY,                  -- Invoicing Party [lifre]
    EXCHANGERATE,                    -- Exchange Rate [wkurs]
    EXCHANGERATEISFIXED,             -- Fixed Exch.Rate [kufix]
    QUOTATIONSUBMISSIONDATE,         -- Quotation Date [ihran]
    SUPPLIERQUOTATION,               -- Quotation [angnr]
    RELEASEISNOTCOMPLETED,           -- Subj.to Release [frgrl]
    CORRESPNCEXTERNALREFERENCE,      -- Your Reference [ihrez]
    CORRESPNCINTERNALREFERENCE,      -- Our Reference [unsez]
    SUPPLIERRESPSALESPERSONNAME,     -- Salesperson [everk]
    SUPPLIERPHONENUMBER,             -- Supplier Phone [telfnr0]
    INCOTERMSVERSION,                -- Inco. Version [incov]
    INCOTERMSLOCATION1,              -- Inco. Location1 [inco2_l]
    INCOTERMSLOCATION2,              -- Inco. Location2 [inco3_l]
    PURCHASINGDOCUMENTNAME,          -- Purch. Doc. Name [vdm_purgdoc_name]
    LASTCHANGEDATETIME,              -- Last Changed [changedatetime]
    CNTRLPURCONTRFLXBLDISTRISALLWD,  -- Boolean Variable (X = True, - = False, Space = Unknown) [boolean]
    PURCHASINGPARENTDOCUMENT,        -- Parent Document ID [mmpur_parent_document_id]
    PROCMTHUBCOMPANYCODEGROUPINGID,  -- Grouping ID [mmpur_d_cc_grouping_id]
    PURCHASINGPROCESSINGSTATUS,      -- Proc. State [meprocstate]
    ISENDOFPURPOSEBLOCKED,           -- Busin. Purp. Cmpltd. [eopblocked]
    ACTIVEPURCHASINGDOCUMENT,        -- Active Purchase Doc [ebeln_ad]
    PURGDOCCHANGEREQUESTSTATUS,      -- Change Request Stat. [cr_stat]
    PURCHASINGDOCUMENTVERSION,       -- Version [revno]
    PURGDOCISCHGVERS,                -- Checkbox [xfeld]
    USERDESCRIPTION,                 -- Description [vdm_userdescription]
    PURCHASINGDOCUMENTTYPENAME,      -- Description [batxt]
    CHANGEREQUESTNOTE,               -- Short Description [val_text]
    ACCWORKFLOWAPPROVER,             -- User [mm_oa_approver_id]
    ACCWORKFLOWAPPROVERFIRSTNAME,    -- Full Name [mm_oa_approver_name]
    APPROVALSTATUSNAME,              -- Short Description [val_text]
    APPROVERUSER,                    -- Agent [sww_aagent]
    PURGCONTRACTISINPREPARATION,     -- Boolean Variable (X = True, - = False, Space = Unknown) [boolean]
    PURCHASINGDOCUMENTSTATUS,        -- Short Description [val_text]
    CNTRLPURCONTROVRLDISTRSTSTXT,    -- Distribution Status [me_distribution_status]
    CNTRLPURCONTRSTATUSCRITICALITY,  -- Val Status Critic. [mm_pur_cpc_val_criticality]
    CNTRLPURCONTRVALIDITYSTATUS,     -- abap.char
    CNTRLPURCONTRVALDTYSTATUSTEXT,   -- Short Description [val_text]
    CNTRLPURCONTRISHIERROOT,         -- Boolean Variable (X = True, - = False, Space = Unknown) [boolean]
    PURCHASINGDOCVERSIONREASONCODE,  -- Reason [rscod]
    PURCHASINGDOCVERSIONREASONTEXT,  -- Reason Description [mmpur_vers_rsntext]
    PURCHASINGDOCUMENTORIGIN,        -- Status [estak]
    ISEXTPURGSCENARIO,               -- Boolean Variable (X = True, - = False, Space = Unknown) [boolean]
    PURCHASINGITEMHASHIERARCHY,      -- Boolean Variable (X = True, - = False, Space = Unknown) [boolean]
    HASACTIVEENTITY,                 -- Has active [sdraft_has_active]
    PRIMARY KEY (MANDT, DRAFTUUID)
);

Learn More