P_SlsDocSchedLineAnlyts

DDL: P_SLSDOCSCHEDLINEANLYTS SQL: PSDSLSDOCSCHLAYS Type: view COMPOSITE

P_SlsDocSchedLineAnlyts is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_SalesDocumentScheduleLine) and exposes 13 fields with key fields SalesDocument, SalesDocumentItem, ScheduleLine.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
I_SalesDocumentScheduleLine SDSL from

Annotations (8)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
VDM.private true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName PSDSLSDOCSCHLAYS view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY SalesDocument SalesDocument
_SalesDocument _SalesDocument
KEY SalesDocumentItem SalesDocumentItem
_SalesDocumentItem _SalesDocumentItem
KEY ScheduleLine ScheduleLine
SalesDocumentType _SalesDocument SalesDocumentType
CreationDate _SalesDocumentItem CreationDate
TransactionCurrency TransactionCurrency
_TransactionCurrency _TransactionCurrency
BaseUnit BaseUnit
OpenSlsOrdersForDelivNetAmount
OpenConfdDelivQtyInBaseUnit OpenConfdDelivQtyInBaseUnit
OpenReqdDelivQtyInBaseUnit OpenReqdDelivQtyInBaseUnit 
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #L
@VDM.private: true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.sqlViewName: 'PSDSLSDOCSCHLAYS'

define view P_SlsDocSchedLineAnlyts
as select from I_SalesDocumentScheduleLine as SDSL  

{
   // Key

   @ObjectModel.foreignKey.association: '_SalesDocument'
   key SalesDocument,
   _SalesDocument,
   key SalesDocumentItem,
   _SalesDocumentItem,
   key ScheduleLine,

   _SalesDocument.SalesDocumentType, 
  
   case when GoodsIssueDate = '00000000' 
     then DeliveryDate
     else GoodsIssueDate
   end as DeliveryDate,
   _SalesDocumentItem.CreationDate,
     
   @Semantics.currencyCode: true
   @ObjectModel.foreignKey.association: '_TransactionCurrency'
   TransactionCurrency,
   _TransactionCurrency,
   
   @Semantics.unitOfMeasure: true
   @ObjectModel.foreignKey.association: '_BaseUnit'
   BaseUnit,
   
   //Measures   

   @DefaultAggregation: #SUM
   @Semantics.amount.currencyCode: 'TransactionCurrency'
   cast( OpenDeliveryNetAmount as opn_ord_for_del_amt_itc )      as OpenSlsOrdersForDelivNetAmount,
  
   //Measures

//   @DefaultAggregation: #SUM

//   @Semantics.quantity.unitOfMeasure: 'BaseUnit'

//   cast( OpenConfdDelivQtyInBaseUnit as opn_ord_for_del_qty )    as OpnSlsOrdrsForDelivQuantity,

   
   @DefaultAggregation: #SUM
   @Semantics.quantity.unitOfMeasure: 'BaseUnit'
   OpenConfdDelivQtyInBaseUnit,
   
   @DefaultAggregation: #SUM
   @Semantics.quantity.unitOfMeasure: 'BaseUnit'
   OpenReqdDelivQtyInBaseUnit
   
} 
where _SalesDocument.SDDocumentCategory = 'C' and 
      _SalesDocumentItem.StatisticalValueControl = '' and  _SalesDocumentItem.SDDocumentRejectionStatus != 'C' and
      _SalesDocumentItem.IsReturnsItem = ''           and  _SalesDocumentItem.ItemIsBillingRelevant != '' and
    ( _SalesDocumentItem.ItemIsBillingRelevant = 'A' or _SalesDocumentItem.ItemIsBillingRelevant = 'H' or 
      _SalesDocumentItem.ItemIsBillingRelevant = 'J' or _SalesDocumentItem.ItemIsBillingRelevant = 'K' or 
      _SalesDocumentItem.ItemIsBillingRelevant = 'M' or _SalesDocumentItem.ItemIsBillingRelevant = 'O' or 
      _SalesDocumentItem.ItemIsBillingRelevant = 'P' or _SalesDocumentItem.ItemIsBillingRelevant = 'Q' or 
      _SalesDocumentItem.ItemIsBillingRelevant = 'R' or _SalesDocumentItem.ItemIsBillingRelevant = 'T' or 
      _SalesDocumentItem.ItemIsBillingRelevant = 'U' or _SalesDocumentItem.ItemIsBillingRelevant = 'V' or 
      _SalesDocumentItem.ItemIsBillingRelevant = 'W' ) and 
    ( _SalesDocumentItem.TotalDeliveryStatus = 'A'   or _SalesDocumentItem.TotalDeliveryStatus = 'B' ) and 
      OpenDeliveryNetAmount >= 0               

      
      
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SALESDOCUMENT",
"I_SALESDOCUMENTITEM",
"I_SALESDOCUMENTSCHEDULELINE"
],
"ASSOCIATED":
[
"I_CURRENCY",
"I_SALESDOCUMENT",
"I_SALESDOCUMENTITEM"
],
"BASE":
[
"I_SALESDOCUMENTSCHEDULELINE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More