I_FldLogsPurchasingDocItem

DDL: I_FLDLOGSPURCHASINGDOCITEM SQL: IFLPURDOC_ITM Type: view BASIC Package: ODATA_FLOG_PROCESS_RECEIPTS

Field Logistics Purchase Orders

I_FldLogsPurchasingDocItem is a Basic CDS View that provides data about "Field Logistics Purchase Orders" in SAP S/4HANA. It reads from 2 data sources (ekko, ekpo) and exposes 15 fields with key fields PurchasingDocument, PurchasingDocumentItem. Part of development package ODATA_FLOG_PROCESS_RECEIPTS.

2 data source(s) 15 fields

Data Sources (2)

SourceAliasJoin Type
ekko _header inner
ekpo _item from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IFLPURDOC_ITM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Field Logistics Purchase Orders view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument ekpo ebeln
KEY PurchasingDocumentItem ekpo ebelp
PurchaseRequisition ekpo banfn
PurchaseRequisitionItem ekpo bnfpo
Plant ekpo werks
PurchasingDocumentCategory ekpo bstyp
PurchasingDocumentItemCategory ekpo pstyp
OrderQuantity ekpo menge
OrderQuantityUnit ekpo meins
IsToBeAcceptedAtOrigin ekpo weora
IsEndOfPurposeBlocked ekko iseopblocked
PurchasingDocumentDeletionCode ekpo loekz
PurchasingDocumentType ekko bsart
PurchasingDocumentSubtype ekko bsakz
PurchasingProcessingStatus ekko procstat 
@AbapCatalog.sqlViewName: 'IFLPURDOC_ITM'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #BASIC
@ObjectModel.usageType: {serviceQuality: #C,
                         dataClass: #TRANSACTIONAL,
                         sizeCategory: #L}
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Field Logistics Purchase Orders'
define view I_FldLogsPurchasingDocItem
  as select from ekpo as _item
    inner join   ekko as _header on _header.ebeln = _item.ebeln
{

  key _item.ebeln          as PurchasingDocument,
  key _item.ebelp          as PurchasingDocumentItem,
      _item.banfn          as PurchaseRequisition,
      _item.bnfpo          as PurchaseRequisitionItem,
      _item.werks          as Plant,
      _item.bstyp          as PurchasingDocumentCategory,
      _item.pstyp          as PurchasingDocumentItemCategory,
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      @DefaultAggregation: #NONE
      _item.menge          as OrderQuantity,
      _item.meins          as OrderQuantityUnit,
      _item.weora          as IsToBeAcceptedAtOrigin,
      _header.iseopblocked as IsEndOfPurposeBlocked,
      _item.loekz as PurchasingDocumentDeletionCode,
      _header.bsart as PurchasingDocumentType,
      _header.bsakz as PurchasingDocumentSubtype,
      _header.procstat as PurchasingProcessingStatus
}

Learn More