I_EDCSalesOrderRecords

DDL: I_EDCSALESORDERRECORDS Type: view_entity BASIC
26 Fields 2 Data Sources

EDC Relevant Sales Order Records

I_EDCSalesOrderRecords is a Basic CDS View that provides data about "EDC Relevant Sales Order Records" in SAP S/4HANA. It reads from 2 data sources (I_EDCSalesDocumentRelation, I_SalesOrder) and exposes 26 fields with key fields EDCType, EDCCompany, EDCCommonKey.

Data Sources (2)

SourceAliasJoin Type
I_EDCSalesDocumentRelation _EDCRelation from
I_SalesOrder _SalesOrder inner

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label EDC Relevant Sales Order Records view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY EDCType I_EDCSalesDocumentRelation EDCType
KEY EDCCompany I_EDCSalesDocumentRelation EDCCompany
KEY EDCCommonKey I_EDCSalesDocumentRelation EDCCommonKey
SalesOrder I_EDCSalesDocumentRelation SalesOrder SD Document
EDCRepresentationKey I_EDCSalesDocumentRelation EDCRepresentationKey
EDCRepresentationType I_EDCSalesDocumentRelation EDCRepresentationType
EDCRecordUUID I_EDCSalesDocumentRelation EDCRecordUUID
EDCCreatedOnDateTime I_EDCSalesDocumentRelation EDCCreatedOnDateTime
SalesOrderType I_SalesOrder SalesOrderType Sales Order Type
SalesOrderProcessingType I_SalesOrder SalesOrderProcessingType
SalesOrderDate I_SalesOrder SalesOrderDate Document Date
SalesGroup I_SalesOrder SalesGroup Sales Group
BillingCompanyCode I_SalesOrder BillingCompanyCode CCodeToBeBilled
SalesOrderApprovalReason I_SalesOrder SalesOrderApprovalReason
SalesOrganization I_SalesOrder SalesOrganization Sales Organization
DistributionChannel I_SalesOrder DistributionChannel RefDistCh-Cust/Mat.
SoldToParty I_SalesOrder SoldToParty Sold-to Party
CostCenter I_SalesOrder CostCenter Cost Center
ControllingArea I_SalesOrder ControllingArea Controlling Area
CustomerGroup I_SalesOrder CustomerGroup Customer Group
SalesDistrict I_SalesOrder SalesDistrict Sales District
ShippingType I_SalesOrder ShippingType Shipping Type
FiscalYear I_SalesOrder FiscalYear G/L Fiscal Year
FiscalPeriod I_SalesOrder FiscalPeriod Tax period
TotalNetAmount I_SalesOrder TotalNetAmount Total Net Amount
TransactionCurrency I_SalesOrder TransactionCurrency Transaction Currency

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_EDCSalesOrderRecords.
-- 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.

CREATE VIEW I_EDCSalesOrderRecords AS
SELECT
  _EDCRelation.EDCType AS EDCType,
  _EDCRelation.EDCCompany AS EDCCompany,
  _EDCRelation.EDCCommonKey AS EDCCommonKey,
  _EDCRelation.SalesOrder AS SalesOrder,
  _EDCRelation.EDCRepresentationKey AS EDCRepresentationKey,
  _EDCRelation.EDCRepresentationType AS EDCRepresentationType,
  _EDCRelation.EDCRecordUUID AS EDCRecordUUID,
  _EDCRelation.EDCCreatedOnDateTime AS EDCCreatedOnDateTime,
  _SalesOrder.SalesOrderType AS SalesOrderType,
  _SalesOrder.SalesOrderProcessingType AS SalesOrderProcessingType,
  _SalesOrder.SalesOrderDate AS SalesOrderDate,
  _SalesOrder.SalesGroup AS SalesGroup,
  _SalesOrder.BillingCompanyCode AS BillingCompanyCode,
  _SalesOrder.SalesOrderApprovalReason AS SalesOrderApprovalReason,
  _SalesOrder.SalesOrganization AS SalesOrganization,
  _SalesOrder.DistributionChannel AS DistributionChannel,
  _SalesOrder.SoldToParty AS SoldToParty,
  _SalesOrder.CostCenter AS CostCenter,
  _SalesOrder.ControllingArea AS ControllingArea,
  _SalesOrder.CustomerGroup AS CustomerGroup,
  _SalesOrder.SalesDistrict AS SalesDistrict,
  _SalesOrder.ShippingType AS ShippingType,
  _SalesOrder.FiscalYear AS FiscalYear,
  _SalesOrder.FiscalPeriod AS FiscalPeriod,
  _SalesOrder.TotalNetAmount AS TotalNetAmount,
  _SalesOrder.TransactionCurrency AS TransactionCurrency
FROM I_EDCSalesDocumentRelation AS _EDCRelation
INNER JOIN I_SalesOrder AS _SalesOrder ON /* join condition not captured in parsed metadata */
;

Learn More