PPS_PURCONTR_D

Transparent Table Application Table
86 Fields 2 CDS Views

Draft table for entity R_PPS_PURCHASECONTRACTTP

PPS_PURCONTR_D is an SAP database table in S/4HANA. Draft table for entity R_PPS_PURCHASECONTRACTTP. It contains 86 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_PPS_PurContrChgVersDrft view_entity from BASIC Unsaved Purchasing Contract Document
R_PPS_PurchaseContractDraft view_entity from BASIC Purchase Contract Draft

Fields (86)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY purchasecontract vdm_purchasecontract Purchase Contract
KEY draftuuid sdraft_uuid Draft Document ID
purchasecontractuuid sysuuid_x16 UUID
purchasecontracttype esart Document Type
purchasingdocumentcategory ebstyp Doc. Category
lastchangedatetime changedatetime Last Changed
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.
purchasingdocumentversion revno Version
createdbyuser mmpur_ernam Created By
purchasingdocumentdeletioncode eloek Del. Indicator
supplyingsupplier llief Goods Supplier
invoicingparty lifre Invoicing Party
purgdocischgvers xfeld Checkbox
absoluteexchangerate fis_absolute_exchangerate Absolute Exchange Rate
exchrateisindirectquotation fis_indirect_quotation Exchange Rate Is Indirect Quotation
effectiveexchangerate fis_effective_exchangerate Effective Exch. Rate
exchangerateisfixed kufix Fixed Exch.Rate
quotationsubmissiondate ihran Quotation Date
supplierquotation angnr Quotation
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
activepurchasingdocument ebeln_ad Active Purchase Doc
purchasingdocversionreasoncode rscod Reason
ppsrevisioncomment pps_e_ver_reason_text Reason Text
purchasingdocumentname vdm_purgdoc_name Purch. Doc. Name
purchasingdocumentorigin estak Status
releaseisnotcompleted frgrl Subj.to Release
purchasingprocessingstatus meprocstate Proc. State
ppspurgdochaschgversdrft boolean Boolean Variable (X = True, - = False, Space = Unknown)
purgdocchangerequeststatus cr_stat Change Request Stat.
purgaggrgdprodcmplncsuplrsts mmpur_pc_total_status_pcs Supplier Check Sts
supplieraddressid ad_addrnum Address Number
purghascatalogrelevantitems mmpur_doc_is_catalog_relevant Ctlg Item Rlvt Doc
isendofpurposeblocked eopblocked Busin. Purp. Cmpltd.
ispurcontrtemplate mm_oa_iscontracttemplate Is Contract Template
ppspurgdocclassfctncode pps_e_document_confidential Doc Confidential
purgcontractisinpreparation boolean Boolean Variable (X = True, - = False, Space = Unknown)
purcontractconsumptioninpct abap.dec
contractconsumptioninpct abap.dec
purcontrconsumptionunit abap.unit
purcontrhasadvncdusrinterface boolean Boolean Variable (X = True, - = False, Space = Unknown)
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
purcontroutputctrldatetime mm_oa_oc_time Output Control Time
accworkflowapprover mm_oa_approver_id User
accworkflowapproverfirstname mm_oa_approver_name Full Name
approvalstatusname val_text Short Description
pps_purcontrhdrcontrolstring pps_e_control_string Control
ppsfieldchangeindicatorbinary pps_e_control_flag Control
conditionrecord knumh Cond.Record No.
ppsfieldchangeindicatorstring abap.char
ppsperdofperfstartdate pps_e_perop_start_date PeROP Start Date
ppsperdofperfenddate pps_e_perop_end_date PeROP End Date
ppssmartnumberheader pps_e_smt_smart_number Smart Number
ppssmartnumberheaderismanual xfeld Checkbox
ppssmartdocumentnumber pps_e_smt_doc_number Smart Doc Number
ppsmodificationtype pps_e_modi_type Modification Type
ppsnumberofmodification pps_e_modi_number Modification Number
ppsmodificationtypetext pps_e_modi_text Reason Text
ppsmodificationidentifiercode pps_e_modif_identifier Modification Id
ppspurcontrheaderstatus pps_e_hdr_status Status
processingstatuscriticality abap.int1

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.

-- Draft table for entity R_PPS_PURCHASECONTRACTTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PPS_PURCONTR_D (
    MANDT,                           -- Client [mandt]
    PURCHASECONTRACT,                -- Purchase Contract [vdm_purchasecontract]
    DRAFTUUID,                       -- Draft Document ID [sdraft_uuid]
    PURCHASECONTRACTUUID,            -- UUID [sysuuid_x16]
    PURCHASECONTRACTTYPE,            -- Document Type [esart]
    PURCHASINGDOCUMENTCATEGORY,      -- Doc. Category [ebstyp]
    LASTCHANGEDATETIME,              -- Last Changed [changedatetime]
    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]
    PURCHASINGDOCUMENTVERSION,       -- Version [revno]
    CREATEDBYUSER,                   -- Created By [mmpur_ernam]
    PURCHASINGDOCUMENTDELETIONCODE,  -- Del. Indicator [eloek]
    SUPPLYINGSUPPLIER,               -- Goods Supplier [llief]
    INVOICINGPARTY,                  -- Invoicing Party [lifre]
    PURGDOCISCHGVERS,                -- Checkbox [xfeld]
    ABSOLUTEEXCHANGERATE,            -- Absolute Exchange Rate [fis_absolute_exchangerate]
    EXCHRATEISINDIRECTQUOTATION,     -- Exchange Rate Is Indirect Quotation [fis_indirect_quotation]
    EFFECTIVEEXCHANGERATE,           -- Effective Exch. Rate [fis_effective_exchangerate]
    EXCHANGERATEISFIXED,             -- Fixed Exch.Rate [kufix]
    QUOTATIONSUBMISSIONDATE,         -- Quotation Date [ihran]
    SUPPLIERQUOTATION,               -- Quotation [angnr]
    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]
    ACTIVEPURCHASINGDOCUMENT,        -- Active Purchase Doc [ebeln_ad]
    PURCHASINGDOCVERSIONREASONCODE,  -- Reason [rscod]
    PPSREVISIONCOMMENT,              -- Reason Text [pps_e_ver_reason_text]
    PURCHASINGDOCUMENTNAME,          -- Purch. Doc. Name [vdm_purgdoc_name]
    PURCHASINGDOCUMENTORIGIN,        -- Status [estak]
    RELEASEISNOTCOMPLETED,           -- Subj.to Release [frgrl]
    PURCHASINGPROCESSINGSTATUS,      -- Proc. State [meprocstate]
    PPSPURGDOCHASCHGVERSDRFT,        -- Boolean Variable (X = True, - = False, Space = Unknown) [boolean]
    PURGDOCCHANGEREQUESTSTATUS,      -- Change Request Stat. [cr_stat]
    PURGAGGRGDPRODCMPLNCSUPLRSTS,    -- Supplier Check Sts [mmpur_pc_total_status_pcs]
    SUPPLIERADDRESSID,               -- Address Number [ad_addrnum]
    PURGHASCATALOGRELEVANTITEMS,     -- Ctlg Item Rlvt Doc [mmpur_doc_is_catalog_relevant]
    ISENDOFPURPOSEBLOCKED,           -- Busin. Purp. Cmpltd. [eopblocked]
    ISPURCONTRTEMPLATE,              -- Is Contract Template [mm_oa_iscontracttemplate]
    PPSPURGDOCCLASSFCTNCODE,         -- Doc Confidential [pps_e_document_confidential]
    PURGCONTRACTISINPREPARATION,     -- Boolean Variable (X = True, - = False, Space = Unknown) [boolean]
    PURCONTRACTCONSUMPTIONINPCT,     -- abap.dec
    CONTRACTCONSUMPTIONINPCT,        -- abap.dec
    PURCONTRCONSUMPTIONUNIT,         -- abap.unit
    PURCONTRHASADVNCDUSRINTERFACE,   -- Boolean Variable (X = True, - = False, Space = Unknown) [boolean]
    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]
    PURCONTROUTPUTCTRLDATETIME,      -- Output Control Time [mm_oa_oc_time]
    ACCWORKFLOWAPPROVER,             -- User [mm_oa_approver_id]
    ACCWORKFLOWAPPROVERFIRSTNAME,    -- Full Name [mm_oa_approver_name]
    APPROVALSTATUSNAME,              -- Short Description [val_text]
    PPS_PURCONTRHDRCONTROLSTRING,    -- Control [pps_e_control_string]
    PPSFIELDCHANGEINDICATORBINARY,   -- Control [pps_e_control_flag]
    CONDITIONRECORD,                 -- Cond.Record No. [knumh]
    PPSFIELDCHANGEINDICATORSTRING,   -- abap.char
    PPSPERDOFPERFSTARTDATE,          -- PeROP Start Date [pps_e_perop_start_date]
    PPSPERDOFPERFENDDATE,            -- PeROP End Date [pps_e_perop_end_date]
    PPSSMARTNUMBERHEADER,            -- Smart Number [pps_e_smt_smart_number]
    PPSSMARTNUMBERHEADERISMANUAL,    -- Checkbox [xfeld]
    PPSSMARTDOCUMENTNUMBER,          -- Smart Doc Number [pps_e_smt_doc_number]
    PPSMODIFICATIONTYPE,             -- Modification Type [pps_e_modi_type]
    PPSNUMBEROFMODIFICATION,         -- Modification Number [pps_e_modi_number]
    PPSMODIFICATIONTYPETEXT,         -- Reason Text [pps_e_modi_text]
    PPSMODIFICATIONIDENTIFIERCODE,   -- Modification Id [pps_e_modif_identifier]
    PPSPURCONTRHEADERSTATUS,         -- Status [pps_e_hdr_status]
    PROCESSINGSTATUSCRITICALITY,     -- abap.int1
    PRIMARY KEY (MANDT, PURCHASECONTRACT, DRAFTUUID)
);

Learn More