P_ARUNASSGMTSUP

CDS View

P_ARUNASSGMTSUP is a CDS View in S/4HANA. It contains 4 fields. 18 CDS views read from this table.

Used by 18 CDS view(s) 4 fields

CDS Views using this table (18)

ViewTypeJoinVDMDescription
I_SupDmndAllDocBatchStock view left_outer COMPOSITE View for Batch Stock
I_SupDmndAllDocBatStkC view left_outer COMPOSITE Cube View for Batch Stock Details
I_SupDmndAllDocConfCube view left_outer COMPOSITE Cube View for Supplier Confirmations Details
I_SupDmndAllDocConfirmations view left_outer COMPOSITE View for Supplier Confirmations
I_SupDmndAllDocNonBatchStock view left_outer COMPOSITE View for Non Batch Stock
I_SupDmndAllDocNonBatStkC view left_outer COMPOSITE Cube View for Non Batch Stock Details
I_SupDmndAllDocPlndOrd view left_outer COMPOSITE View for Planned Order
I_SupDmndAllDocPlndOrdCube view left_outer COMPOSITE Cube View for Planned Order Details
I_SupDmndAllDocPO view left_outer COMPOSITE View for Purchase Order
I_SupDmndAllDocPOCube view left_outer COMPOSITE Cube View for Purchase Order Details
I_SupDmndAllDocProdnOrd view left_outer COMPOSITE View for Production Order
I_SupDmndAllDocProdnOrdC view left_outer COMPOSITE Cube View for Production Order Details
I_SupDmndAllDocPurgContrC view left_outer COMPOSITE Cube View for Purchasing Contract Details
I_SupDmndAllDocPurReqn view left_outer COMPOSITE View for Purchase Requisition
I_SupDmndAllDocPurReqnCube view left_outer COMPOSITE Cube View for Purchase Requisition Details
I_SupDmndAllDocRetDelivC view left_outer COMPOSITE Cube View for Return Deliveries Details
I_SupDmndAllDocRetSlsOrdC view left_outer COMPOSITE Cube View for Return Sales Orders Details
I_SupDmndAllDocTotSup view left_outer COMPOSITE View for Total Supply of All Document Types

Fields (4)

KeyField CDS FieldsUsed in Views
ARunTmpAssignedQuantityInBsUnt ARunTmpAssignedQuantityInBsUnt 11
AssignedQuantityInBaseUnit AssignedQuantityInBaseUnit 16
NormalAssignedQuantityInBsUnt NormalAssignedQuantityInBsUnt 16
PreviewAssignedQuantityInBsUnt PreviewAssignedQuantityInBsUnt 16 
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM: {
  viewType: #COMPOSITE
}
@VDM.private: true
@AccessControl: {
  authorizationCheck: #NOT_REQUIRED,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@AbapCatalog: {
  sqlViewName: 'PARUNASSGMTSUP',
  compiler.compareFilter: true
 }
@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #B,
     sizeCategory:   #XXL
   }
}
//@EndUserText.label: 'View for Supply Assignment Results from Supply Perspective'

define view P_ARunAssgmtSup
  as select from I_ARunAllSupAssgmt  as Assgmt
{
  Assgmt.Batch,
  Assgmt.StorageLocation,
  Assgmt.SupplyNumber,
  Assgmt.SupplyItem,
  Assgmt.SupplyScheduleLine,
  Assgmt.AssignedSupplyType,
  Assgmt.SupAssgmtSource,
  Assgmt.Material,
  Assgmt.Plant,
  sum(Assgmt.AssignedQuantityInBaseUnit)     as AssignedQuantityInBaseUnit,
  sum(Assgmt.NormalAssignedQuantityInBsUnt)  as NormalAssignedQuantityInBsUnt,
  sum(Assgmt.PreviewAssignedQuantityInBsUnt) as PreviewAssignedQuantityInBsUnt,
  sum(Assgmt.ARunTmpAssignedQuantityInBsUnt) as ARunTmpAssignedQuantityInBsUnt,
  Assgmt.BaseUnit
}
group by
  Assgmt.Batch,
  Assgmt.StorageLocation,
  Assgmt.SupplyNumber,
  Assgmt.SupplyItem,
  Assgmt.SupplyScheduleLine,
  Assgmt.AssignedSupplyType,
  Assgmt.SupAssgmtSource,
  Assgmt.Material,
  Assgmt.Plant,
  Assgmt.BaseUnit
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ARUNALLSUPASSGMT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More