P_SlsDocFlfmtSlsDocItem1

DDL: P_SLSDOCFLFMTSLSDOCITEM1 SQL: PSOFSLSDOCITEM1 Type: view CONSUMPTION

P_SlsDocFlfmtSlsDocItem1 is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_SalesDocumentScheduleLine) and exposes 5 fields with key fields SalesDocument, SalesDocumentItem. It has 1 association to related views.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
I_SalesDocumentScheduleLine I_SalesDocumentScheduleLine from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_UnitOfMeasure _UnitOfMeasure $projection.OrderQuantityUnit = _UnitOfMeasure.UnitOfMeasure

Annotations (10)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #S view
VDM.private true view
VDM.viewType #CONSUMPTION view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName PSOFSLSDOCITEM1 view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY SalesDocument SalesDocument
KEY SalesDocumentItem SalesDocumentItem
DeliveredQtyInOrderQtyUnit
OrderQuantityUnit OrderQuantityUnit
_UnitOfMeasure _UnitOfMeasure 
@ClientHandling.algorithm: #SESSION_VARIABLE 
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #S
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'PSOFSLSDOCITEM1'

define view P_SlsDocFlfmtSlsDocItem1 
 as select from I_SalesDocumentScheduleLine
 
 association [0..1] to I_UnitOfMeasure                as _UnitOfMeasure             on  $projection.OrderQuantityUnit = _UnitOfMeasure.UnitOfMeasure
 
{   
  key SalesDocument,
  key SalesDocumentItem,
  
  @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit' 
  cast( sum(DeliveredQtyInOrderQtyUnit) as dlvqty) as DeliveredQtyInOrderQtyUnit,
  OrderQuantityUnit,
  
  _UnitOfMeasure
}

group by
    SalesDocument,
    SalesDocumentItem,
    OrderQuantityUnit
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SALESDOCUMENTSCHEDULELINE"
],
"ASSOCIATED":
[
"I_UNITOFMEASURE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More