P_ARUNSIMLNLOGBSC1
Basic View 1 for Supply Assignment Simulation Log
P_ARUNSIMLNLOGBSC1 is a CDS View in S/4HANA. Basic View 1 for Supply Assignment Simulation Log. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_ARunSimlnLog | view | inner | COMPOSITE | View for ARun Log at Date Level |
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM: {
viewType: #COMPOSITE
}
@VDM.private: true
@AccessControl: {
authorizationCheck: #NOT_REQUIRED,
personalData.blocking: #('TRANSACTIONAL_DATA')
}
@AbapCatalog: {
sqlViewName: 'PARUNSIMLNLGB1',
compiler.compareFilter: true
}
@ObjectModel: {
usageType: {
dataClass: #TRANSACTIONAL,
serviceQuality: #B,
sizeCategory: #XXL
}
}
// Total Confirmed Quantity
define view P_ARunSimlnLogBsc1
as select from I_ARunSimlnLog
{
ATPCheckUUID,
RequirementType,
RequirementDocumentNumber,
RequirementDocumentItem,
RequestedDate,
sum(ConfirmedRqmtQtyInBaseUnit) as ConfirmedRqmtQtyInBaseUnit
}
group by
ATPCheckUUID,
RequirementType,
RequirementDocumentNumber,
RequirementDocumentItem,
RequestedDate