_CENTRALPURCHASECONTRACTHEADER

28 Fields

_CENTRALPURCHASECONTRACTHEADER is an SAP database table in S/4HANA. It contains 28 fields.

Fields (28)

KeyField CDS FieldsUsed in Views
CashDiscount1Days CashDiscount1Days 4
CashDiscount1Percent CashDiscount1Percent 4
CashDiscount2Days CashDiscount2Days 4
CashDiscount2Percent CashDiscount2Percent 4
CntrlPurContrFlxblDistrIsAllwd CntrlPurContrFlxblDistrIsAllwd 4
CompanyCode CompanyCode 4
CorrespncExternalReference CorrespncExternalReference 4
CorrespncInternalReference CorrespncInternalReference 4
Currency Currency 4
IncotermsClassification IncotermsClassification 4
IncotermsLocation1 IncotermsLocation1 4
IncotermsLocation2 IncotermsLocation2 4
IncotermsVersion IncotermsVersion 4
NetPaymentDays NetPaymentDays 4
PaymentTerms PaymentTerms 4
PurchaseContractTargetAmount PurchaseContractTargetAmount 4
PurchaseContractType PurchaseContractType 4
PurchasingDocumentSubtype PurchasingDocumentSubtype 1
PurchasingDocVersionReasonCode PurchasingDocVersionReasonCode 4
PurchasingGroup PurchasingGroup 4
PurchasingOrganization PurchasingOrganization 4
QuotationSubmissionDate QuotationSubmissionDate 4
Supplier Supplier 4
SupplierPhoneNumber SupplierPhoneNumber 4
SupplierQuotation SupplierQuotation 4
SupplierRespSalesPersonName SupplierRespSalesPersonName 4
ValidityEndDate ValidityEndDate 4
ValidityStartDate ValidityStartDate 4

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 _CENTRALPURCHASECONTRACTHEADER (
    CASHDISCOUNT1DAYS,
    CASHDISCOUNT1PERCENT,
    CASHDISCOUNT2DAYS,
    CASHDISCOUNT2PERCENT,
    CNTRLPURCONTRFLXBLDISTRISALLWD,
    COMPANYCODE,
    CORRESPNCEXTERNALREFERENCE,
    CORRESPNCINTERNALREFERENCE,
    CURRENCY,
    INCOTERMSCLASSIFICATION,
    INCOTERMSLOCATION1,
    INCOTERMSLOCATION2,
    INCOTERMSVERSION,
    NETPAYMENTDAYS,
    PAYMENTTERMS,
    PURCHASECONTRACTTARGETAMOUNT,
    PURCHASECONTRACTTYPE,
    PURCHASINGDOCUMENTSUBTYPE,
    PURCHASINGDOCVERSIONREASONCODE,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    QUOTATIONSUBMISSIONDATE,
    SUPPLIER,
    SUPPLIERPHONENUMBER,
    SUPPLIERQUOTATION,
    SUPPLIERRESPSALESPERSONNAME,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE
);

Learn More