P_RefundingQuantity

DDL: P_REFUNDINGQUANTITY SQL: PRFNDNGQTY Type: view CONSUMPTION

P_RefundingQuantity is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (I_SalesDocumentItemBasic, I_SalesDocumentBasic) and exposes 2 fields with key fields CustomerReturn, CustomerReturnItem. It has 1 association to related views.

2 data source(s) 2 fields

Data Sources (2)

SourceAliasJoin Type
I_SalesDocumentItemBasic CustomerReturnItem from
I_SalesDocumentBasic SalesDocumentBasic inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] P_RefundedQuantitySum _Refundedquantitysum $projection.CustomerReturn = _Refundedquantitysum.CustomerReturn and $projection.CustomerReturnItem = _Refundedquantitysum.CustomerReturnItem

Annotations (9)

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

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY CustomerReturn I_SalesDocumentItemBasic SalesDocument
KEY CustomerReturnItem I_SalesDocumentItemBasic SalesDocumentItem 
@AbapCatalog.sqlViewName: 'PRFNDNGQTY'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #CONSUMPTION
@VDM.private: true
@ClientHandling.algorithm:#SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
define view P_RefundingQuantity as select from I_SalesDocumentItemBasic as CustomerReturnItem
inner join  I_SalesDocumentBasic as SalesDocumentBasic on SalesDocumentBasic.SalesDocument = CustomerReturnItem.SalesDocument
 association [0..1] to P_RefundedQuantitySum as _Refundedquantitysum on $projection.CustomerReturn = _Refundedquantitysum.CustomerReturn and
 $projection.CustomerReturnItem = _Refundedquantitysum.CustomerReturnItem
 {
key CustomerReturnItem.SalesDocument as CustomerReturn,
key CustomerReturnItem.SalesDocumentItem as CustomerReturnItem,

  case when _Refundedquantitysum.RefundedQuantityInBaseUnit is null
     then
     (DIVISION (RequestedQuantityInBaseUnit * OrderToBaseQuantityDnmntr, OrderToBaseQuantityNmrtr, 3))
     else      
       (DIVISION (RequestedQuantityInBaseUnit * OrderToBaseQuantityDnmntr, OrderToBaseQuantityNmrtr, 3)) - (DIVISION (_Refundedquantitysum.RefundedQuantityInBaseUnit * OrderToBaseQuantityDnmntr, OrderToBaseQuantityNmrtr, 3))
     end                                                                                                                                 as CustReturnItmOpenRefundQty
         
} where SalesDocumentBasic.SDDocumentCategory ='H'                                      
  
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SALESDOCUMENTBASIC",
"I_SALESDOCUMENTITEMBASIC",
"P_REFUNDEDQUANTITYSUM"
],
"ASSOCIATED":
[
"P_REFUNDEDQUANTITYSUM"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More