PURCTR_HDR_D

Transparent Table Application Table
100 Fields 3 CDS Views

I_PURCHASECONTRACTWD I_PURCHASECONTRACTWD

PURCTR_HDR_D is an SAP database table in S/4HANA. I_PURCHASECONTRACTWD I_PURCHASECONTRACTWD. It contains 100 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_PurchaseContractDraft view from BASIC Draft View Purchase Contracts
I_PurContrDrftForMngPurReqn view from BASIC Purchase Contract Draft For Purchase Requisition
I_PurContrTemplate view from BASIC Purchase Contract Template

Fields (100)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY draftuuid /BOBF/UUID Key
purchasecontract VDM_PURCHASECONTRACT Purchase Contract
purchasecontractforedit VDM_PURCHASECONTRACT Purchase Contract
purchasecontracttype ESART Document Type
purchasingdocumentcategory EBSTYP Doc. Category
creationdate MMPUR_ERDAT Created On
supplier MD_SUPPLIER Supplier
companycode BUKRS Company Code
purchasingorganization EKORG Purchasing Org.
purchasinggroup BKGRP Purch. Group
documentcurrency 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 KDATB Validity Start
validityenddate KDATE Validity End
releasecode FRGKE Release ind.
createdbyuser MMPUR_ERNAM Created By
purchasingdocumentdeletioncode ELOEK Del. Indicator
supplieraddressid AD_ADDRNUM Address Number
supplyingsupplier LLIEF Goods Supplier
invoicingparty LIFRE Invoicing Party
exchangerate FIS_EXCHANGE_RATE 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
incotermslocation1identifier TMINCO_LOC_1_ID Incoterm Loc. 1 ID
incotermslocation2identifier TMINCO_LOC_2_ID Incoterm Loc. 2 ID
incotermsdvtglocidentifier TMINCO_LOC_D_ID Deviating Loc. ID
incotermsdvtglocdescription TMINCO_LOC_D_DESCR Deviating Loc. Desc.
incotermssupchnloc1addluuid /SCMTMS/INC_LOC_1_KEY_NC Incoterm Location 1
incotermssupchnloc2addluuid /SCMTMS/INC_LOC_2_KEY_NC Incoterm Location 2
incotermssupchndvtglocaddluuid /SCMTMS/INC_DV_PLCE_DST_KEY_NC Dev. Destination
purchasingdocumentname VDM_PURGDOC_NAME Purch. Doc. Name
purchasingdocumentorigin ESTAK Status
lastchangedatetime CHANGEDATETIME Last Changed
purchasingprocessingstatus MEPROCSTATE Proc. State
isendofpurposeblocked EOPBLOCKED Busin. Purp. Cmpltd.
purchasingdocumenttypename BATXT Description
purcontrconsumedval MM_PUR_OA_CONSUMED_VAL Consumed Value
contractexpirypredicteddate MM_A_CNTR_EXPIRY_PREDICT_DATE Predicted Expry Date
purchasecontractvaliditystatus MM_OA_VALIDITY_STATUS Validity Status
purcontrvaliditystatusname MM_OA_VALIDITY_STATUS Validity Status
purcontrstatuscriticality MM_OA_VALIDITY_CRITICALITY Val. Status Critic.
supplieroperationalscore MM_A_SUPPLIER_OPL_SCORE Operational Score
purcontrhasadvncdusrinterface MM_OA_ADV_PCTR_IND Advncd Pur Contr Ind
numberofdays NUMBEROFDAYS Number of Days
isexpired MM_OA_ISCONTRACTEXPIRED Contract is Expired
purcontroutputctrltype MM_OA_OC_TYPE Output Control Type
purcontroutputctrlstatus MM_OA_OC_STATUS Output Control Statu
purcontroutputctrlstatustxt MM_OA_OC_STATUS_TXT OC Status Text
purcontroutputctrltime MM_OA_OC_TIME Output Control Time
weightedrelevance MM_PUR_OA_WEIGHTED_REL Weighted Relevance
contractconsumptioninpct MMPUR_OA_CONSUMPTION_PCT Consumption Pct
purcontrcnsmpncriticality MM_OA_VALIDITY_CRITICALITY Val. Status Critic.
purcontrcriticalitystatus MM_PUR_CTR_CRITICALITY_STATUS Attention Required
accworkflowapprover MM_OA_APPROVER_ID User
accworkflowapproverfirstname MM_OA_APPROVER_NAME Full Name
approvalstatusname VAL_TEXT Short Description
approveruser SWW_AAGENT Agent
purcontrvaliditystatus_2 MM_PUR_CTR_VALIDITY_STATUS Validity Status
createdbyusername MM_OA_USER_ALIAS Created By (User)
iscontrrefofpurreqn BOOLE_D TRUE
changerecordreferenceuuid SYSUUID_X UUID
ispurcontrtemplate MM_OA_ISCONTRACTTEMPLATE Is Contract Template
purgcontractisinpreparation BOOLEAN Boolean Variable (X = True, - = False, Space = Unknown)
purchasingdocumentstatus VAL_TEXT Short Description
purchasingitemhashierarchy BOOLEAN Boolean Variable (X = True, - = False, Space = Unknown)
purcontrreworkcommenttext MMPUR_CTR_REWORK_COMMENT Comments to Approver
purcontrapprovercommenttext MMPUR_CTR_APPROVERCOMMENT Approver Comments
purgaggrgdprodcmplncsuplrsts MMPUR_PC_TOTAL_STATUS_PCS Supplier Check Sts
purghascatalogrelevantitems MMPUR_DOC_IS_CATALOG_RELEVANT Ctlg Item Rlvt Doc
activepurchasingdocument EBELN_AD Active Purchase Doc
purgdocchangerequeststatus CR_STAT Change Request Stat.
purchasingdocumentversion REVNO Version
purgdocischgvers XFELD Checkbox
purchasingdocversionreasoncode RSCOD Reason
changerequestnote VAL_TEXT Short Description
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_ekko_incl_eew_ps EKKO_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_PURCHASECONTRACTWD I_PURCHASECONTRACTWD
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PURCTR_HDR_D (
    MANDT,                           -- Client [MANDT]
    DRAFTUUID,                       -- Key [/BOBF/UUID]
    PURCHASECONTRACT,                -- Purchase Contract [VDM_PURCHASECONTRACT]
    PURCHASECONTRACTFOREDIT,         -- Purchase Contract [VDM_PURCHASECONTRACT]
    PURCHASECONTRACTTYPE,            -- Document Type [ESART]
    PURCHASINGDOCUMENTCATEGORY,      -- Doc. Category [EBSTYP]
    CREATIONDATE,                    -- Created On [MMPUR_ERDAT]
    SUPPLIER,                        -- Supplier [MD_SUPPLIER]
    COMPANYCODE,                     -- Company Code [BUKRS]
    PURCHASINGORGANIZATION,          -- Purchasing Org. [EKORG]
    PURCHASINGGROUP,                 -- Purch. Group [BKGRP]
    DOCUMENTCURRENCY,                -- 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 [KDATB]
    VALIDITYENDDATE,                 -- Validity End [KDATE]
    RELEASECODE,                     -- Release ind. [FRGKE]
    CREATEDBYUSER,                   -- Created By [MMPUR_ERNAM]
    PURCHASINGDOCUMENTDELETIONCODE,  -- Del. Indicator [ELOEK]
    SUPPLIERADDRESSID,               -- Address Number [AD_ADDRNUM]
    SUPPLYINGSUPPLIER,               -- Goods Supplier [LLIEF]
    INVOICINGPARTY,                  -- Invoicing Party [LIFRE]
    EXCHANGERATE,                    -- Exchange Rate [FIS_EXCHANGE_RATE]
    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]
    INCOTERMSLOCATION1IDENTIFIER,    -- Incoterm Loc. 1 ID [TMINCO_LOC_1_ID]
    INCOTERMSLOCATION2IDENTIFIER,    -- Incoterm Loc. 2 ID [TMINCO_LOC_2_ID]
    INCOTERMSDVTGLOCIDENTIFIER,      -- Deviating Loc. ID [TMINCO_LOC_D_ID]
    INCOTERMSDVTGLOCDESCRIPTION,     -- Deviating Loc. Desc. [TMINCO_LOC_D_DESCR]
    INCOTERMSSUPCHNLOC1ADDLUUID,     -- Incoterm Location 1 [/SCMTMS/INC_LOC_1_KEY_NC]
    INCOTERMSSUPCHNLOC2ADDLUUID,     -- Incoterm Location 2 [/SCMTMS/INC_LOC_2_KEY_NC]
    INCOTERMSSUPCHNDVTGLOCADDLUUID,  -- Dev. Destination [/SCMTMS/INC_DV_PLCE_DST_KEY_NC]
    PURCHASINGDOCUMENTNAME,          -- Purch. Doc. Name [VDM_PURGDOC_NAME]
    PURCHASINGDOCUMENTORIGIN,        -- Status [ESTAK]
    LASTCHANGEDATETIME,              -- Last Changed [CHANGEDATETIME]
    PURCHASINGPROCESSINGSTATUS,      -- Proc. State [MEPROCSTATE]
    ISENDOFPURPOSEBLOCKED,           -- Busin. Purp. Cmpltd. [EOPBLOCKED]
    PURCHASINGDOCUMENTTYPENAME,      -- Description [BATXT]
    PURCONTRCONSUMEDVAL,             -- Consumed Value [MM_PUR_OA_CONSUMED_VAL]
    CONTRACTEXPIRYPREDICTEDDATE,     -- Predicted Expry Date [MM_A_CNTR_EXPIRY_PREDICT_DATE]
    PURCHASECONTRACTVALIDITYSTATUS,  -- Validity Status [MM_OA_VALIDITY_STATUS]
    PURCONTRVALIDITYSTATUSNAME,      -- Validity Status [MM_OA_VALIDITY_STATUS]
    PURCONTRSTATUSCRITICALITY,       -- Val. Status Critic. [MM_OA_VALIDITY_CRITICALITY]
    SUPPLIEROPERATIONALSCORE,        -- Operational Score [MM_A_SUPPLIER_OPL_SCORE]
    PURCONTRHASADVNCDUSRINTERFACE,   -- Advncd Pur Contr Ind [MM_OA_ADV_PCTR_IND]
    NUMBEROFDAYS,                    -- Number of Days [NUMBEROFDAYS]
    ISEXPIRED,                       -- Contract is Expired [MM_OA_ISCONTRACTEXPIRED]
    PURCONTROUTPUTCTRLTYPE,          -- Output Control Type [MM_OA_OC_TYPE]
    PURCONTROUTPUTCTRLSTATUS,        -- Output Control Statu [MM_OA_OC_STATUS]
    PURCONTROUTPUTCTRLSTATUSTXT,     -- OC Status Text [MM_OA_OC_STATUS_TXT]
    PURCONTROUTPUTCTRLTIME,          -- Output Control Time [MM_OA_OC_TIME]
    WEIGHTEDRELEVANCE,               -- Weighted Relevance [MM_PUR_OA_WEIGHTED_REL]
    CONTRACTCONSUMPTIONINPCT,        -- Consumption Pct [MMPUR_OA_CONSUMPTION_PCT]
    PURCONTRCNSMPNCRITICALITY,       -- Val. Status Critic. [MM_OA_VALIDITY_CRITICALITY]
    PURCONTRCRITICALITYSTATUS,       -- Attention Required [MM_PUR_CTR_CRITICALITY_STATUS]
    ACCWORKFLOWAPPROVER,             -- User [MM_OA_APPROVER_ID]
    ACCWORKFLOWAPPROVERFIRSTNAME,    -- Full Name [MM_OA_APPROVER_NAME]
    APPROVALSTATUSNAME,              -- Short Description [VAL_TEXT]
    APPROVERUSER,                    -- Agent [SWW_AAGENT]
    PURCONTRVALIDITYSTATUS_2,        -- Validity Status [MM_PUR_CTR_VALIDITY_STATUS]
    CREATEDBYUSERNAME,               -- Created By (User) [MM_OA_USER_ALIAS]
    ISCONTRREFOFPURREQN,             -- TRUE [BOOLE_D]
    CHANGERECORDREFERENCEUUID,       -- UUID [SYSUUID_X]
    ISPURCONTRTEMPLATE,              -- Is Contract Template [MM_OA_ISCONTRACTTEMPLATE]
    PURGCONTRACTISINPREPARATION,     -- Boolean Variable (X = True, - = False, Space = Unknown) [BOOLEAN]
    PURCHASINGDOCUMENTSTATUS,        -- Short Description [VAL_TEXT]
    PURCHASINGITEMHASHIERARCHY,      -- Boolean Variable (X = True, - = False, Space = Unknown) [BOOLEAN]
    PURCONTRREWORKCOMMENTTEXT,       -- Comments to Approver [MMPUR_CTR_REWORK_COMMENT]
    PURCONTRAPPROVERCOMMENTTEXT,     -- Approver Comments [MMPUR_CTR_APPROVERCOMMENT]
    PURGAGGRGDPRODCMPLNCSUPLRSTS,    -- Supplier Check Sts [MMPUR_PC_TOTAL_STATUS_PCS]
    PURGHASCATALOGRELEVANTITEMS,     -- Ctlg Item Rlvt Doc [MMPUR_DOC_IS_CATALOG_RELEVANT]
    ACTIVEPURCHASINGDOCUMENT,        -- Active Purchase Doc [EBELN_AD]
    PURGDOCCHANGEREQUESTSTATUS,      -- Change Request Stat. [CR_STAT]
    PURCHASINGDOCUMENTVERSION,       -- Version [REVNO]
    PURGDOCISCHGVERS,                -- Checkbox [XFELD]
    PURCHASINGDOCVERSIONREASONCODE,  -- Reason [RSCOD]
    CHANGEREQUESTNOTE,               -- Short Description [VAL_TEXT]
    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_EKKO_INCL_EEW_PS,          -- Ext. Include [EKKO_INCL_EEW]
    PRIMARY KEY (MANDT, DRAFTUUID)
);

Learn More