P_ARUNSIMLNLOGBSC1
P_ARUNSIMLNLOGBSC1 is a CDS View in S/4HANA. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_ARunSimlnLog | view | inner | COMPOSITE |
@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
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ARUNSIMLNLOG"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/