I_CAInvcgRunExternalRef

DDL: I_CAINVCGRUNEXTERNALREF Type: view_entity BASIC
11 Fields 1 Data Sources

Fakturierungsläufe

I_CAInvcgRunExternalRef is a Basic CDS View that provides data about "Fakturierungsläufe" in SAP S/4HANA. It reads from 1 data source (dfkkinvdoc_log) and exposes 11 fields with key fields CAInvcgRunExternalReference, CAInvcgProcess, CAInvcgCreationDate, CAInvcgLogUUID.

Data Sources (1)

SourceAliasJoin Type
dfkkinvdoc_log dfkkinvdoc_log from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
EndUserText.label Fakturierungsläufe view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.representativeKey CAInvcgRunExternalReference view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY CAInvcgRunExternalReference invrun_ref Run Reference
KEY CAInvcgProcess inv_process Invoicing Proc.
KEY CAInvcgCreationDate crdate Sizing Date
KEY CAInvcgLogUUID loguuid UUID
CAReconciliationKey fikey Reconcil. Key
CreatedByUser crname Last Changed By
CAPostingDate budat Posting Date
CAInvcgIsDocumentSimulated simulated Simulation Doc.
CAInvcgIsDocumentPreliminary preliminary Prelim.Invoice
CAIsMassRun massrun Mass Processing
CAMassRunInternalID runkey Valuation Run ID No.

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_CAInvcgRunExternalRef.
-- 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_CAInvcgRunExternalRef AS
SELECT
  invrun_ref AS CAInvcgRunExternalReference,
  inv_process AS CAInvcgProcess,
  crdate AS CAInvcgCreationDate,
  loguuid AS CAInvcgLogUUID,
  fikey AS CAReconciliationKey,
  crname AS CreatedByUser,
  budat AS CAPostingDate,
  simulated AS CAInvcgIsDocumentSimulated,
  preliminary AS CAInvcgIsDocumentPreliminary,
  massrun AS CAIsMassRun,
  runkey AS CAMassRunInternalID
FROM dfkkinvdoc_log
;

Learn More