I_CENTRALPURCHASECONTRACT

CDS View
56 Fields 15 CDS Views

Central PC Basic Header View

I_CENTRALPURCHASECONTRACT is a CDS View in S/4HANA. Central PC Basic Header View. It contains 56 fields. 15 CDS views read from this table.

CDS Views using this table (15)

ViewTypeJoinVDMDescription
A_CentralPurchaseContract view from COMPOSITE Central Purchase Contract
A_CntrlPurContrLegalTrans view from CONSUMPTION Legal Transaction
C_CePuCoDistrdContrForMassChg view_entity inner CONSUMPTION Distr Cont for Mass changes to CePuCo
C_CntrlPurContrHierMassUpdt view from CONSUMPTION Mass Changes to Central Hierarchy Purchase Contracts
C_CntrlPurContrOutputCriteria view from CONSUMPTION Central PC Output Management Parameter Determination
C_PrmtHbCntrlPurContrForLeCoMa view from CONSUMPTION C View for CCTR in LCM
C_PrmtHbCntrlPurContrVH view from CONSUMPTION CCTR Value Help
C_PurCntrlContrMassUpdt view from CONSUMPTION Mass Changes to Central Contracts
I_CentralPurchaseContractAPI01 view from COMPOSITE Central Purchase Contract
I_CentralPurchaseContractTP view from TRANSACTIONAL Central PC BO Header View
I_CntrlPurContrExprgValidity view from COMPOSITE Central Purchase Contract Expiration
I_CntrlPurContrFilterMatlGrpVH view inner COMPOSITE VH for CCTR Material Group
P_UnusedPurCentralContract view inner CONSUMPTION Unused Central Purchase Contracts
R_CentralContractItemSelection view from COMPOSITE Central Purchase Contract Item Selection
R_CntrlPurchaseContractTP view_entity from TRANSACTIONAL Central Purchase Contract Header

Fields (56)

KeyField CDS FieldsUsed in Views
KEY CentralPurchaseContract CentralPurchaseContract 3
KEY IsEndOfPurposeBlocked IsEndOfPurposeBlocked 3
KEY PurchaseContractType PurchaseContractType 6
KEY PurchasingGroup PurchasingGroup 5
KEY PurchasingOrganization PurchasingOrganization 5
ActivePurchasingDocument ActivePurchasingDocument 3
CashDiscount1Days CashDiscount1Days 1
CashDiscount1Percent CashDiscount1Percent 1
CashDiscount2Days CashDiscount2Days 1
CashDiscount2Percent CashDiscount2Percent 1
CntrlPurContrFlxblDistrIsAllwd CntrlPurContrFlxblDistrIsAllwd 1
CompanyCode CompanyCode 4
ContrCnsmpnCheckOnChangeIsRqd ContrCnsmpnCheckOnChangeIsRqd 1
CorrespncExternalReference CorrespncExternalReference 1
CorrespncInternalReference CorrespncInternalReference 1
CreatedByUser CreatedByUser 1
CreationDate CreationDate 1
Currency Currency 1
DocumentCurrency DocumentCurrency 1
ExchangeRateIsFixed ExchangeRateIsFixed 1
IncotermsClassification IncotermsClassification 1
IncotermsLocation1 IncotermsLocation1 1
IncotermsLocation2 IncotermsLocation2 1
IncotermsTransferLocation IncotermsTransferLocation 1
IncotermsVersion IncotermsVersion 1
InvoicingParty InvoicingParty 1
IsCancelled IsCancelled 1
IsExtPurgScenario IsExtPurgScenario 1
LastChangeDateTime LastChangeDateTime 1
NetPaymentDays NetPaymentDays 1
PaymentTerms PaymentTerms 1
ProcmtHubCompanyCodeGroupingID ProcmtHubCompanyCodeGroupingID 1
PurchaseContractTargetAmount PurchaseContractTargetAmount 1
PurchasingDocumentCategory PurchasingDocumentCategory 3
PurchasingDocumentDeletionCode PurchasingDocumentDeletionCode 1
PurchasingDocumentName PurchasingDocumentName 2
PurchasingDocumentOrigin PurchasingDocumentOrigin 1
PurchasingDocumentSubtype PurchasingDocumentSubtype 2
PurchasingDocumentVersion PurchasingDocumentVersion 1
PurchasingDocVersionReasonCode PurchasingDocVersionReasonCode 1
PurchasingParentDocument PurchasingParentDocument 1
PurchasingProcessingStatus PurchasingProcessingStatus 2
PurgDocChangeRequestStatus PurgDocChangeRequestStatus 2
PurgDocIsChgVers PurgDocIsChgVers 1
PurgSingleCardinalityDistrType PurgSingleCardinalityDistrType 1
QuotationSubmissionDate QuotationSubmissionDate 1
ReleaseCode ReleaseCode 1
ReleaseIsNotCompleted ReleaseIsNotCompleted 1
Supplier Supplier 3
SupplierAddressID SupplierAddressID 1
SupplierPhoneNumber SupplierPhoneNumber 1
SupplierQuotation SupplierQuotation 1
SupplierRespSalesPersonName SupplierRespSalesPersonName 1
SupplyingSupplier SupplyingSupplier 1
ValidityEndDate ValidityEndDate 3
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.

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

Learn More