I_EDCBillingDocumentRecords

DDL: I_EDCBILLINGDOCUMENTRECORDS Type: view_entity BASIC
24 Fields 2 Data Sources

EDC Billing Document Records

I_EDCBillingDocumentRecords is a Basic CDS View that provides data about "EDC Billing Document Records" in SAP S/4HANA. It reads from 2 data sources (I_BillingDocument, I_EDCBillingDocumentRelation) and exposes 24 fields with key fields EDCType, EDCCompany, EDCCommonKey.

Data Sources (2)

SourceAliasJoin Type
I_BillingDocument _BillingDocument inner
I_EDCBillingDocumentRelation _EDCRelation from

Annotations (8)

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

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY EDCType I_EDCBillingDocumentRelation EDCType
KEY EDCCompany I_EDCBillingDocumentRelation EDCCompany
KEY EDCCommonKey I_EDCBillingDocumentRelation EDCCommonKey
BillingDocument I_EDCBillingDocumentRelation BillingDocument SD Document
EDCRecordUUID I_EDCBillingDocumentRelation EDCRecordUUID
EDCCreatedOnDateTime I_EDCBillingDocumentRelation EDCCreatedOnDateTime
EDCRepresentationType I_EDCBillingDocumentRelation EDCRepresentationType
EDCRepresentationKey I_EDCBillingDocumentRelation EDCRepresentationKey
BillingDocumentCategory I_BillingDocument BillingDocumentCategory BillingCategory
BillingDocumentType I_BillingDocument BillingDocumentType Billing Type
BillingDocumentDate I_BillingDocument BillingDocumentDate Billing Date
CompanyCode I_BillingDocument CompanyCode Receiver Company Code
BillingDocumentIsCancelled I_BillingDocument BillingDocumentIsCancelled Canceled
BillingIssueType I_BillingDocument BillingIssueType
SalesOrganization I_BillingDocument SalesOrganization Sales Organization
DistributionChannel I_BillingDocument DistributionChannel RefDistCh-Cust/Mat.
Division I_BillingDocument Division Internal Division ID
AccountingDocument I_BillingDocument AccountingDocument Journal Entry
FiscalYear I_BillingDocument FiscalYear G/L Fiscal Year
FiscalPeriod I_BillingDocument FiscalPeriod Tax period
ReversalReason I_BillingDocument ReversalReason Reversal Reason
TotalNetAmount I_BillingDocument TotalNetAmount Total Net Amount
TransactionCurrency I_BillingDocument TransactionCurrency Transaction Currency
TotalTaxAmount I_BillingDocument TotalTaxAmount Tax Amount

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_EDCBillingDocumentRecords.
-- 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_EDCBillingDocumentRecords AS
SELECT
  _EDCRelation.EDCType AS EDCType,
  _EDCRelation.EDCCompany AS EDCCompany,
  _EDCRelation.EDCCommonKey AS EDCCommonKey,
  _EDCRelation.BillingDocument AS BillingDocument,
  _EDCRelation.EDCRecordUUID AS EDCRecordUUID,
  _EDCRelation.EDCCreatedOnDateTime AS EDCCreatedOnDateTime,
  _EDCRelation.EDCRepresentationType AS EDCRepresentationType,
  _EDCRelation.EDCRepresentationKey AS EDCRepresentationKey,
  _BillingDocument.BillingDocumentCategory AS BillingDocumentCategory,
  _BillingDocument.BillingDocumentType AS BillingDocumentType,
  _BillingDocument.BillingDocumentDate AS BillingDocumentDate,
  _BillingDocument.CompanyCode AS CompanyCode,
  _BillingDocument.BillingDocumentIsCancelled AS BillingDocumentIsCancelled,
  _BillingDocument.BillingIssueType AS BillingIssueType,
  _BillingDocument.SalesOrganization AS SalesOrganization,
  _BillingDocument.DistributionChannel AS DistributionChannel,
  _BillingDocument.Division AS Division,
  _BillingDocument.AccountingDocument AS AccountingDocument,
  _BillingDocument.FiscalYear AS FiscalYear,
  _BillingDocument.FiscalPeriod AS FiscalPeriod,
  _BillingDocument.ReversalReason AS ReversalReason,
  _BillingDocument.TotalNetAmount AS TotalNetAmount,
  _BillingDocument.TransactionCurrency AS TransactionCurrency,
  _BillingDocument.TotalTaxAmount AS TotalTaxAmount
FROM I_EDCBillingDocumentRelation AS _EDCRelation
INNER JOIN I_BillingDocument AS _BillingDocument ON /* join condition not captured in parsed metadata */
;

Learn More