I_PurchaseContractAPI01

DDL: I_PURCHASECONTRACTAPI01 SQL: IPURCONTRAPI Type: view COMPOSITE
40 Fields 1 Data Sources 1 Associations

Purchase Contract

I_PurchaseContractAPI01 is a Composite CDS View that provides data about "Purchase Contract" in SAP S/4HANA. It reads from 1 data source (I_PurchaseContract) and exposes 40 fields with key field PurchaseContract. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_PurchaseContract I_PurchaseContract from

Associations (1)

CardinalityTargetAliasCondition
[0..1] E_PurchasingDocument _HeaderExtension $projection.PurchaseContract = _HeaderExtension.PurchasingDocument

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IPURCONTRAPI view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
EndUserText.label Purchase Contract view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (40)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract I_PurchaseContract PurchaseContract Purchasing Doc.
PurchaseContractType I_PurchaseContract PurchaseContractType Order Type
PurchasingDocumentCategory I_PurchaseContract PurchasingDocumentCategory Doc. Category
LastChangeDateTime I_PurchaseContract LastChangeDateTime Timestamp
CreationDate I_PurchaseContract CreationDate Time Stamp
Supplier I_PurchaseContract Supplier Supplier
CompanyCode I_PurchaseContract CompanyCode Receiver Company Code
PurchasingOrganization I_PurchaseContract PurchasingOrganization Purchasing Organization
PurchasingGroup I_PurchaseContract PurchasingGroup Purchasing Group
DocumentCurrency I_PurchaseContract DocumentCurrency Document Currency
IncotermsClassification I_PurchaseContract IncotermsClassification Incoterms
IncotermsTransferLocation I_PurchaseContract IncotermsTransferLocation Incoterms 2
PaymentTerms I_PurchaseContract PaymentTerms Pyt Terms
CashDiscount1Days I_PurchaseContract CashDiscount1Days Days from Baseline Date for Payment
CashDiscount2Days I_PurchaseContract CashDiscount2Days Days from Baseline Date for Payment
NetPaymentDays I_PurchaseContract NetPaymentDays Net Pmt Terms Period
CashDiscount1Percent I_PurchaseContract CashDiscount1Percent Disc. Percent 1
CashDiscount2Percent I_PurchaseContract CashDiscount2Percent Disc. Percent 2
PurchaseContractTargetAmount I_PurchaseContract PurchaseContractTargetAmount Target Value
ValidityStartDate I_PurchaseContract ValidityStartDate Validity Start Date
ValidityEndDate I_PurchaseContract ValidityEndDate ValidTo
ReleaseCode I_PurchaseContract ReleaseCode Release ind.
CreatedByUser I_PurchaseContract CreatedByUser User Name
PurchasingDocumentDeletionCode I_PurchaseContract PurchasingDocumentDeletionCode Del. Indicator
SupplyingSupplier I_PurchaseContract SupplyingSupplier Goods Supplier
InvoicingParty I_PurchaseContract InvoicingParty Supplier
ExchangeRate I_PurchaseContract ExchangeRate Exchange rate
ExchangeRateIsFixed I_PurchaseContract ExchangeRateIsFixed Fixed Exch.Rate
QuotationSubmissionDate I_PurchaseContract QuotationSubmissionDate Quotation Date
SupplierQuotation I_PurchaseContract SupplierQuotation RFQ
CorrespncExternalReference I_PurchaseContract CorrespncExternalReference Your Reference
CorrespncInternalReference I_PurchaseContract CorrespncInternalReference Our Reference
SupplierRespSalesPersonName I_PurchaseContract SupplierRespSalesPersonName Salesperson
SupplierPhoneNumber I_PurchaseContract SupplierPhoneNumber Telephone
IncotermsVersion I_PurchaseContract IncotermsVersion Inco. Version
IncotermsLocation1 I_PurchaseContract IncotermsLocation1 Inco. Location1
IncotermsLocation2 I_PurchaseContract IncotermsLocation2 Inco. Location2
ReleaseIsNotCompleted I_PurchaseContract ReleaseIsNotCompleted Subj.to Release
SupplierAddressID I_PurchaseContract SupplierAddressID Address Number
PurgDocExternalReference I_PurchaseContract PurgDocExternalReference Ext. Reference ID

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_PurchaseContractAPI01.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IPURCONTRAPI

CREATE VIEW I_PurchaseContractAPI01 AS
SELECT
  I_PurchaseContract.PurchaseContract AS PurchaseContract,
  I_PurchaseContract.PurchaseContractType AS PurchaseContractType,
  I_PurchaseContract.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  I_PurchaseContract.LastChangeDateTime AS LastChangeDateTime,
  I_PurchaseContract.CreationDate AS CreationDate,
  I_PurchaseContract.Supplier AS Supplier,
  I_PurchaseContract.CompanyCode AS CompanyCode,
  I_PurchaseContract.PurchasingOrganization AS PurchasingOrganization,
  I_PurchaseContract.PurchasingGroup AS PurchasingGroup,
  I_PurchaseContract.DocumentCurrency AS DocumentCurrency,
  I_PurchaseContract.IncotermsClassification AS IncotermsClassification,
  I_PurchaseContract.IncotermsTransferLocation AS IncotermsTransferLocation,
  I_PurchaseContract.PaymentTerms AS PaymentTerms,
  I_PurchaseContract.CashDiscount1Days AS CashDiscount1Days,
  I_PurchaseContract.CashDiscount2Days AS CashDiscount2Days,
  I_PurchaseContract.NetPaymentDays AS NetPaymentDays,
  I_PurchaseContract.CashDiscount1Percent AS CashDiscount1Percent,
  I_PurchaseContract.CashDiscount2Percent AS CashDiscount2Percent,
  I_PurchaseContract.PurchaseContractTargetAmount AS PurchaseContractTargetAmount,
  I_PurchaseContract.ValidityStartDate AS ValidityStartDate,
  I_PurchaseContract.ValidityEndDate AS ValidityEndDate,
  I_PurchaseContract.ReleaseCode AS ReleaseCode,
  I_PurchaseContract.CreatedByUser AS CreatedByUser,
  I_PurchaseContract.PurchasingDocumentDeletionCode AS PurchasingDocumentDeletionCode,
  I_PurchaseContract.SupplyingSupplier AS SupplyingSupplier,
  I_PurchaseContract.InvoicingParty AS InvoicingParty,
  I_PurchaseContract.ExchangeRate AS ExchangeRate,
  I_PurchaseContract.ExchangeRateIsFixed AS ExchangeRateIsFixed,
  I_PurchaseContract.QuotationSubmissionDate AS QuotationSubmissionDate,
  I_PurchaseContract.SupplierQuotation AS SupplierQuotation,
  I_PurchaseContract.CorrespncExternalReference AS CorrespncExternalReference,
  I_PurchaseContract.CorrespncInternalReference AS CorrespncInternalReference,
  I_PurchaseContract.SupplierRespSalesPersonName AS SupplierRespSalesPersonName,
  I_PurchaseContract.SupplierPhoneNumber AS SupplierPhoneNumber,
  I_PurchaseContract.IncotermsVersion AS IncotermsVersion,
  I_PurchaseContract.IncotermsLocation1 AS IncotermsLocation1,
  I_PurchaseContract.IncotermsLocation2 AS IncotermsLocation2,
  I_PurchaseContract.ReleaseIsNotCompleted AS ReleaseIsNotCompleted,
  I_PurchaseContract.SupplierAddressID AS SupplierAddressID,
  I_PurchaseContract.PurgDocExternalReference AS PurgDocExternalReference
FROM I_PurchaseContract
LEFT OUTER JOIN E_PurchasingDocument AS _HeaderExtension ON PurchaseContract = _HeaderExtension.PurchasingDocument  -- association [0..1]
;

Learn More