P_PurDocItem

DDL: P_PURDOCITEM SQL: PPURDOCITM Type: view CONSUMPTION

View for Purchasing Document Item

P_PurDocItem is a Consumption CDS View that provides data about "View for Purchasing Document Item" in SAP S/4HANA. It reads from 1 data source (R_PurchasingDocumentItem) and exposes 42 fields with key fields PurchasingDocument, PurchasingDocumentItem.

1 data source(s) 42 fields

Data Sources (1)

SourceAliasJoin Type
R_PurchasingDocumentItem _PurgDocItm from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PPURDOCITM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label View for Purchasing Document Item view
VDM.viewType #CONSUMPTION view
VDM.private true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (42)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument R_PurchasingDocumentItem PurchasingDocument
KEY PurchasingDocumentItem R_PurchasingDocumentItem PurchasingDocumentItem
PurchasingDocumentItemText PurchasingDocumentItemText
Assembly
Material Material
_Material _Material
Plant Plant
MaterialGroup MaterialGroup
AccountAssignmentCategory AccountAssignmentCategory
CompanyCode CompanyCode
StorageLocation StorageLocation
RequirementTracking RequirementTracking
PurchasingDocumentCategory PurchasingDocumentCategory
_PurgDocumentCategory _PurgDocumentCategory
TargetQuantity TargetQuantity
NetAmount NetAmount
NetPriceAmount NetPriceAmount
NetPriceQuantity NetPriceQuantity
IsReturnsItem IsReturnsItem
ProductTypeCode ProductTypeCode
ProductType ProductType
OrderQuantity OrderQuantity
CurrentDate
OrderQuantityUnit R_PurchasingDocumentItem OrderQuantityUnit
DocumentCurrency R_PurchasingDocumentItem DocumentCurrency
SupplierIsSubcontractor SupplierIsSubcontractor
MRPArea MRPArea
StockSegment StockSegment
ProductSeasonYear ProductSeasonYear
ProductSeason ProductSeason
ProductCollection ProductCollection
ProductTheme ProductTheme
CrossPlantConfigurableProduct CrossPlantConfigurableProduct
ProductCharacteristic1 ProductCharacteristic1
ProductCharacteristic2 ProductCharacteristic2
ProductCharacteristic3 ProductCharacteristic3
PurchasingDocumentItemCategory PurchasingDocumentItemCategory
GoodsReceiptIsExpected GoodsReceiptIsExpected
IsCompletelyDelivered IsCompletelyDelivered
PurchasingDocumentDeletionCode PurchasingDocumentDeletionCode
IsEndOfPurposeBlocked IsEndOfPurposeBlocked
_PurchasingDocument _PurchasingDocument 
@AbapCatalog.sqlViewName: 'PPURDOCITM'
@AbapCatalog.compiler.compareFilter: true
//@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'View for Purchasing Document Item'
@VDM.viewType: #CONSUMPTION
@VDM.private: true
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE

define view P_PurDocItem
  as select from R_PurchasingDocumentItem as _PurgDocItm
{
  key  _PurgDocItm.PurchasingDocument     as PurchasingDocument,
  key  _PurgDocItm.PurchasingDocumentItem as PurchasingDocumentItem,

       PurchasingDocumentItemText,

       cast(Material as bagrp)            as Assembly,
       Material,
       _Material,

       Plant,
       //_Plant,


       MaterialGroup,
      // _MaterialGroup,


       AccountAssignmentCategory,

       CompanyCode,
       //_CompanyCode,


       StorageLocation,
       //_StorageLocation,


       RequirementTracking,

       // Document Type

       PurchasingDocumentCategory,
       _PurgDocumentCategory,
       TargetQuantity,

       NetAmount,
       NetPriceAmount,
       NetPriceQuantity,

       IsReturnsItem,
       ProductTypeCode,
       ProductType,
       OrderQuantity,

       $session.system_date               as CurrentDate,
       //       @Semantics.unitOfMeasure:true

       _PurgDocItm.OrderQuantityUnit      as OrderQuantityUnit,

       @Semantics.currencyCode: true
       _PurgDocItm.DocumentCurrency       as DocumentCurrency,

       SupplierIsSubcontractor,

       MRPArea,

       StockSegment,
       ProductSeasonYear,
       ProductSeason,
       ProductCollection,
       ProductTheme,
       CrossPlantConfigurableProduct,
       ProductCharacteristic1,
       ProductCharacteristic2,
       ProductCharacteristic3,
       PurchasingDocumentItemCategory,

       GoodsReceiptIsExpected,

       IsCompletelyDelivered,

       PurchasingDocumentDeletionCode,

       IsEndOfPurposeBlocked,
       _PurchasingDocument

}
where
  (
            PurchasingDocumentItemCategory                     =  '3'
    and     PurchasingDocumentDeletionCode                     <> 'L'
    and     _PurchasingDocument.PurchasingDocumentDeletionCode <> 'L'
    and     IsEndOfPurposeBlocked                              =  ''
    and(
      (
            IsCompletelyDelivered                              =  ' '
        and PurchasingDocumentCategory                         =  'F'
      )
      or(
            PurchasingDocumentCategory                         =  'L'
      )
    )
  )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_PURCHASINGDOCUMENT",
"R_PURCHASINGDOCUMENTITEM"
],
"ASSOCIATED":
[
"I_MATERIAL",
"I_PURCHASINGDOCUMENTCATEGORY",
"R_PURCHASINGDOCUMENT"
],
"BASE":
[
"R_PURCHASINGDOCUMENTITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More