I_CAStRpDocumentAdvancedLog

DDL: I_CASTRPDOCUMENTADVANCEDLOG Type: view_entity BASIC
9 Fields 1 Data Sources

FICA Document log Advanced

I_CAStRpDocumentAdvancedLog is a Basic CDS View that provides data about "FICA Document log Advanced" in SAP S/4HANA. It reads from 1 data source (dfkk_srf_rep_adv) and exposes 9 fields with key fields StatryRptgEntity, StatryRptCategory, StatryRptRunID, LogicalSystem, CompanyCode.

Data Sources (1)

SourceAliasJoin Type
dfkk_srf_rep_adv dfkk_srf_rep_adv from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label FICA Document log Advanced view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY StatryRptgEntity statryrptgentity Reporting Entity
KEY StatryRptCategory statryrptcategory Report ID
KEY StatryRptRunID statryrptrunid Report Run ID
KEY LogicalSystem logicalsystem Logical System
KEY CompanyCode companycode Receiver Company Code
KEY CADocumentNumber cadocumentnumber Document Number
CARptgSrceRefType carptgsrcereftype
CARptgSrceReference carptgsrcereference
CARptgProcgBatchID carptgprocgbatchid

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_CAStRpDocumentAdvancedLog.
-- 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_CAStRpDocumentAdvancedLog AS
SELECT
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  LogicalSystem,
  CompanyCode,
  CADocumentNumber,
  CARptgSrceRefType,
  CARptgSrceReference,
  CARptgProcgBatchID
FROM dfkk_srf_rep_adv
;

Learn More