P_PURDOCITMFORRETURNDEL

CDS View

Purchasing Document Item for Return Del

P_PURDOCITMFORRETURNDEL is a CDS View in S/4HANA. Purchasing Document Item for Return Del. It contains 12 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 12 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_PurReturnDelItem view inner CONSUMPTION MM SSP Return Delivery Items

Fields (12)

KeyField CDS FieldsUsed in Views
KEY PurchasingDocumentItem PurchasingDocumentItem 1
BaseUnit BaseUnit 1
DocumentCurrency DocumentCurrency 1
Material Material 1
NetAmount NetAmount 1
NetPriceAmount NetPriceAmount 1
NetPriceQuantity NetPriceQuantity 1
OrderPriceUnit OrderPriceUnit 1
OrderQuantityUnit OrderQuantityUnit 1
PurchasingDocument PurchasingDocument 1
PurchasingDocumentDeletionCode PurchasingDocumentDeletionCode 1
PurchasingDocumentItemText PurchasingDocumentItemText 1 
@AbapCatalog.sqlViewName: 'PPOITMRETDEL'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true 
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #CONSUMPTION
@VDM.private : true
@EndUserText.label: 'Purchasing Document Item for Return Del'
define view P_PurDocItmforReturnDel as select from I_PurchasingDocumentItem as PurchOrdItem

association [1..1] to I_PurchasingDocument         as _PurchasingDocument        on  $projection.PurchasingDocument = _PurchasingDocument.PurchasingDocument

{
  key PurchOrdItem.PurchasingDocument,
  key PurchOrdItem.PurchasingDocumentItem,
      PurchOrdItem.PurchasingDocumentCategory,
      PurchOrdItem.PurchaseRequisition,
      PurchOrdItem.PurchaseRequisitionItem,
      PurchOrdItem.PurchasingDocumentDeletionCode,
      PurchOrdItem.PurchasingDocumentItemText,
      PurchOrdItem.Plant,
      PurchOrdItem.Material,
      PurchOrdItem.OrderQuantityUnit,
      PurchOrdItem.NetPriceQuantity,
      PurchOrdItem.BaseUnit,
      PurchOrdItem.OrderPriceUnit,
      PurchOrdItem.NetAmount,
      PurchOrdItem.NetPriceAmount,
      PurchOrdItem.DocumentCurrency,
      PurchOrdItem.IsEndOfPurposeBlocked,
      _PurchasingDocument
}
where PurchOrdItem.GoodsReceiptIsExpected  = 'X' 
and PurchOrdItem.PurchasingDocumentDeletionCode != 'L' 
and PurchOrdItem.IsEndOfPurposeBlocked   = '' or PurchOrdItem.IsEndOfPurposeBlocked is null
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASINGDOCUMENTITEM"
],
"ASSOCIATED":
[
"I_PURCHASINGDOCUMENT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More