R_CENTRALPURCHASECONTRACT

CDS View
50 Fields 15 CDS Views

Central Purchase Contract Base View

R_CENTRALPURCHASECONTRACT is a CDS View in S/4HANA. Central Purchase Contract Base View. It contains 50 fields. 15 CDS views read from this table.

CDS Views using this table (15)

ViewTypeJoinVDMDescription
ESH_N_CENTRL_PURCHASE_CONTRACT view from
I_CentralPurchaseContract view from COMPOSITE Central PC Basic Header View
I_CentralPurchaseContractBasic view_entity from BASIC Central Purchase Contract
I_CntrlPurContrAggrgnDistrSts view from BASIC Agg. Distr Status of Cntrl Pur Contr
I_CntrlPurContrOutputParam view from COMPOSITE Output Paramenters for Central Purchase Contracts
I_CntrlPurContrVersionHistory view inner BASIC Basic View for CCTR Version History
I_SubordinateCntrlContr view from COMPOSITE Basic View for Subordinate Central Contracts
P_CePuCoHdrConsumptionPct view from BASIC Cntrl Pur Contr Hdr Consumption percentage
P_CntrlContrRelDocnValues view inner CONSUMPTION
P_CntrlPurContractItems view inner CONSUMPTION Central Purchase Contract Items
P_CntrlPurContrHdrCndnValdty view inner BASIC
P_CntrlPurContrItemMonitor1 view inner CONSUMPTION Central Purchase Contract Items
P_CntrlPurContrValidityDates view from COMPOSITE View for Cal. Validity Dates
P_CntrlPurContrWthPriceHist view inner CONSUMPTION Central Contract Price History
R_CntrlPurchaseContractItem view inner BASIC Central Purchase Contract Item

Fields (50)

KeyField CDS FieldsUsed in Views
KEY ActivePurchasingDocument ActivePurchasingDocument,SubordCntrlPurContract 4
KEY CentralPurchaseContract CentralPurchaseContract 2
KEY ProcmtHubCompanyCodeGroupingID ProcmtHubCompanyCodeGroupingID 3
KEY PurchasingParentDocument PurchasingParentDocument 2
CashDiscount1Days CashDiscount1Days 1
CashDiscount1Percent CashDiscount1Percent 1
CashDiscount2Days CashDiscount2Days 1
CashDiscount2Percent CashDiscount2Percent 1
CompanyCode CompanyCode 5
CorrespncExternalReference CorrespncExternalReference 1
CorrespncInternalReference CorrespncInternalReference 1
CreatedByUser CreatedByUser 1
CreationDate CreationDate 1
Currency Currency 1
DocumentCurrency DocumentCurrency 2
ExchangeRate ExchangeRate 1
ExchangeRateIsFixed ExchangeRateIsFixed 1
IncotermsClassification IncotermsClassification 1
IncotermsLocation1 IncotermsLocation1 1
IncotermsLocation2 IncotermsLocation2 1
IncotermsTransferLocation IncotermsTransferLocation 1
IncotermsVersion IncotermsVersion 1
InvoicingParty InvoicingParty 1
IsEndOfPurposeBlocked IsEndOfPurposeBlocked 2
LastChangeDateTime LastChangeDateTime 1
ManualSupplierAddressID ManualSupplierAddressID 1
NetPaymentDays NetPaymentDays 1
PaymentTerms PaymentTerms 1
PurchaseContractTargetAmount PurchaseContractTargetAmount 1
PurchaseContractType PurchaseContractType 6
PurchasingDocumentCategory PurchasingDocumentCategory 4
PurchasingDocumentDeletionCode PurchasingDocumentDeletionCode 1
PurchasingDocumentName CntrlPurContrDescription,PurchasingDocumentName 2
PurchasingDocumentSubtype PurchasingDocumentSubtype 4
PurchasingDocumentVersion PurchasingDocumentVersion 1
PurchasingGroup PurchasingGroup 6
PurchasingOrganization PurchasingOrganization 6
PurchasingProcessingStatus PurchasingProcessingStatus 1
PurgDocChangeRequestStatus PurgDocChangeRequestStatus 5
PurgDocIsChgVers PurgDocIsChgVers 1
QuotationSubmissionDate QuotationSubmissionDate 1
ReleaseCode ReleaseCode 1
ReleaseIsNotCompleted ReleaseIsNotCompleted 1
Supplier Supplier 2
SupplierPhoneNumber SupplierPhoneNumber 1
SupplierQuotation SupplierQuotation 1
SupplierRespSalesPersonName SupplierRespSalesPersonName 1
SupplyingSupplier SupplyingSupplier 1
ValidityEndDate ValidityEndDate 3
ValidityStartDate ValidityStartDate 3

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.

-- Central Purchase Contract Base View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE R_CENTRALPURCHASECONTRACT (
    ACTIVEPURCHASINGDOCUMENT,
    CENTRALPURCHASECONTRACT,
    PROCMTHUBCOMPANYCODEGROUPINGID,
    PURCHASINGPARENTDOCUMENT,
    CASHDISCOUNT1DAYS,
    CASHDISCOUNT1PERCENT,
    CASHDISCOUNT2DAYS,
    CASHDISCOUNT2PERCENT,
    COMPANYCODE,
    CORRESPNCEXTERNALREFERENCE,
    CORRESPNCINTERNALREFERENCE,
    CREATEDBYUSER,
    CREATIONDATE,
    CURRENCY,
    DOCUMENTCURRENCY,
    EXCHANGERATE,
    EXCHANGERATEISFIXED,
    INCOTERMSCLASSIFICATION,
    INCOTERMSLOCATION1,
    INCOTERMSLOCATION2,
    INCOTERMSTRANSFERLOCATION,
    INCOTERMSVERSION,
    INVOICINGPARTY,
    ISENDOFPURPOSEBLOCKED,
    LASTCHANGEDATETIME,
    MANUALSUPPLIERADDRESSID,
    NETPAYMENTDAYS,
    PAYMENTTERMS,
    PURCHASECONTRACTTARGETAMOUNT,
    PURCHASECONTRACTTYPE,
    PURCHASINGDOCUMENTCATEGORY,
    PURCHASINGDOCUMENTDELETIONCODE,
    PURCHASINGDOCUMENTNAME,
    PURCHASINGDOCUMENTSUBTYPE,
    PURCHASINGDOCUMENTVERSION,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    PURCHASINGPROCESSINGSTATUS,
    PURGDOCCHANGEREQUESTSTATUS,
    PURGDOCISCHGVERS,
    QUOTATIONSUBMISSIONDATE,
    RELEASECODE,
    RELEASEISNOTCOMPLETED,
    SUPPLIER,
    SUPPLIERPHONENUMBER,
    SUPPLIERQUOTATION,
    SUPPLIERRESPSALESPERSONNAME,
    SUPPLYINGSUPPLIER,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (ACTIVEPURCHASINGDOCUMENT, CENTRALPURCHASECONTRACT, PROCMTHUBCOMPANYCODEGROUPINGID, PURCHASINGPARENTDOCUMENT)
);

Learn More