C_PURREQNPROCESSFLOW

CDS View

Purchase Requisition Process flow

C_PURREQNPROCESSFLOW is a CDS View in S/4HANA. Purchase Requisition Process flow. It contains 1 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_ServiceEntrySheetProcessFlow view union_all CONSUMPTION Process Flow For Service Entry Sheet
C_SSPPurReqnProcessFlow view from CONSUMPTION SSP PR Business Process flow

Fields (1)

KeyField CDS FieldsUsed in Views
PrecedingDocumentCategory SubsequentDocumentCategory 1
@AbapCatalog.sqlViewName: 'CPURREQNPROCFLW'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK

@VDM.viewType: #CONSUMPTION

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED

@EndUserText.label: 'Purchase Requisition Process flow'
@AccessControl.personalData.blocking:#REQUIRED
define view C_PurReqnProcessFlow as

  select from I_PurReqnProcessFlow
    association [1..1] to I_Purchaserequisitionitem  as _PurReqnItem on  $projection.PurchaseRequisition = _PurReqnItem.PurchaseRequisition
                                                                     and $projection.PurchaseRequisitionItem = _PurReqnItem.PurchaseRequisitionItem
  {
  //I_PurReqnProcessFlow

  key PrecedingDocument,
  key PrecedingDocumentItem,
  key SubsequentDocument,
  key SubsequentDocumentItem,
  PrecedingDocumentCategory,
  SubsequentDocumentCategory,
  FiscalYear,
  MaterialDocumentYear,
  CompanyCode,
  RecordType,  // Note 2930000

  MaterialDocumentRecordType,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  _PurReqnItem.Plant,
  _PurReqnItem.PurchaseRequisitionType,
  _PurReqnItem.PurchasingGroup,
  _PurReqnItem.PurchasingOrganization,
  @Consumption.hidden: true
  _PurReqnItem.ExtPlantForPurg,
  @Consumption.hidden: true
  _PurReqnItem.ExtCompanyCodeForPurg,
  /* Associations */
  //I_Purchaserequisitionitem

  _PurReqnItem
  }
  where I_PurReqnProcessFlow.PurchaseRequisition is not initial and
  I_PurReqnProcessFlow.PurchaseRequisitionItem is not initial