P_RFM_OrdFlfmtApplJobDocCnt

DDL: P_RFM_ORDFLFMTAPPLJOBDOCCNT SQL: PRFMOFAJDC Type: view COMPOSITE Package: RFM_MONITOR_SD_CHANGES
5 Fields 1 Data Sources

Ord Flfmt Appl Job Doc Cnt

P_RFM_OrdFlfmtApplJobDocCnt is a Composite CDS View that provides data about "Ord Flfmt Appl Job Doc Cnt" in SAP S/4HANA. It reads from 1 data source (I_RFM_OrdFlfmtApplJobDocItem) and exposes 5 fields with key fields SimulationJobUUID, RFMApplJobDocument. Part of development package RFM_MONITOR_SD_CHANGES.

Data Sources (1)

SourceAliasJoin Type
I_RFM_OrdFlfmtApplJobDocItem I_RFM_OrdFlfmtApplJobDocItem from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PRFMOFAJDC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
AbapCatalog.preserveKey true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY SimulationJobUUID SimulationJobUUID Key
KEY RFMApplJobDocument RFMApplJobDocument Sales Document
int4asNumberOfErrorMsgDocuments
int4asNumberOfWarningMsgDocuments
int4asNumberOfInfoSuccessMsgDocs

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_RFM_OrdFlfmtApplJobDocCnt.
-- 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: PRFMOFAJDC

CREATE VIEW P_RFM_OrdFlfmtApplJobDocCnt AS
SELECT
  SimulationJobUUID,
  RFMApplJobDocument,
  cast(sum(case when RFMApplJobDocUpdtSts = 'E' then 1 else 0 end) as abap.int4) as NumberOfErrorMsgDocuments AS int4asNumberOfErrorMsgDocuments,
  cast(sum(case when RFMApplJobDocUpdtSts = 'W' then 1 else 0 end) as abap.int4) as NumberOfWarningMsgDocuments AS int4asNumberOfWarningMsgDocuments,
  cast(sum(case when RFMApplJobDocUpdtSts = 'S' then 1 else 0 end) as abap.int4) as NumberOfInfoSuccessMsgDocs AS int4asNumberOfInfoSuccessMsgDocs
FROM I_RFM_OrdFlfmtApplJobDocItem
;

Learn More