PPS_PURORD_D

Transparent Table Application Table
116 Fields 3 CDS Views

Draft table for entity R_PPS_PURCHASEORDERTP

PPS_PURORD_D is an SAP database table in S/4HANA. Draft table for entity R_PPS_PURCHASEORDERTP. It contains 116 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
E_PPS_PurchaseOrderDraft view_entity from EXTENSION PPS Purchase Order - Extension
I_PPS_PurOrdChgVersDrft view_entity from BASIC Change Document - Draft
R_PPS_PurchaseOrderDraft view_entity from BASIC Purchase Order - Draft

Fields (116)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY purchaseorder vdm_purchaseorder Purchase Order
KEY draftuuid sdraft_uuid Draft Document ID
purchaseorderuuid sysuuid_x16 UUID
purchaseordertype esart Document Type
purchaseordertypename batxt Description
purchaseordersubtype bsakz Control
purchasingdocumentorigin estak Status
createdbyuser mmpur_ernam Created By
createdbyuserfullname vdm_userdescription Description
creationdate mmpur_erdat Created On
purchaseorderdate bedat PO Date
lastchangedatetime changedatetime Last Changed
purchaseordernetamount mm_pur_order_tot_net_amount Net Value
validitystartdate kdatb Validity Start
validityenddate kdate Validity End
language spras Language
purchaseorderdeletioncode mmpur_po_del_code Deletion Code
isdeleted boolean Boolean Variable (X = True, - = False, Space = Unknown)
releaseisnotcompleted frgrl Subj.to Release
purchasingcompletenessstatus memer Incomplete
purchasingprocessingstatus meprocstate Proc. State
purgreleasesequencestatus frgzu Release State
releasecode frgke Release ind.
purchasingreleasestrategy frgsx Rel. Strategy
purgreasonfordoccancellation absgr Reas. for Canc.
activepurchasingdocument ebeln_ad Active Purchase Doc
purgdocchangerequeststatus cr_stat Change Request Stat.
purchasingdocumentversion revno Version
purgdocischgvers xfeld Checkbox
ppspurgdochaschgversdrft boolean Boolean Variable (X = True, - = False, Space = Unknown)
companycode bukrs Company Code
purchasingorganization ekorg Purchasing Org.
purchasinggroup bkgrp Purch. Group
supplier md_supplier Supplier
manualsupplieraddressid ad_addrnum Address Number
supplieraddressid ad_addrnum Address Number
supplierrespsalespersonname everk Salesperson
supplierphonenumber telfnr0 Supplier Phone
supplyingsupplier llief Goods Supplier
supplyingplant reswk Supplying Plant
invoicingparty lifre Invoicing Party
customer kunnr Customer
purchasecontract konnr Agreement
supplierquotationexternalid angnr Quotation
quotationsubmissiondate ihran Quotation Date
itemnumberintervalforsubitems upinc Subitem Interv.
paymentterms farp_dzterm Payment Terms
paymenttermsname dzterm_bez Description
cashdiscount1days dzbd1t Days 1
cashdiscount2days dzbd2t Days 2
netpaymentdays dzbd3t Days Net
cashdiscount1percent dzbd1p CD Percentage 1
cashdiscount2percent dzbd2p CD Percentage 2
downpaymenttype me_dptyp Down Payment
downpaymentpercentageoftotamt me_dppcnt Down Payment %
downpaymentamount me_dpamnt Down Payment Amt
downpaymentduedate me_dpddat Due Date for DP
incotermsclassification inco1 Incoterms
incotermstransferlocation inco2 Incoterms 2
incotermsversion incov Inco. Version
incotermslocation1 inco2_l Inco. Location1
incotermslocation2 inco3_l Inco. Location2
isintrastatreportingrelevant intra_rel Intrastat rel.
isintrastatreportingexcluded intra_excl exclude Intra
correspncexternalreference ihrez Your Reference
correspncinternalreference unsez Our Reference
pricingdocument knumv Doc. Condition
pricingprocedure kalsm_d Procedure
documentcurrency waers Currency
exchangerate fis_exchange_rate Exchange Rate
exchangerateisfixed kufix Fixed Exch.Rate
taxreturncountry land1_stml Reporting C/R
vatregistrationcountry stceg_l CtryRgnSlsTxNo.
purgaggrgdprodcmplncsuplrsts mmpur_pc_total_status_pcs Supplier Check Sts
purgaggrgdprodmarketabilitysts mmpur_pc_total_status_pma Prod. Marktablty Sts
purgaggrgdsftydatasheetstatus mmpur_pc_total_status_sds Sfty Data Sheet Sts
purgprodcmplnctotdngrsgoodssts mmpur_pc_total_status_dg Dangerous Goods Sts
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
exchangerateforedit abap.char
requestforquotation ausch Bid invitation
isendofpurposeblocked eopblocked Busin. Purp. Cmpltd.
ppspurordisinprep boolean Boolean Variable (X = True, - = False, Space = Unknown)
podraftisreverted podraftisreverted PO Draft is Reverted in Case of Rollback
purchaseorderhascommitmentitem purchaseorderhascommitmentitem Purchase Order has Commitment Items
poreworkcommenttext mm_rework_comment Rework Comment
approvalstatus purchaseorderapprovalstatus Approval Status
approvalstatusname mm_approval_status Approval Status
purchasinghasitemhierarchy xfeld Checkbox
ppsfieldchangeindicatorbinary pps_e_control_flag Control
ppsfieldchangeindicatorstring abap.char
ppspurchaseorderdescription pps_e_document_description Document Desc
ppspurgdocclassfctncode pps_e_document_confidential Doc Confidential
ppsfuturepostingdate pps_e_future_budat Future Posting Date
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
purchasingdocversionreasoncode rscod Reason
ppsrevisioncomment pps_e_ver_reason_text Reason Text
ppssmartdocumentnumber pps_e_smt_doc_number Smart Doc Number
ppsnumberofmodification pps_e_modi_number Modification Number
ppsmodificationtype pps_e_modi_type Modification Type
ppsmodificationtypetext pps_e_modi_text Reason Text
ppsmodificationidentifiercode pps_e_modif_identifier Modification Id
ppspurorderheaderstatus pps_e_hdr_status Status
ppspurordhdrstatuscriticality abap.int1
ppsfedsystapprvldate pps_e_apprvl_dte Approval Date
ppsfedsyststatus pps_e_apprvl_sts PubPS Status
ppsfedsystloghandle pps_e_log_handle PubPS Log Handle

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_PURCHASEORDERTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PPS_PURORD_D (
    MANDT,                           -- Client [mandt]
    PURCHASEORDER,                   -- Purchase Order [vdm_purchaseorder]
    DRAFTUUID,                       -- Draft Document ID [sdraft_uuid]
    PURCHASEORDERUUID,               -- UUID [sysuuid_x16]
    PURCHASEORDERTYPE,               -- Document Type [esart]
    PURCHASEORDERTYPENAME,           -- Description [batxt]
    PURCHASEORDERSUBTYPE,            -- Control [bsakz]
    PURCHASINGDOCUMENTORIGIN,        -- Status [estak]
    CREATEDBYUSER,                   -- Created By [mmpur_ernam]
    CREATEDBYUSERFULLNAME,           -- Description [vdm_userdescription]
    CREATIONDATE,                    -- Created On [mmpur_erdat]
    PURCHASEORDERDATE,               -- PO Date [bedat]
    LASTCHANGEDATETIME,              -- Last Changed [changedatetime]
    PURCHASEORDERNETAMOUNT,          -- Net Value [mm_pur_order_tot_net_amount]
    VALIDITYSTARTDATE,               -- Validity Start [kdatb]
    VALIDITYENDDATE,                 -- Validity End [kdate]
    LANGUAGE,                        -- Language [spras]
    PURCHASEORDERDELETIONCODE,       -- Deletion Code [mmpur_po_del_code]
    ISDELETED,                       -- Boolean Variable (X = True, - = False, Space = Unknown) [boolean]
    RELEASEISNOTCOMPLETED,           -- Subj.to Release [frgrl]
    PURCHASINGCOMPLETENESSSTATUS,    -- Incomplete [memer]
    PURCHASINGPROCESSINGSTATUS,      -- Proc. State [meprocstate]
    PURGRELEASESEQUENCESTATUS,       -- Release State [frgzu]
    RELEASECODE,                     -- Release ind. [frgke]
    PURCHASINGRELEASESTRATEGY,       -- Rel. Strategy [frgsx]
    PURGREASONFORDOCCANCELLATION,    -- Reas. for Canc. [absgr]
    ACTIVEPURCHASINGDOCUMENT,        -- Active Purchase Doc [ebeln_ad]
    PURGDOCCHANGEREQUESTSTATUS,      -- Change Request Stat. [cr_stat]
    PURCHASINGDOCUMENTVERSION,       -- Version [revno]
    PURGDOCISCHGVERS,                -- Checkbox [xfeld]
    PPSPURGDOCHASCHGVERSDRFT,        -- Boolean Variable (X = True, - = False, Space = Unknown) [boolean]
    COMPANYCODE,                     -- Company Code [bukrs]
    PURCHASINGORGANIZATION,          -- Purchasing Org. [ekorg]
    PURCHASINGGROUP,                 -- Purch. Group [bkgrp]
    SUPPLIER,                        -- Supplier [md_supplier]
    MANUALSUPPLIERADDRESSID,         -- Address Number [ad_addrnum]
    SUPPLIERADDRESSID,               -- Address Number [ad_addrnum]
    SUPPLIERRESPSALESPERSONNAME,     -- Salesperson [everk]
    SUPPLIERPHONENUMBER,             -- Supplier Phone [telfnr0]
    SUPPLYINGSUPPLIER,               -- Goods Supplier [llief]
    SUPPLYINGPLANT,                  -- Supplying Plant [reswk]
    INVOICINGPARTY,                  -- Invoicing Party [lifre]
    CUSTOMER,                        -- Customer [kunnr]
    PURCHASECONTRACT,                -- Agreement [konnr]
    SUPPLIERQUOTATIONEXTERNALID,     -- Quotation [angnr]
    QUOTATIONSUBMISSIONDATE,         -- Quotation Date [ihran]
    ITEMNUMBERINTERVALFORSUBITEMS,   -- Subitem Interv. [upinc]
    PAYMENTTERMS,                    -- Payment Terms [farp_dzterm]
    PAYMENTTERMSNAME,                -- Description [dzterm_bez]
    CASHDISCOUNT1DAYS,               -- Days 1 [dzbd1t]
    CASHDISCOUNT2DAYS,               -- Days 2 [dzbd2t]
    NETPAYMENTDAYS,                  -- Days Net [dzbd3t]
    CASHDISCOUNT1PERCENT,            -- CD Percentage 1 [dzbd1p]
    CASHDISCOUNT2PERCENT,            -- CD Percentage 2 [dzbd2p]
    DOWNPAYMENTTYPE,                 -- Down Payment [me_dptyp]
    DOWNPAYMENTPERCENTAGEOFTOTAMT,   -- Down Payment % [me_dppcnt]
    DOWNPAYMENTAMOUNT,               -- Down Payment Amt [me_dpamnt]
    DOWNPAYMENTDUEDATE,              -- Due Date for DP [me_dpddat]
    INCOTERMSCLASSIFICATION,         -- Incoterms [inco1]
    INCOTERMSTRANSFERLOCATION,       -- Incoterms 2 [inco2]
    INCOTERMSVERSION,                -- Inco. Version [incov]
    INCOTERMSLOCATION1,              -- Inco. Location1 [inco2_l]
    INCOTERMSLOCATION2,              -- Inco. Location2 [inco3_l]
    ISINTRASTATREPORTINGRELEVANT,    -- Intrastat rel. [intra_rel]
    ISINTRASTATREPORTINGEXCLUDED,    -- exclude Intra [intra_excl]
    CORRESPNCEXTERNALREFERENCE,      -- Your Reference [ihrez]
    CORRESPNCINTERNALREFERENCE,      -- Our Reference [unsez]
    PRICINGDOCUMENT,                 -- Doc. Condition [knumv]
    PRICINGPROCEDURE,                -- Procedure [kalsm_d]
    DOCUMENTCURRENCY,                -- Currency [waers]
    EXCHANGERATE,                    -- Exchange Rate [fis_exchange_rate]
    EXCHANGERATEISFIXED,             -- Fixed Exch.Rate [kufix]
    TAXRETURNCOUNTRY,                -- Reporting C/R [land1_stml]
    VATREGISTRATIONCOUNTRY,          -- CtryRgnSlsTxNo. [stceg_l]
    PURGAGGRGDPRODCMPLNCSUPLRSTS,    -- Supplier Check Sts [mmpur_pc_total_status_pcs]
    PURGAGGRGDPRODMARKETABILITYSTS,  -- Prod. Marktablty Sts [mmpur_pc_total_status_pma]
    PURGAGGRGDSFTYDATASHEETSTATUS,   -- Sfty Data Sheet Sts [mmpur_pc_total_status_sds]
    PURGPRODCMPLNCTOTDNGRSGOODSSTS,  -- Dangerous Goods Sts [mmpur_pc_total_status_dg]
    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]
    EXCHANGERATEFOREDIT,             -- abap.char
    REQUESTFORQUOTATION,             -- Bid invitation [ausch]
    ISENDOFPURPOSEBLOCKED,           -- Busin. Purp. Cmpltd. [eopblocked]
    PPSPURORDISINPREP,               -- Boolean Variable (X = True, - = False, Space = Unknown) [boolean]
    PODRAFTISREVERTED,               -- PO Draft is Reverted in Case of Rollback [podraftisreverted]
    PURCHASEORDERHASCOMMITMENTITEM,  -- Purchase Order has Commitment Items [purchaseorderhascommitmentitem]
    POREWORKCOMMENTTEXT,             -- Rework Comment [mm_rework_comment]
    APPROVALSTATUS,                  -- Approval Status [purchaseorderapprovalstatus]
    APPROVALSTATUSNAME,              -- Approval Status [mm_approval_status]
    PURCHASINGHASITEMHIERARCHY,      -- Checkbox [xfeld]
    PPSFIELDCHANGEINDICATORBINARY,   -- Control [pps_e_control_flag]
    PPSFIELDCHANGEINDICATORSTRING,   -- abap.char
    PPSPURCHASEORDERDESCRIPTION,     -- Document Desc [pps_e_document_description]
    PPSPURGDOCCLASSFCTNCODE,         -- Doc Confidential [pps_e_document_confidential]
    PPSFUTUREPOSTINGDATE,            -- Future Posting Date [pps_e_future_budat]
    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]
    PURCHASINGDOCVERSIONREASONCODE,  -- Reason [rscod]
    PPSREVISIONCOMMENT,              -- Reason Text [pps_e_ver_reason_text]
    PPSSMARTDOCUMENTNUMBER,          -- Smart Doc Number [pps_e_smt_doc_number]
    PPSNUMBEROFMODIFICATION,         -- Modification Number [pps_e_modi_number]
    PPSMODIFICATIONTYPE,             -- Modification Type [pps_e_modi_type]
    PPSMODIFICATIONTYPETEXT,         -- Reason Text [pps_e_modi_text]
    PPSMODIFICATIONIDENTIFIERCODE,   -- Modification Id [pps_e_modif_identifier]
    PPSPURORDERHEADERSTATUS,         -- Status [pps_e_hdr_status]
    PPSPURORDHDRSTATUSCRITICALITY,   -- abap.int1
    PPSFEDSYSTAPPRVLDATE,            -- Approval Date [pps_e_apprvl_dte]
    PPSFEDSYSTSTATUS,                -- PubPS Status [pps_e_apprvl_sts]
    PPSFEDSYSTLOGHANDLE,             -- PubPS Log Handle [pps_e_log_handle]
    PRIMARY KEY (MANDT, PURCHASEORDER, DRAFTUUID)
);

Learn More