I_ExchangeSalesContract

DDL: I_EXCHANGESALESCONTRACT SQL: IEXCHSALESCONTR Type: view BASIC
11 Fields 1 Data Sources 3 Associations

Exchange Sales Contract

I_ExchangeSalesContract is a Basic CDS View that provides data about "Exchange Sales Contract" in SAP S/4HANA. It reads from 1 data source (oia02) and exposes 11 fields with key fields ExchangeAgreement, SalesDocument. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
oia02 oia02 from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_SalesDocumentBasic _SalesDocument $projection.SalesDocument = _SalesDocument.SalesDocument
[1..1] I_ExchangeHeader _ExchangeHeader $projection.ExchangeAgreement = _ExchangeHeader.ExchangeAgreement
[1..1] I_SalesOrganization _SalesOrganization $projection.SalesOrganization = _SalesOrganization.SalesOrganization

Annotations (9)

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

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY ExchangeAgreement oia02 exgnum Exchange no.
KEY SalesDocument oia02 vbeln SD Sched. Agmt
SalesOrganization oia02 vkorg SD Sales Org.
ValidFrom _SalesDocument AgrmtValdtyStartDate
ValidTo _SalesDocument AgrmtValdtyEndDate
SalesContractCreationDate oia02 erdat Entered On
SalesContractCreatedByUser oia02 ernam User Name
SalesContractText oia02 text User Group
_SalesDocument _SalesDocument
_ExchangeHeader _ExchangeHeader
_SalesOrganization _SalesOrganization

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_ExchangeSalesContract.
-- 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: IEXCHSALESCONTR

CREATE VIEW I_ExchangeSalesContract AS
SELECT
  oia02.exgnum AS ExchangeAgreement,
  oia02.vbeln AS SalesDocument,
  oia02.vkorg AS SalesOrganization,
  _SalesDocument.AgrmtValdtyStartDate AS ValidFrom,
  _SalesDocument.AgrmtValdtyEndDate AS ValidTo,
  oia02.erdat AS SalesContractCreationDate,
  oia02.ernam AS SalesContractCreatedByUser,
  oia02.text AS SalesContractText
FROM oia02
LEFT OUTER JOIN I_SalesDocumentBasic AS _SalesDocument ON SalesDocument = _SalesDocument.SalesDocument  -- association [1..1]
LEFT OUTER JOIN I_ExchangeHeader AS _ExchangeHeader ON ExchangeAgreement = _ExchangeHeader.ExchangeAgreement  -- association [1..1]
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrganization ON SalesOrganization = _SalesOrganization.SalesOrganization  -- association [1..1]
;

Learn More