P_PURORDMAINTAINHEADERACTIVE

CDS View
43 Fields 2 CDS Views

P_PURORDMAINTAINHEADERACTIVE is a CDS View in S/4HANA. It contains 43 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_PurOrdMaintainHeaderAll view from CONSUMPTION
P_PurOrdMaintainRefDocumentAll view left_outer CONSUMPTION

Fields (43)

KeyField CDS FieldsUsed in Views
KEY PurchaseOrder PurchaseOrder 1
KEY PurchasingOrganization PurchasingOrganization 2
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 2
CreatedByUser CreatedByUser 1
Currency Currency 2
EditState EditState 1
ExchangeRate ExchangeRate 1
HasTwin HasTwin 1
IncotermsClassification HeaderIncotermsClassification,IncotermsClassification 2
IncotermsLocation1 HeaderIncotermsLocation1,IncotermsLocation1 2
IncotermsLocation2 HeaderIncotermsLocation2,IncotermsLocation2 2
IncotermsTransferLocation HeaderIncotermsTransferLoc,IncotermsTransferLocation 2
IncotermsVersion IncotermsVersion 2
InvoicingParty InvoicingParty 1
IsHeld IsHeld 1
LastChangeDateTime LastChangeDateTime 1
LastChangeUser LastChangeUser 1
NetPaymentDays NetPaymentDays 1
PaymentTerms PaymentTerms 1
PricingProcedure PricingProcedure 2
PurchaseOrderDate PurchaseOrderDate 1
PurchasingDocumentCategory PurchasingDocumentCategory 1
PurchasingDocumentCondition PurchasingDocumentCondition 2
PurchasingDocumentType PurchasingDocumentType 2
PurchasingGroup PurchasingGroup 2
ReleaseIsNotCompleted ReleaseIsNotCompleted 1
Supplier Supplier 2
ValidityEndDate ValidityEndDate 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_PURORDMAINTAINHEADERACTIVE (
    PURCHASEORDER,
    PURCHASINGORGANIZATION,
    ADDRESSCITYNAME,
    ADDRESSCORRESPONDENCELANGUAGE,
    ADDRESSCOUNTRY,
    ADDRESSFAXNUMBER,
    ADDRESSHOUSENUMBER,
    ADDRESSID,
    ADDRESSNAME,
    ADDRESSPHONENUMBER,
    ADDRESSPOSTALCODE,
    ADDRESSREGION,
    ADDRESSSTREETNAME,
    CASHDISCOUNT1DAYS,
    CASHDISCOUNT1PERCENT,
    CASHDISCOUNT2DAYS,
    CASHDISCOUNT2PERCENT,
    COMPANYCODE,
    CREATEDBYUSER,
    CURRENCY,
    EDITSTATE,
    EXCHANGERATE,
    HASTWIN,
    INCOTERMSCLASSIFICATION,
    INCOTERMSLOCATION1,
    INCOTERMSLOCATION2,
    INCOTERMSTRANSFERLOCATION,
    INCOTERMSVERSION,
    INVOICINGPARTY,
    ISHELD,
    LASTCHANGEDATETIME,
    LASTCHANGEUSER,
    NETPAYMENTDAYS,
    PAYMENTTERMS,
    PRICINGPROCEDURE,
    PURCHASEORDERDATE,
    PURCHASINGDOCUMENTCATEGORY,
    PURCHASINGDOCUMENTCONDITION,
    PURCHASINGDOCUMENTTYPE,
    PURCHASINGGROUP,
    RELEASEISNOTCOMPLETED,
    SUPPLIER,
    VALIDITYENDDATE,
    PRIMARY KEY (PURCHASEORDER, PURCHASINGORGANIZATION)
);

Learn More