P_PURORDMAINTAINHEADERDRAFT

CDS View
41 Fields 1 CDS Views

P_PURORDMAINTAINHEADERDRAFT is a CDS View in S/4HANA. It contains 41 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_PurOrdMaintainHeaderAll view union_all CONSUMPTION

Fields (41)

KeyField CDS FieldsUsed in Views
KEY PurchaseOrder PurchaseOrder 1
KEY PurchaseOrderHeaderDraftUUID PurchaseOrderHeaderDraftUUID 1
AddressCityName AddressCityName 1
AddressCorrespondenceLanguage AddressCorrespondenceLanguage 1
AddressCountry AddressCountry 1
AddressFaxNumber AddressFaxNumber 1
AddressHouseNumber AddressHouseNumber 1
AddressID AddressID 1
AddressName AddressName 1
AddressPhoneNumber AddressPhoneNumber 1
AddressPostalCode AddressPostalCode 1
AddressRegion AddressRegion 1
AddressStreetName AddressStreetName 1
CashDiscount1Days CashDiscount1Days 1
CashDiscount1Percent CashDiscount1Percent 1
CashDiscount2Days CashDiscount2Days 1
CashDiscount2Percent CashDiscount2Percent 1
CompanyCode CompanyCode 1
CreatedByUser CreatedByUser 1
Currency Currency 1
ExchangeRate ExchangeRate 1
IncotermsClassification IncotermsClassification 1
IncotermsLocation1 IncotermsLocation1 1
IncotermsLocation2 IncotermsLocation2 1
IncotermsTransferLocation IncotermsTransferLocation 1
IncotermsVersion IncotermsVersion 1
InvoicingParty InvoicingParty 1
IsHeld IsHeld 1
LastChangeDateTime LastChangeDateTime 1
LastChangeUser LastChangeUser 1
NetPaymentDays NetPaymentDays 1
PaymentTerms PaymentTerms 1
PricingProcedure PricingProcedure 1
PurchaseOrderDate PurchaseOrderDate 1
PurchasingDocumentCategory PurchasingDocumentCategory 1
PurchasingDocumentCondition PurchasingDocumentCondition 1
PurchasingDocumentType PurchasingDocumentType 1
PurchasingGroup PurchasingGroup 1
PurchasingOrganization PurchasingOrganization 1
ReleaseIsNotCompleted ReleaseIsNotCompleted 1
Supplier Supplier 1

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_PURORDMAINTAINHEADERDRAFT (
    PURCHASEORDER,
    PURCHASEORDERHEADERDRAFTUUID,
    ADDRESSCITYNAME,
    ADDRESSCORRESPONDENCELANGUAGE,
    ADDRESSCOUNTRY,
    ADDRESSFAXNUMBER,
    ADDRESSHOUSENUMBER,
    ADDRESSID,
    ADDRESSNAME,
    ADDRESSPHONENUMBER,
    ADDRESSPOSTALCODE,
    ADDRESSREGION,
    ADDRESSSTREETNAME,
    CASHDISCOUNT1DAYS,
    CASHDISCOUNT1PERCENT,
    CASHDISCOUNT2DAYS,
    CASHDISCOUNT2PERCENT,
    COMPANYCODE,
    CREATEDBYUSER,
    CURRENCY,
    EXCHANGERATE,
    INCOTERMSCLASSIFICATION,
    INCOTERMSLOCATION1,
    INCOTERMSLOCATION2,
    INCOTERMSTRANSFERLOCATION,
    INCOTERMSVERSION,
    INVOICINGPARTY,
    ISHELD,
    LASTCHANGEDATETIME,
    LASTCHANGEUSER,
    NETPAYMENTDAYS,
    PAYMENTTERMS,
    PRICINGPROCEDURE,
    PURCHASEORDERDATE,
    PURCHASINGDOCUMENTCATEGORY,
    PURCHASINGDOCUMENTCONDITION,
    PURCHASINGDOCUMENTTYPE,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    RELEASEISNOTCOMPLETED,
    SUPPLIER,
    PRIMARY KEY (PURCHASEORDER, PURCHASEORDERHEADERDRAFTUUID)
);

Learn More