P_ARUNASSGMTSUPTYPE

CDS View

P_ARUNASSGMTSUPTYPE is a CDS View in S/4HANA. It contains 9 fields. 14 CDS views read from this table.

Used by 14 CDS view(s) 9 fields

CDS Views using this table (14)

ViewTypeJoinVDMDescription
I_SupDmndAllDoc3rdPtyOrdAssgC view from COMPOSITE Cube View for Third Party Orders Assignment Details
I_SupDmndAllDocContrAssgC view from COMPOSITE Cube View for Contract Assignment Details
I_SupDmndAllDocMakeToOrdAssgC view from COMPOSITE Cube View for Make To Order Assignment Details
I_SupDmndAllDocPlndIndepRqmt1C view from COMPOSITE Cube View for Planned Independent Requirement Assignments
I_SupDmndAllDocPlndOrdComp1C view from COMPOSITE Cube View for Planned Order Components Assignment Details
I_SupDmndAllDocProdnOrdComp1C view from COMPOSITE Cube View for Production Order Components Assignment Details
I_SupDmndAllDocPurOrdComp1C view from COMPOSITE Cube View for Sub Contracting PO Components Assignments
I_SupDmndAllDocPurReqnComp1C view from COMPOSITE Cube View for Sub Contracting PR Components Assignments
I_SupDmndAllDocPurToOrdAssgC view from COMPOSITE Cube View for Purchase To Order Assignment Details
I_SupDmndAllDocRetsSupAssgC view from COMPOSITE Cube View for Returns from PO/STO Assignment Details
I_SupDmndAllDocSlsOrdAssgC view from COMPOSITE Cube View for Sales Order Assignment Details
I_SupDmndAllDocStkTransptReq1C view from COMPOSITE Cube View for Stock Transport Requisition Assignment Details
I_SupDmndAllDocSTOAssgC view from COMPOSITE Cube View for Stock Transport Order Assignment Details
I_SupDmndAllDocSupProt1C view from COMPOSITE Supply Protection Assignment Details

Fields (9)

KeyField CDS FieldsUsed in Views
KEY AssignedSupplyType AssignedSupplyType 14
KEY ProductAvailabilityDate ProductAvailabilityDate 1
KEY RequestedDate RequestedDate 1
KEY SupAssgmtSource SupAssgmtSource 14
ARunTmpAssignedQuantityInBsUnt ARunTmpAssignedQuantityInBsUnt 14
AssignedQuantityInBaseUnit AssignedQuantityInBaseUnit 13
BaseUnit BaseUnit 1
NormalAssignedQuantityInBsUnt NormalAssignedQuantityInBsUnt 13
PreviewAssignedQuantityInBsUnt PreviewAssignedQuantityInBsUnt 13 
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM: {
  viewType: #COMPOSITE
}
@VDM.private: true
@AccessControl: {
  authorizationCheck: #NOT_REQUIRED,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@AbapCatalog: {
  sqlViewName: 'PARUNADMNDSUPT',
  compiler.compareFilter: true,
  preserveKey: true
 }
@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #B,
     sizeCategory:   #XXL
   }
}
//@EndUserText.label: 'View for Assignments from Demand and Supply Type Perspective'

define view P_ARunAssgmtSupType
  as select from I_ARunAllAssignments as Assgmt
{
  key Assgmt.RequirementDocumentNumber,
  key Assgmt.RequirementDocumentItem,
  key Assgmt.SupProtTimeBucketUUID,
  key Assgmt.RequestedDate,
  key Assgmt.ProductAvailabilityDate,
  key Assgmt.RequirementType,
  key Assgmt.AssignedSupplyType,
  key Assgmt.SupAssgmtSource,
  key Assgmt.Material,
  key 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.RequirementDocumentNumber,
  Assgmt.RequirementDocumentItem,
  Assgmt.SupProtTimeBucketUUID,
  Assgmt.RequestedDate,
  Assgmt.ProductAvailabilityDate,
  Assgmt.RequirementType,
  Assgmt.AssignedSupplyType,
  Assgmt.SupAssgmtSource,
  Assgmt.Material,
  Assgmt.Plant,
  Assgmt.BaseUnit
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ARUNALLASSIGNMENTS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More