P_PurchasingDocSimulationJob

DDL: P_PURCHASINGDOCSIMULATIONJOB SQL: PPURGDOCSIM Type: view CONSUMPTION

P View for Purch Doc Simulation Job

P_PurchasingDocSimulationJob is a Consumption CDS View that provides data about "P View for Purch Doc Simulation Job" in SAP S/4HANA. It reads from 1 data source (I_PurchasingDocSimulationJob) and exposes 23 fields with key field SimulationJobUUID.

1 data source(s) 23 fields

Data Sources (1)

SourceAliasJoin Type
I_PurchasingDocSimulationJob I_PurchasingDocSimulationJob from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PPURGDOCSIM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label P View for Purch Doc Simulation Job view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #CONSUMPTION view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY SimulationJobUUID SimulationJobUUID
ApplicationJob ApplicationJob
ApplicationJobName ApplicationJobName
ApplicationLogHandle ApplicationLogHandle
PlannedStartDate PlannedStartDate
PlannedStartTime PlannedStartTime
AsyncApplicationJobStatus AsyncApplicationJobStatus
ReleaseDateTime ReleaseDateTime
ApplicationJobDescription ApplicationJobDescription
CreatedByUser CreatedByUser
LogNumber LogNumber
PurgDocMassUpdtIsSimulated PurgDocMassUpdtIsSimulated
PurchasingDocumentCategory PurchasingDocumentCategory
ReferenceApplicationJobName ReferenceApplicationJobName
ApplicationJobTemplate ApplicationJobTemplate
ApplicationJobTemplateVersion ApplicationJobTemplateVersion
PurchasingDocumentSubtype PurchasingDocumentSubtype
NumberOfUniqueErrors NumberOfUniqueErrors
NumberOfUniqueWarnings NumberOfUniqueWarnings
NumberOfUniqueInfoSuccessMsgs NumberOfUniqueInfoSuccessMsgs
NumberOfErrorMsgDocuments NumberOfErrorMsgDocuments
NumberOfWarningMsgDocuments NumberOfWarningMsgDocuments
NumberOfInfoSuccessMsgDocs NumberOfInfoSuccessMsgDocs 
@AbapCatalog.sqlViewName: 'PPURGDOCSIM'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'P View for Purch Doc Simulation Job'
@ObjectModel.usageType: {dataClass: #TRANSACTIONAL, serviceQuality: #A, sizeCategory: #L}
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private: true
@VDM.viewType: #CONSUMPTION

define view P_PurchasingDocSimulationJob
  as select from I_PurchasingDocSimulationJob
{
  key SimulationJobUUID,  
      ApplicationJob,
      ApplicationJobName,
      ApplicationLogHandle,
      PlannedStartDate,
      PlannedStartTime,
      AsyncApplicationJobStatus,
      ReleaseDateTime,
      ApplicationJobDescription,
      CreatedByUser,
      LogNumber,
      PurgDocMassUpdtIsSimulated,
      PurchasingDocumentCategory,
      ReferenceApplicationJobName,
      ApplicationJobTemplate,
      ApplicationJobTemplateVersion,
      PurchasingDocumentSubtype,                             
      NumberOfUniqueErrors,
      NumberOfUniqueWarnings,
      NumberOfUniqueInfoSuccessMsgs,
      NumberOfErrorMsgDocuments,
      NumberOfWarningMsgDocuments,
      NumberOfInfoSuccessMsgDocs,
      case when not (PurchasingDocumentCategory = 'C' and PurchasingDocumentSubtype ='') 
        then cast ('X' as boolean)
            end as CntrlPurContrIsNotActv,
      case when not (PurchasingDocumentCategory = 'C' and PurchasingDocumentSubtype ='H') 
        then cast ('X' as boolean)
            end as CntrlPurContrHierIsNotActv,
      case when not (PurchasingDocumentCategory = 'F') 
        then cast ('X' as boolean)
            end as PurchaseOrderIsNotActive,
      case when not (PurchasingDocumentCategory = 'Y') 
        then cast ('X' as boolean)
            end as CntrlPurReqnIsNotActv     
         
}

Learn More