PURORDTP_D

Transparent Table Application Table
82 Fields 1 CDS Views

I_PURCHASEORDERTP I_PURCHASEORDERTP

PURORDTP_D is an SAP database table in S/4HANA. I_PURCHASEORDERTP I_PURCHASEORDERTP. It contains 82 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PurchaseOrderDraft view from BASIC Purchase Order - Draft

Fields (82)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY draftuuid /BOBF/UUID Key
purchaseorder VDM_PURCHASEORDER Purchase Order
purchaseordertype MM_PURCHASEORDERTYPE PO Type
purchaseordertypename BATXT Description
purchaseordersubtype BSAKZ Control
purchasingdocumentorigin ESTAK Status
createdbyuser ERNAM Created By
createdbyuserfullname VDM_USERDESCRIPTION Description
creationdate ERDAT Created On
purchaseorderdate BEDAT PO Date
validitystartdate KDATB Validity Start
validityenddate KDATE Validity End
language SPRAS Language
purchasingdocumentdeletioncode ELOEK Del. Indicator
releaseisnotcompleted FRGRL Subj.to Release
purchasingprocessingstatus MEPROCSTATE Proc. State
purchasingcompletenessstatus MEMER Incomplete
purchasingreleasestrategy FRGSX Rel. Strategy
companycode BUKRS Company Code
purchasingorganization EKORG Purchasing Org.
purchasinggroup BKGRP Purch. Group
supplier MD_SUPPLIER Supplier
supplierrespsalespersonname EVERK Salesperson
supplierphonenumber TELF0 Telephone
supplyingsupplier LLIEF Goods Supplier
supplyingplant RESWK Supplying Plant
correspncexternalreference IHREZ Your Reference
correspncinternalreference UNSEZ Our Reference
invoicingparty LIFRE Invoicing Party
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
incotermsclassification INCO1 Incoterms
incotermstransferlocation INCO2 Incoterms 2
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
isintrastatreportingrelevant INTRA_REL Intrastat rel.
isintrastatreportingexcluded INTRA_EXCL exclude Intra
purchasingdocumentcondition KNUMV Doc. Condition
pricingprocedure KALSM_D Procedure
documentcurrency WAERS Currency
exchangerate WKURS Exchange Rate
exchangerateforedit abap.char
exchangerateisfixed KUFIX Fixed Exch.Rate
lastchangedatetime CHANGEDATETIME Last Changed
purchaseordernetamount MM_PUR_ORDER_TOT_NET_AMOUNT Net Value
manualsupplieraddressid AD_ADDRNUM Address Number
supplieraddressid AD_ADDRNUM Address Number
purchasecontract KONNR Agreement
requestforquotation AUSCH Bid invitation
supplierquotationexternalid ANGNR Quotation
isendofpurposeblocked EOPBLOCKED Busin. Purp. Cmpltd.
podraftisreverted PODRAFTISREVERTED PO Draft is Reverted in Case of Rollback
purchaseorderhascommitmentitem PURCHASEORDERHASCOMMITMENTITEM Purchase Order has Commitment Items
poreworkcommenttext abap.sstr
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
purchasinghasitemhierarchy MM_PUR_HAS_ITEM_HIERARCHY Has Item Hierarchy
approvalstatus PURCHASEORDERAPPROVALSTATUS Approval Status
approvalstatusname MM_APPROVAL_STATUS Approval Status
hasactiveentity SDRAFT_HAS_ACTIVE Has active
purchasingprocessingstatusname VAL_TEXT Short Description
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_PURCHASEORDERTP I_PURCHASEORDERTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PURORDTP_D (
    MANDT,                           -- Client [MANDT]
    DRAFTUUID,                       -- Key [/BOBF/UUID]
    PURCHASEORDER,                   -- Purchase Order [VDM_PURCHASEORDER]
    PURCHASEORDERTYPE,               -- PO Type [MM_PURCHASEORDERTYPE]
    PURCHASEORDERTYPENAME,           -- Description [BATXT]
    PURCHASEORDERSUBTYPE,            -- Control [BSAKZ]
    PURCHASINGDOCUMENTORIGIN,        -- Status [ESTAK]
    CREATEDBYUSER,                   -- Created By [ERNAM]
    CREATEDBYUSERFULLNAME,           -- Description [VDM_USERDESCRIPTION]
    CREATIONDATE,                    -- Created On [ERDAT]
    PURCHASEORDERDATE,               -- PO Date [BEDAT]
    VALIDITYSTARTDATE,               -- Validity Start [KDATB]
    VALIDITYENDDATE,                 -- Validity End [KDATE]
    LANGUAGE,                        -- Language [SPRAS]
    PURCHASINGDOCUMENTDELETIONCODE,  -- Del. Indicator [ELOEK]
    RELEASEISNOTCOMPLETED,           -- Subj.to Release [FRGRL]
    PURCHASINGPROCESSINGSTATUS,      -- Proc. State [MEPROCSTATE]
    PURCHASINGCOMPLETENESSSTATUS,    -- Incomplete [MEMER]
    PURCHASINGRELEASESTRATEGY,       -- Rel. Strategy [FRGSX]
    COMPANYCODE,                     -- Company Code [BUKRS]
    PURCHASINGORGANIZATION,          -- Purchasing Org. [EKORG]
    PURCHASINGGROUP,                 -- Purch. Group [BKGRP]
    SUPPLIER,                        -- Supplier [MD_SUPPLIER]
    SUPPLIERRESPSALESPERSONNAME,     -- Salesperson [EVERK]
    SUPPLIERPHONENUMBER,             -- Telephone [TELF0]
    SUPPLYINGSUPPLIER,               -- Goods Supplier [LLIEF]
    SUPPLYINGPLANT,                  -- Supplying Plant [RESWK]
    CORRESPNCEXTERNALREFERENCE,      -- Your Reference [IHREZ]
    CORRESPNCINTERNALREFERENCE,      -- Our Reference [UNSEZ]
    INVOICINGPARTY,                  -- Invoicing Party [LIFRE]
    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]
    INCOTERMSCLASSIFICATION,         -- Incoterms [INCO1]
    INCOTERMSTRANSFERLOCATION,       -- Incoterms 2 [INCO2]
    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]
    ISINTRASTATREPORTINGRELEVANT,    -- Intrastat rel. [INTRA_REL]
    ISINTRASTATREPORTINGEXCLUDED,    -- exclude Intra [INTRA_EXCL]
    PURCHASINGDOCUMENTCONDITION,     -- Doc. Condition [KNUMV]
    PRICINGPROCEDURE,                -- Procedure [KALSM_D]
    DOCUMENTCURRENCY,                -- Currency [WAERS]
    EXCHANGERATE,                    -- Exchange Rate [WKURS]
    EXCHANGERATEFOREDIT,             -- abap.char
    EXCHANGERATEISFIXED,             -- Fixed Exch.Rate [KUFIX]
    LASTCHANGEDATETIME,              -- Last Changed [CHANGEDATETIME]
    PURCHASEORDERNETAMOUNT,          -- Net Value [MM_PUR_ORDER_TOT_NET_AMOUNT]
    MANUALSUPPLIERADDRESSID,         -- Address Number [AD_ADDRNUM]
    SUPPLIERADDRESSID,               -- Address Number [AD_ADDRNUM]
    PURCHASECONTRACT,                -- Agreement [KONNR]
    REQUESTFORQUOTATION,             -- Bid invitation [AUSCH]
    SUPPLIERQUOTATIONEXTERNALID,     -- Quotation [ANGNR]
    ISENDOFPURPOSEBLOCKED,           -- Busin. Purp. Cmpltd. [EOPBLOCKED]
    PODRAFTISREVERTED,               -- PO Draft is Reverted in Case of Rollback [PODRAFTISREVERTED]
    PURCHASEORDERHASCOMMITMENTITEM,  -- Purchase Order has Commitment Items [PURCHASEORDERHASCOMMITMENTITEM]
    POREWORKCOMMENTTEXT,             -- abap.sstr
    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]
    PURCHASINGHASITEMHIERARCHY,      -- Has Item Hierarchy [MM_PUR_HAS_ITEM_HIERARCHY]
    APPROVALSTATUS,                  -- Approval Status [PURCHASEORDERAPPROVALSTATUS]
    APPROVALSTATUSNAME,              -- Approval Status [MM_APPROVAL_STATUS]
    HASACTIVEENTITY,                 -- Has active [SDRAFT_HAS_ACTIVE]
    PURCHASINGPROCESSINGSTATUSNAME,  -- Short Description [VAL_TEXT]
    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