P_PHRPRqItmSimlnDistDocs

DDL: P_PHRPRQITMSIMLNDISTDOCS Type: view_entity CONSUMPTION

Distinct Documents in app log

P_PHRPRqItmSimlnDistDocs is a Consumption CDS View that provides data about "Distinct Documents in app log" in SAP S/4HANA. It reads from 1 data source (I_PurchasingDocSimulationJob) and exposes 4 fields with key field SimulationJobUUID.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
I_PurchasingDocSimulationJob SimlnJob inner

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Distinct Documents in app log view
VDM.private true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY SimulationJobUUID I_PurchasingDocSimulationLog SimulationJobUUID
PurchasingDocument I_PurchasingDocSimulationLog PurchasingDocument
PurchasingDocumentItem I_PurchasingDocSimulationLog PurchasingDocumentItem
ProcurementHubSourceSystem I_PurchasingDocSimulationJob ProcurementHubSourceSystem 
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Distinct Documents in app log'
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType: {dataClass: #TRANSACTIONAL, serviceQuality: #A, sizeCategory: #L}

define view entity P_PHRPRqItmSimlnDistDocs
  as select distinct from I_PurchasingDocSimulationLog
    inner join            I_PurchasingDocSimulationJob as SimlnJob on I_PurchasingDocSimulationLog.SimulationJobUUID = SimlnJob.SimulationJobUUID
{

  key I_PurchasingDocSimulationLog.SimulationJobUUID,
      I_PurchasingDocSimulationLog.PurchasingDocument,
      I_PurchasingDocSimulationLog.PurchasingDocumentItem,
      SimlnJob.ProcurementHubSourceSystem

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASINGDOCSIMULATIONJOB",
"I_PURCHASINGDOCSIMULATIONLOG"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More