I_CAInvcgDocLog

DDL: I_CAINVCGDOCLOG Type: view_entity BASIC
19 Fields 1 Data Sources 1 Associations

Protokoll der Fakturierungsläufe

I_CAInvcgDocLog is a Basic CDS View that provides data about "Protokoll der Fakturierungsläufe" in SAP S/4HANA. It reads from 1 data source (dfkkinvdoc_log) and exposes 19 fields with key fields CAInvcgProcess, CAInvcgCreationDate, CAInvcgLogUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
dfkkinvdoc_log dfkkinvdoc_log from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_CAInvcgProcess _CAInvcgProcess $projection.CAInvcgProcess = _CAInvcgProcess.CAInvcgProcess

Annotations (7)

NameValueLevelField
ObjectModel.representativeKey CAInvcgLogUUID view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Protokoll der Fakturierungsläufe view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY CAInvcgProcess inv_process Invoicing Proc.
KEY CAInvcgCreationDate crdate Sizing Date
KEY CAInvcgLogUUID loguuid UUID
CAInvcgDocInternalNumber invrunno Invoicg Run No.
CAInvcgRunExternalReference invrun_ref Run Reference
CreatedByUser crname Last Changed By
CAPostingDate budat Posting Date
CAReconciliationKey fikey Reconcil. Key
CAInvcgType inv_type SAF-T Inv. Type
CAInvcgCategory inv_category Invoicing Cat.
CAInvcgDocumentType doctype TSW Document type
CAInvcgDocIsReversalDocument xreversal Reversal Transaction
CAInvcgIsDocumentPosted invoiced TRUE
CAInvcgIsDocumentSimulated simulated Simulation Doc.
CAInvcgIsDocumentPreliminary preliminary Prelim.Invoice
CAIsMassRun massrun Mass Processing
CAMassRunInternalID runkey Valuation Run ID No.
CAInvcgProcessText
_CAInvcgProcess _CAInvcgProcess

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_CAInvcgDocLog.
-- 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_CAInvcgDocLog AS
SELECT
  inv_process AS CAInvcgProcess,
  crdate AS CAInvcgCreationDate,
  loguuid AS CAInvcgLogUUID,
  invrunno AS CAInvcgDocInternalNumber,
  invrun_ref AS CAInvcgRunExternalReference,
  crname AS CreatedByUser,
  budat AS CAPostingDate,
  fikey AS CAReconciliationKey,
  inv_type AS CAInvcgType,
  inv_category AS CAInvcgCategory,
  doctype AS CAInvcgDocumentType,
  xreversal AS CAInvcgDocIsReversalDocument,
  invoiced AS CAInvcgIsDocumentPosted,
  simulated AS CAInvcgIsDocumentSimulated,
  preliminary AS CAInvcgIsDocumentPreliminary,
  massrun AS CAIsMassRun,
  runkey AS CAMassRunInternalID,
  _CAInvcgProcess._CAInvcgProcessText[1: Language=$session.system_language].CAInvcgProcessText AS CAInvcgProcessText
FROM dfkkinvdoc_log
LEFT OUTER JOIN I_CAInvcgProcess AS _CAInvcgProcess ON CAInvcgProcess = _CAInvcgProcess.CAInvcgProcess  -- association [0..1]
;

Learn More