P_ProjPurDocItems

DDL: P_PROJPURDOCITEMS SQL: PPURDOCI Type: view COMPOSITE

P_ProjPurDocItems is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_PurgDocAccountAssignment, I_PurReqnAcctAssgmt) and exposes 37 fields with key fields PurchasingDocument, PurchasingDocumentItem, AccountAssignmentNumber, PurchasingDocumentItem, AccountAssignmentNumber. It has 1 association to related views.

2 data source(s) 37 fields

Data Sources (2)

SourceAliasJoin Type
I_PurgDocAccountAssignment PurDocAcctAssgmt union_all
I_PurReqnAcctAssgmt PurReqnAcctAssgmt from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_Purchaserequisitionitem _PurItem _PurItem.PurchaseRequisition = $projection.PurchasingDocument and _PurItem.PurchaseRequisitionItem = $projection.PurchasingDocumentItem

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PPURDOCI view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #CHECK view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument I_PurReqnAcctAssgmt PurchaseRequisition
KEY PurchasingDocumentItem I_PurReqnAcctAssgmt PurchaseRequisitionItem
KEY AccountAssignmentNumber I_PurReqnAcctAssgmt PurchaseReqnAcctAssgmtNumber
WBSElementInternalID I_PurReqnAcctAssgmt WBSElementInternalID
ProjectNetworkInternalID I_PurReqnAcctAssgmt ProjectNetworkInternalID
NetworkActivityInternalID I_PurReqnAcctAssgmt NetworkActivityInternalID
ProjectNetwork I_PurReqnAcctAssgmt ProjectNetwork
PurchasingDocumentType _PurItem PurchaseRequisitionType
PurchasingDocumentTypeName
PurchasingDocumentItemText _PurItem PurchaseRequisitionItemText
DeliveryDate _PurItem DeliveryDate
BaseUnit _PurItem BaseUnit
RequestedQuantity _PurItem RequestedQuantity
Plant _PurItem Plant
PlantName
Supplier _PurItem Supplier
Material _PurItem Material
MaterialGroup _PurItem MaterialGroup
PurchasingDocument
KEY PurchasingDocumentItem I_PurgDocAccountAssignment PurchasingDocumentItem
KEY AccountAssignmentNumber I_PurgDocAccountAssignment AccountAssignmentNumber
WBSElementInternalID I_PurgDocAccountAssignment WBSElementInternalID
ProjectNetworkInternalID I_PurgDocAccountAssignment ProjectNetworkInternalID
NetworkActivityInternalID I_PurgDocAccountAssignment NetworkActivityInternalID
ProjectNetwork I_PurgDocAccountAssignment ProjectNetwork
PurchasingDocumentType
PurchasingDocumentTypeName
PurchasingDocumentItemText _PurItem PurchasingDocumentItemText
DeliveryDate
BaseUnit _PurItem BaseUnit
RequestedQuantity _PurItem OrderQuantity
Plant _PurItem Plant
PlantName
Supplier
Material _PurItem Material
MaterialGroup _PurItem MaterialGroup
PurchasingDocumentCategory _PurItem PurchasingDocumentCategory 
@AbapCatalog.sqlViewName: 'PPURDOCI'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType:#COMPOSITE
@VDM.private: true
@AccessControl.authorizationCheck: #CHECK


define view P_ProjPurDocItems
  as select from I_PurReqnAcctAssgmt as PurReqnAcctAssgmt

  association [1..1] to I_Purchaserequisitionitem as _PurItem on  _PurItem.PurchaseRequisition     = $projection.PurchasingDocument
                                                              and _PurItem.PurchaseRequisitionItem = $projection.PurchasingDocumentItem
{
  key PurReqnAcctAssgmt.PurchaseRequisition     as PurchasingDocument,

  key PurReqnAcctAssgmt.PurchaseRequisitionItem as PurchasingDocumentItem,
  
  key PurReqnAcctAssgmt.PurchaseReqnAcctAssgmtNumber as AccountAssignmentNumber,

      PurReqnAcctAssgmt.WBSElementInternalID,
      PurReqnAcctAssgmt.ProjectNetworkInternalID,
      PurReqnAcctAssgmt.NetworkActivityInternalID,
      PurReqnAcctAssgmt.ProjectNetwork,
      _PurItem.PurchaseRequisitionType          as PurchasingDocumentType,
      _PurItem._PurchasingDocumentType._Text[1:Language = $session.system_language].PurchasingDocumentTypeName,
      _PurItem.PurchaseRequisitionItemText      as PurchasingDocumentItemText,
      _PurItem.DeliveryDate,
      _PurItem.BaseUnit,
      _PurItem.RequestedQuantity,
      _PurItem.Plant,
      _PurItem._Plant.PlantName,
      _PurItem.Supplier,
      _PurItem.Material,
      _PurItem.MaterialGroup,
      _PurItem.PurchasingDocumentCategory

}
where
     ( PurReqnAcctAssgmt.WBSElementInternalID     <> '00000000'
  or PurReqnAcctAssgmt.ProjectNetworkInternalID <> '0000000000' ) or PurReqnAcctAssgmt.ProjectNetwork <> ''

union all

select from I_PurgDocAccountAssignment as PurDocAcctAssgmt

association [1..1] to I_PurchasingDocumentItem as _PurItem on  _PurItem.PurchasingDocument     = $projection.PurchasingDocument
                                                           and _PurItem.PurchasingDocumentItem = $projection.PurchasingDocumentItem
{
  key PurDocAcctAssgmt.PurchasingDocument,

  key PurDocAcctAssgmt.PurchasingDocumentItem,
  
  key PurDocAcctAssgmt.AccountAssignmentNumber,

      PurDocAcctAssgmt.WBSElementInternalID,
      PurDocAcctAssgmt.ProjectNetworkInternalID,
      PurDocAcctAssgmt.NetworkActivityInternalID,
      PurDocAcctAssgmt.ProjectNetwork,
      _PurItem._PurchasingDocument.PurchasingDocumentType,
      _PurItem._PurchasingDocument._PurchasingDocumentType._Text[1:Language = $session.system_language].PurchasingDocumentTypeName,
      _PurItem.PurchasingDocumentItemText,
      '00000000'             as DeliveryDate,
      _PurItem.BaseUnit,
      _PurItem.OrderQuantity as RequestedQuantity,
      _PurItem.Plant,
      _PurItem._Plant.PlantName,
      _PurItem._PurchasingDocument.Supplier,
      _PurItem.Material,
      _PurItem.MaterialGroup,
      _PurItem.PurchasingDocumentCategory

}
where
     ( PurDocAcctAssgmt.WBSElementInternalID     <> '00000000'
  or PurDocAcctAssgmt.ProjectNetworkInternalID <> '0000000000' ) or  PurDocAcctAssgmt.ProjectNetwork <> ''

Learn More