I_PURCHASECONTRACTVERSION

CDS View
56 Fields 3 CDS Views

Purchase Contract Version

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

CDS Views using this table (3)

ViewTypeJoinVDMDescription
C_ContractFs view from CONSUMPTION Purchase Contract
I_PurchaseContractWD view from TRANSACTIONAL BO View for I_PurchaseContractWD
P_Contractmaintain_Trans view inner COMPOSITE

Fields (56)

KeyField CDS FieldsUsed in Views
KEY PurchaseContract PurchaseContract,PurchaseContractForEdit 3
_DocumentCurrency _DocumentCurrency 1
_IncotermsClassification _IncotermsClassification 1
_PurchasingDocumentCategory _PurchasingDocumentCategory 1
_PurchasingDocumentType _PurchasingDocumentType 1
ActivePurchasingDocument ActivePurchasingDocument 3
CashDiscount1Days CashDiscount1Days 2
CashDiscount1Percent CashDiscount1Percent 2
CashDiscount2Days CashDiscount2Days 2
CashDiscount2Percent CashDiscount2Percent 2
CompanyCode CompanyCode 2
CorrespncExternalReference CorrespncExternalReference 1
CorrespncInternalReference CorrespncInternalReference 1
CreatedByUser CreatedByUser 2
CreationDate CreationDate 3
DocumentCurrency DocumentCurrency 2
ExchangeRateIsFixed ExchangeRateIsFixed 1
IncotermsClassification IncotermsClassification 2
IncotermsLocation1 IncotermsLocation1 1
IncotermsLocation2 IncotermsLocation2 1
IncotermsSupChnDvtgLocAddlUUID IncotermsSupChnDvtgLocAddlUUID 1
IncotermsSupChnLoc1AddlUUID IncotermsSupChnLoc1AddlUUID 1
IncotermsSupChnLoc2AddlUUID IncotermsSupChnLoc2AddlUUID 1
IncotermsTransferLocation IncotermsTransferLocation 2
IncotermsVersion IncotermsVersion 1
InvoicingParty InvoicingParty 1
IsEndOfPurposeBlocked IsEndOfPurposeBlocked 1
LastChangeDateTime LastChangeDateTime 1
NetPaymentDays NetPaymentDays 2
PaymentTerms PaymentTerms 2
PurchaseContractTargetAmount PurchaseContractTargetAmount 2
PurchaseContractType PurchaseContractType 4
PurchasingDocumentCategory PurchasingDocumentCategory 2
PurchasingDocumentDeletionCode PurchasingDocumentDeletionCode 1
PurchasingDocumentName PurchasingDocumentName 2
PurchasingDocumentOrigin PurchasingDocumentOrigin 1
PurchasingDocumentVersion PurchasingDocumentVersion 1
PurchasingDocVersionReasonCode PurchasingDocVersionReasonCode 1
PurchasingGroup PurchasingGroup 3
PurchasingOrganization PurchasingOrganization 3
PurchasingProcessingStatus PurchasingProcessingStatus 2
PurgAggrgdProdCmplncSuplrSts PurgAggrgdProdCmplncSuplrSts 1
PurgDocChangeRequestStatus PurgDocChangeRequestStatus 2
PurgDocIsChgVers PurgDocIsChgVers 1
PurgHasCatalogRelevantItems PurgHasCatalogRelevantItems 1
QuotationSubmissionDate QuotationSubmissionDate 1
ReleaseCode ReleaseCode 2
ReleaseIsNotCompleted ReleaseIsNotCompleted 1
Supplier Supplier 3
SupplierAddressID SupplierAddressID 1
SupplierPhoneNumber SupplierPhoneNumber 1
SupplierQuotation SupplierQuotation 1
SupplierRespSalesPersonName SupplierRespSalesPersonName 1
SupplyingSupplier SupplyingSupplier 1
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.

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

Learn More