P_RO_SAFTCActgSrfSrcGle0

DDL: P_RO_SAFTCACTGSRFSRCGLE0 Type: view_entity CONSUMPTION Package: FKK_ID_RO_REP
10 Fields 2 Data Sources

DB FKKID_RO_SRF_SRC

P_RO_SAFTCActgSrfSrcGle0 is a Consumption CDS View that provides data about "DB FKKID_RO_SRF_SRC" in SAP S/4HANA. It reads from 2 data sources (I_RO_SAFTContrAcctgGLItemLog, I_RO_SAFTContrAcctgSrcDocLog) and exposes 10 fields with key fields StatryRptgEntity, StatryRptCategory, StatryRptRunID, LogicalSystem, CompanyCode. Part of development package FKK_ID_RO_REP.

Data Sources (2)

SourceAliasJoin Type
I_RO_SAFTContrAcctgGLItemLog gle inner
I_RO_SAFTContrAcctgSrcDocLog src from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #CONSUMPTION view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY StatryRptgEntity I_RO_SAFTContrAcctgSrcDocLog StatryRptgEntity Reporting Entity
KEY StatryRptCategory I_RO_SAFTContrAcctgSrcDocLog StatryRptCategory Report ID
KEY StatryRptRunID I_RO_SAFTContrAcctgSrcDocLog StatryRptRunID Report Run ID
KEY LogicalSystem I_RO_SAFTContrAcctgSrcDocLog LogicalSystem Logical System
KEY CompanyCode I_RO_SAFTContrAcctgSrcDocLog CompanyCode Receiver Company Code
KEY RO_CASourceDocumentCategory I_RO_SAFTContrAcctgSrcDocLog RO_CASourceDocumentCategory
KEY RO_CASourceDocumentType I_RO_SAFTContrAcctgSrcDocLog RO_CASourceDocumentType
KEY RO_CASourceDocumentNumber I_RO_SAFTContrAcctgSrcDocLog RO_CASourceDocumentNumber
KEY RO_CAProcessingBatchID I_RO_SAFTContrAcctgSrcDocLog RO_CAProcessingBatchID
KEY CADocumentNumber I_RO_SAFTContrAcctgGLItemLog CADocumentNumber Document Number

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 P_RO_SAFTCActgSrfSrcGle0.
-- 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 P_RO_SAFTCActgSrfSrcGle0 AS
SELECT
  src.StatryRptgEntity AS StatryRptgEntity,
  src.StatryRptCategory AS StatryRptCategory,
  src.StatryRptRunID AS StatryRptRunID,
  src.LogicalSystem AS LogicalSystem,
  src.CompanyCode AS CompanyCode,
  src.RO_CASourceDocumentCategory AS RO_CASourceDocumentCategory,
  src.RO_CASourceDocumentType AS RO_CASourceDocumentType,
  src.RO_CASourceDocumentNumber AS RO_CASourceDocumentNumber,
  src.RO_CAProcessingBatchID AS RO_CAProcessingBatchID,
  gle.CADocumentNumber AS CADocumentNumber
FROM I_RO_SAFTContrAcctgSrcDocLog AS src
INNER JOIN I_RO_SAFTContrAcctgGLItemLog AS gle ON /* join condition not captured in parsed metadata */
;

Learn More