_PURCHASEORDERHEADER

24 Fields

_PURCHASEORDERHEADER is an SAP database table in S/4HANA. It contains 24 fields.

Fields (24)

KeyField CDS FieldsUsed in Views
CashDiscount1Days CashDiscount1Days 2
CashDiscount1Percent CashDiscount1Percent 2
CashDiscount2Days CashDiscount2Days 2
CashDiscount2Percent CashDiscount2Percent 2
CompanyCode CompanyCode 1
DocumentCurrency DocumentCurrency 1
ExchangeRate ExchangeRate 2
IncotermsClassification IncotermsClassification 2
IncotermsLocation1 HeaderIncotermsLoc1 2
IncotermsLocation2 HeaderIncotermsLoc2 2
IncotermsVersion IncotermsVersion 2
InvoicingParty InvoicingParty 2
NetPaymentDays NetPaymentDays 2
PaymentTerms PaymentTerms 2
PurchaseOrderDate PurchaseOrderDate 2
PurchaseOrderType PurchaseOrderType 2
PurchasingGroup PurchasingGroup 2
PurchasingOrganization PurchasingOrganization 2
Supplier Supplier 2
SupplierPhoneNumber SupplierPhoneNumber 2
SupplierRespSalesPersonName SupplierRespSalesPersonName 2
SupplyingSupplier SupplyingSupplier 2
ValidityEndDate ValidityEndDate 2
ValidityStartDate ValidityStartDate 2

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 _PURCHASEORDERHEADER (
    CASHDISCOUNT1DAYS,
    CASHDISCOUNT1PERCENT,
    CASHDISCOUNT2DAYS,
    CASHDISCOUNT2PERCENT,
    COMPANYCODE,
    DOCUMENTCURRENCY,
    EXCHANGERATE,
    INCOTERMSCLASSIFICATION,
    INCOTERMSLOCATION1,
    INCOTERMSLOCATION2,
    INCOTERMSVERSION,
    INVOICINGPARTY,
    NETPAYMENTDAYS,
    PAYMENTTERMS,
    PURCHASEORDERDATE,
    PURCHASEORDERTYPE,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    SUPPLIER,
    SUPPLIERPHONENUMBER,
    SUPPLIERRESPSALESPERSONNAME,
    SUPPLYINGSUPPLIER,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE
);

Learn More