I_ExchPurContrItmQtySchedg

DDL: I_EXCHPURCONTRITMQTYSCHEDG SQL: IEXCHPCIQTYSCHED Type: view BASIC
8 Fields 1 Data Sources 1 Associations

Exchange Purchase Contract Item Qty Scheduling

I_ExchPurContrItmQtySchedg is a Basic CDS View that provides data about "Exchange Purchase Contract Item Qty Scheduling" in SAP S/4HANA. It reads from 1 data source (oia06) and exposes 8 fields with key fields PurchasingDocument, PurchasingDocumentItem, SequenceNumber. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
oia06 oia06 from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_PurchasingDocument _PurchasingDocument $projection.PurchasingDocument = _PurchasingDocument.PurchasingDocument

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IEXCHPCIQTYSCHED view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
EndUserText.label Exchange Purchase Contract Item Qty Scheduling view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument ebeln Source PurchDoc
KEY PurchasingDocumentItem ebelp Item pur. doc.
KEY SequenceNumber seqent Sequent.no.
ExchPurContractSchedDate Sched.date
ExchPurContractCallOffQty smenge Called-off qty.
ExchPurContractSchedQty intqty Sched.qty.
UnitOfMeasure oia06h meins Valuation Unit
_PurchasingDocument _PurchasingDocument

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_ExchPurContrItmQtySchedg.
-- 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: IEXCHPCIQTYSCHED

CREATE VIEW I_ExchPurContrItmQtySchedg AS
SELECT
  ebeln AS PurchasingDocument,
  ebelp AS PurchasingDocumentItem,
  seqent AS SequenceNumber,
  cast(schddt as abap.char( 15 )) AS ExchPurContractSchedDate,
  smenge AS ExchPurContractCallOffQty,
  intqty AS ExchPurContractSchedQty,
  oia06h.meins AS UnitOfMeasure
FROM oia06
LEFT OUTER JOIN I_PurchasingDocument AS _PurchasingDocument ON PurchasingDocument = _PurchasingDocument.PurchasingDocument  -- association [1..1]
;

Learn More