P_ARunSimlnLogBsc1

DDL: P_ARUNSIMLNLOGBSC1 Type: view COMPOSITE

P_ARunSimlnLogBsc1 is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_ARunSimlnLog) and exposes 6 fields.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
I_ARunSimlnLog I_ARunSimlnLog from

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName PARUNSIMLNLGB1 view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view

Fields (6)

KeyFieldSource TableSource FieldDescription
ATPCheckUUID ATPCheckUUID
RequirementType RequirementType
RequirementDocumentNumber RequirementDocumentNumber
RequirementDocumentItem RequirementDocumentItem
RequestedDate RequestedDate
ConfirmedRqmtQtyInBaseUnit 
@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":""
}
}*/

Learn More