I_AR_ElectronicInvoice

DDL: I_AR_ELECTRONICINVOICE SQL: IARELCTRNCINVC Type: view BASIC
8 Fields 1 Data Sources

AR Electronic Invoice CAE Tracking

I_AR_ElectronicInvoice is a Basic CDS View that provides data about "AR Electronic Invoice CAE Tracking" in SAP S/4HANA. It reads from 1 data source (j_1acae) and exposes 8 fields with key fields CompanyCode, Branch, ReferenceDocument, FiscalYear, ReferenceDocumentType.

Data Sources (1)

SourceAliasJoin Type
j_1acae j_1acae from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IARELCTRNCINVC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label AR Electronic Invoice CAE Tracking view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode bukrs Value
KEY Branch brnch Business Place
KEY ReferenceDocument cae_ref CAE ref doc
KEY FiscalYear cae_refyr Fiscal Year
KEY ReferenceDocumentType cae_reftyp CAE ref type
KEY AR_DocumentPostingDate budat Posting Date
AR_CAE cae_num CAE number
AR_CAEInvoiceDueDate cae_duedate CAE duedate

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_AR_ElectronicInvoice.
-- 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: IARELCTRNCINVC

CREATE VIEW I_AR_ElectronicInvoice AS
SELECT
  bukrs AS CompanyCode,
  brnch AS Branch,
  cae_ref AS ReferenceDocument,
  cae_refyr AS FiscalYear,
  cae_reftyp AS ReferenceDocumentType,
  budat AS AR_DocumentPostingDate,
  cae_num AS AR_CAE,
  cae_duedate AS AR_CAEInvoiceDueDate
FROM j_1acae
;

Learn More