I_PURCHASECONTRACT

CDS View
56 Fields 58 CDS Views

Purchase Contract

I_PURCHASECONTRACT is a CDS View in S/4HANA. Purchase Contract. It contains 56 fields. 58 CDS views read from this table.

CDS Views using this table (58)

ViewTypeJoinVDMDescription
A_PurchaseContract view from COMPOSITE Purchase Contract
A_PurchaseContract_2 view from COMPOSITE Purchase Contract
C_Contract_Ovp view from CONSUMPTION View for Contracts in OVP
C_ContractConsumption view inner CONSUMPTION Contract Consumption
C_PPS_PurReqnSOSContractVH view_entity inner CONSUMPTION PPS Contracts for PurReqn Assingn SOS
C_PurchaseContractHdr view from CONSUMPTION Purchase Contract Header View
C_PurchaseContractValHelp view from CONSUMPTION Value help for Purchase Contract
C_PurchaseReqnContractVH view inner CONSUMPTION Ctr Value help for PurReqn Assingn SoS
C_PurOrdMaintainCtrItemValHelp view left_outer CONSUMPTION Contract Item Value Help
C_PurOrdRefDocPC view left_outer CONSUMPTION Reference Documents PO Creation - Purchase Contract Items
C_RFQProcessFlow view inner CONSUMPTION RFQ Process Flow
C_SSPPurchaseContractVH view_entity from CONSUMPTION Purchase Contract for Enhanced Limit
C_Suppliercontracts view from CONSUMPTION Purchase Contract
ESH_N_PURCHASECONTRACT view from
I_Activepurchasecontract view from COMPOSITE I view for active purchase contract
I_PPS_PurContrProcessFlow view_entity inner COMPOSITE PPS Process Flow for Purchase Contract
I_PurchaseContractAPI01 view from COMPOSITE Purchase Contract
I_PurchaseContractExtReference view from COMPOSITE External References of Pur Contract Hdr
I_PurchaseContractStdVH view from COMPOSITE Purchase Contract
I_RU_Contract view union COMPOSITE Contracts in Russian Financials
OIJ09_SourceNominationSchedule view inner Source Schedule
P_ComavgReldaysDifference view from COMPOSITE
P_Comonavg_Amount view from COMPOSITE
P_Comonavg_Quantity view from COMPOSITE
P_Comonavg_Relconrate_Base view inner COMPOSITE
P_Contract_Curr_Conv view from COMPOSITE
P_POCountInQtyContract view inner CONSUMPTION Purchase Order Count in Quantity Contract
P_PurcContractLeakagePC view inner CONSUMPTION P_PurcContractLeakagePC
P_PurchaseContract view from COMPOSITE
P_PurchaseContractExpiry1 view inner CONSUMPTION Purchase Contract Expiry1
P_PurchaseContractItem1 view from CONSUMPTION Purchase Contract Changes
P_PurchaseContractMassUpdate view from CONSUMPTION Mass Changes to Purchase Contracts
P_PurchaseContractMassUpdate view inner CONSUMPTION Mass Changes to Purchase Contracts
P_PurchaseContractReleaseCode view from CONSUMPTION Purchase Contract Release Code
P_PurchaseContractStatus view from CONSUMPTION Contract Status
P_PurchaseContractTargetAmount view inner CONSUMPTION
P_PurchaseContractWithDraft view from COMPOSITE
P_PurchaseOrderItemPAI_04 view left_outer CONSUMPTION
P_PurContractItemConsumption view inner CONSUMPTION
P_PurContrCalcValidityStatus view from COMPOSITE
P_PurContrMassValidityStatus view from CONSUMPTION Contract Status
P_PurOrdMaintainRefDocumentAll view left_outer CONSUMPTION
P_QtyContractReleasedAmount view inner CONSUMPTION
P_QuantityContract view inner CONSUMPTION
P_QuantityContractWithHistory view inner CONSUMPTION
P_QuantityContractWithHistory1 view inner CONSUMPTION Quantity Contract with History Detail
P_QuantityContractWithPOCount view inner CONSUMPTION Quantity Contract With PO Count
P_QuantityContrWthUnusedAmtPAI view inner CONSUMPTION
P_ReleaseAmtInValueContract1 view inner CONSUMPTION Release Amount Calc for Value Contract1
P_ReleaseDocumentationForPC view inner CONSUMPTION Release Documentation For Contracts
P_ReleaseDocumentationValues2 view inner CONSUMPTION Release Documentation Values 2
P_ReleaseDocumentationValues4 view inner CONSUMPTION
P_ReleaseDocumentationValues5 view inner CONSUMPTION Release Documentation Values 5
P_RU_MONITOR_CONTRACTS_DS view union CONSUMPTION
P_UnusedPurchaseContract3 view inner CONSUMPTION Unused Purchase Contract 3
P_ValueContractReleasedAmount2 view inner CONSUMPTION
P_ValueContractReleaseSts view from CONSUMPTION Value Contract Release Status
R_PurchaseContractTP view_entity from TRANSACTIONAL Purchase Contract Header

Fields (56)

KeyField CDS FieldsUsed in Views
KEY ActivePurchasingDocument ActivePurchasingDocument,PrecedingDocument,PurchaseContract,SubsequentDocument 3
KEY PurchaseContract ActivePurchaseContract,PurchaseContract,PurchaseContractForEdit,SubsequentDocument 17
KEY PurchasingOrganization PurchasingOrganization 25
KEY Supplier Supplier 20
_IncotermsClassification _IncotermsClassification 1
_PurchasingDocumentCategory _PurchasingDocumentCategory 1
_PurchasingDocumentType _PurchasingDocumentType 1
CashDiscount1Days CashDiscount1Days 4
CashDiscount1Percent CashDiscount1Percent 4
CashDiscount2Days CashDiscount2Days 4
CashDiscount2Percent CashDiscount2Percent 4
CompanyCode CompanyCode 17
CorrespncExternalReference CorrespncExternalReference 6
CorrespncInternalReference CorrespncInternalReference 5
CreatedByUser ContractCreateByUser,CreatedByUser 10
CreationDate ContractCreationDate,CreationDate 12
DocumentCurrency Currency,DocumentCurrency,ReleaseOrderCurrency 23
ExchangeRate ExchangeRate 3
ExchangeRateIsFixed ExchangeRateIsFixed 4
IncotermsClassification IncotermsClassification 6
IncotermsLocation1 IncotermsLocation1 4
IncotermsLocation2 IncotermsLocation2 4
IncotermsSupChnDvtgLocAddlUUID IncotermsSupChnDvtgLocAddlUUID 1
IncotermsSupChnLoc1AddlUUID IncotermsSupChnLoc1AddlUUID 1
IncotermsSupChnLoc2AddlUUID IncotermsSupChnLoc2AddlUUID 1
IncotermsTransferLocation IncotermsTransferLocation 5
IncotermsVersion IncotermsVersion 5
InvoicingParty InvoicingParty 3
IsEndOfPurposeBlocked IsEndOfPurposeBlocked 6
LastChangeDateTime ContractLastChangeDateTime,LastChangeDateTime 3
NetPaymentDays ContractNetPaymentDays,NetPaymentDays 5
PaymentTerms ContractPaymentTerms,PaymentTerms 7
PurchaseContractTargetAmount PurchaseContractTargetAmount 12
PurchaseContractType PurchaseContractType,PurchasingDocumentType 24
PurchasingDocumentCategory PurchasingDocumentCategory 10
PurchasingDocumentDeletionCode PurchasingContractDeletionCode,PurchasingDocumentDeletionCode 7
PurchasingDocumentName PurchasingDocumentName 6
PurchasingDocumentOrigin PurchasingDocumentOrigin 2
PurchasingGroup PurchasingGroup 27
PurchasingProcessingStatus PurchasingProcessingStatus 3
PurgAggrgdProdCmplncSuplrSts PurgAggrgdProdCmplncSuplrSts 2
PurgAggrgdProdMarketabilitySts PurgAggrgdProdMarketabilitySts 1
PurgAggrgdSftyDataSheetStatus PurgAggrgdSftyDataSheetStatus 1
PurgDocExternalReference PurgDocExternalReference 1
PurgHasCatalogRelevantItems PurgHasCatalogRelevantItems 1
PurgProdCmplncTotDngrsGoodsSts PurgProdCmplncTotDngrsGoodsSts 1
QuotationSubmissionDate QuotationSubmissionDate 5
ReleaseCode ReleaseCode 6
ReleaseIsNotCompleted ReleaseIsNotCompleted 4
SupplierAddressID SupplierAddressID 3
SupplierPhoneNumber SupplierPhoneNumber 4
SupplierQuotation SupplierQuotation 5
SupplierRespSalesPersonName SupplierRespSalesPersonName 5
SupplyingSupplier SupplyingSupplier 3
ValidityEndDate ValidityEndDate 19
ValidityStartDate ValidityStartDate 20

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.

-- Purchase Contract
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PURCHASECONTRACT (
    ACTIVEPURCHASINGDOCUMENT,
    PURCHASECONTRACT,
    PURCHASINGORGANIZATION,
    SUPPLIER,
    _INCOTERMSCLASSIFICATION,
    _PURCHASINGDOCUMENTCATEGORY,
    _PURCHASINGDOCUMENTTYPE,
    CASHDISCOUNT1DAYS,
    CASHDISCOUNT1PERCENT,
    CASHDISCOUNT2DAYS,
    CASHDISCOUNT2PERCENT,
    COMPANYCODE,
    CORRESPNCEXTERNALREFERENCE,
    CORRESPNCINTERNALREFERENCE,
    CREATEDBYUSER,
    CREATIONDATE,
    DOCUMENTCURRENCY,
    EXCHANGERATE,
    EXCHANGERATEISFIXED,
    INCOTERMSCLASSIFICATION,
    INCOTERMSLOCATION1,
    INCOTERMSLOCATION2,
    INCOTERMSSUPCHNDVTGLOCADDLUUID,
    INCOTERMSSUPCHNLOC1ADDLUUID,
    INCOTERMSSUPCHNLOC2ADDLUUID,
    INCOTERMSTRANSFERLOCATION,
    INCOTERMSVERSION,
    INVOICINGPARTY,
    ISENDOFPURPOSEBLOCKED,
    LASTCHANGEDATETIME,
    NETPAYMENTDAYS,
    PAYMENTTERMS,
    PURCHASECONTRACTTARGETAMOUNT,
    PURCHASECONTRACTTYPE,
    PURCHASINGDOCUMENTCATEGORY,
    PURCHASINGDOCUMENTDELETIONCODE,
    PURCHASINGDOCUMENTNAME,
    PURCHASINGDOCUMENTORIGIN,
    PURCHASINGGROUP,
    PURCHASINGPROCESSINGSTATUS,
    PURGAGGRGDPRODCMPLNCSUPLRSTS,
    PURGAGGRGDPRODMARKETABILITYSTS,
    PURGAGGRGDSFTYDATASHEETSTATUS,
    PURGDOCEXTERNALREFERENCE,
    PURGHASCATALOGRELEVANTITEMS,
    PURGPRODCMPLNCTOTDNGRSGOODSSTS,
    QUOTATIONSUBMISSIONDATE,
    RELEASECODE,
    RELEASEISNOTCOMPLETED,
    SUPPLIERADDRESSID,
    SUPPLIERPHONENUMBER,
    SUPPLIERQUOTATION,
    SUPPLIERRESPSALESPERSONNAME,
    SUPPLYINGSUPPLIER,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (ACTIVEPURCHASINGDOCUMENT, PURCHASECONTRACT, PURCHASINGORGANIZATION, SUPPLIER)
);

Learn More