C_FldLogsProcRcptCstmFldExtn

DDL: C_FLDLOGSPROCRCPTCSTMFLDEXTN SQL: CFLDLOGSEXTEN Type: view CONSUMPTION

Consumption For Extensibility

C_FldLogsProcRcptCstmFldExtn is a Consumption CDS View that provides data about "Consumption For Extensibility" in SAP S/4HANA. It reads from 1 data source (I_PurchasingDocumentItem) and exposes 5 fields with key fields PurchasingDocument, PurchasingDocumentItem, DeliveryDocument, DeliveryDocumentItem. It has 3 associations to related views. It is exposed through 1 OData service (UI_PROCESS_RECEIPTS). It is used in 1 Fiori application: Process Receipt.

Data Sources (1)

SourceAliasJoin Type
I_PurchasingDocumentItem _PurdocItem from

Associations (3)

CardinalityTargetAliasCondition
[0..1] E_PurchasingDocumentItem _PurDocItemExtension $projection.PurchasingDocument = _PurDocItemExtension.PurchasingDocument and $projection.PurchasingDocumentItem = _PurDocItemExtension.PurchasingDocumentItem
[0..1] E_DeliveryDocumentItem _DlvDocItemExtension _DeliveryItem.DeliveryDocument = _DlvDocItemExtension.DeliveryDocument and _DeliveryItem.DeliveryDocumentItem = _DlvDocItemExtension.DeliveryDocumentItem
[0..1] E_FldLogsSupplierItem _SuplritemExtension _SupItem.FldLogsSuplrItemUUID = _SuplritemExtension.FldLogsSuplrItemUUID

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CFLDLOGSEXTEN view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Consumption For Extensibility view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view

OData Services (1)

ServiceBindingVersionContractRelease
UI_PROCESS_RECEIPTS UI_PROCESS_RECEIPTS V2 C1 NOT_TO_BE_RELEASED_STABLE

Fiori Apps (1)

App IDApp NameTypeDescription
F5316 Process Receipt Transactional This application is used to Receive Purchase Order Items and Inbound delivery items at Base Plant and Remote Plant. The items can consist of both Stock and Supplier Items.

Process Receipt

Business Role: Receiving Specialist (Oil & Gas)

This feature enables you to: Create batches with supplier batches using the Create Batch action. View additional fields such as Order Category, Order Number, Recipient, Requisitioner, and Unloading Point details on the list page. Perform a two-step Goods Receipt (GR) process with an alternate unit of measurement. Create a Putaway Warehouse Task for non-stock and supplier items in a single-plant scenario.

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument I_PurchasingDocumentItem PurchasingDocument
KEY PurchasingDocumentItem I_PurchasingDocumentItem PurchasingDocumentItem
KEY DeliveryDocument
KEY DeliveryDocumentItem
LongTextIDText Information
@AbapCatalog.sqlViewName: 'CFLDLOGSEXTEN'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #CONSUMPTION
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Consumption For Extensibility'
@ObjectModel.usageType: {serviceQuality: #C,
                         dataClass: #TRANSACTIONAL,
                         sizeCategory: #L}
define view C_FldLogsProcRcptCstmFldExtn
  as select from           I_PurchasingDocumentItem as _PurdocItem

    left outer to one join I_FldLogsDeliveryDocItem as _DeliveryItem on  _PurdocItem.PurchasingDocument     = _DeliveryItem.ReferenceSDDocument
                                                                     and _PurdocItem.PurchasingDocumentItem = _DeliveryItem.PurchasingDocumentItem


    left outer to one join I_FldLogsRblSupplierItem as _SupItem      on  _PurdocItem.PurchasingDocument     = _SupItem.PurchasingDocument
                                                                     and _PurdocItem.PurchasingDocumentItem = _SupItem.PurchasingDocumentItem

  association [0..1] to E_PurchasingDocumentItem as _PurDocItemExtension on  $projection.PurchasingDocument     = _PurDocItemExtension.PurchasingDocument
                                                                         and $projection.PurchasingDocumentItem = _PurDocItemExtension.PurchasingDocumentItem

  association [0..1] to E_DeliveryDocumentItem   as _DlvDocItemExtension on  _DeliveryItem.DeliveryDocument     = _DlvDocItemExtension.DeliveryDocument
                                                                         and _DeliveryItem.DeliveryDocumentItem = _DlvDocItemExtension.DeliveryDocumentItem

  association [0..1] to E_FldLogsSupplierItem    as _SuplritemExtension  on  _SupItem.FldLogsSuplrItemUUID = _SuplritemExtension.FldLogsSuplrItemUUID

{
  key _PurdocItem.PurchasingDocument                           as PurchasingDocument,
      @Consumption.filter.hidden: true
  key _PurdocItem.PurchasingDocumentItem                       as PurchasingDocumentItem,
      @Consumption.filter.hidden: true
  key coalesce(ltrim(_DeliveryItem.DeliveryDocument, '0'), '') as DeliveryDocument,
      @Consumption.filter.hidden: true
  key coalesce(_DeliveryItem.DeliveryDocumentItem, '000000')   as DeliveryDocumentItem,
      @Consumption.filter.hidden: true
      case
      when _SupItem.FldLogsSuplrItemUUID is null
      then hextobin( '00000000000000000000000000000000' )
      else _SupItem.FldLogsSuplrItemUUID
      end                                                      as FldLogsSuplrItemUUID,
      @UI.fieldGroup: [{
             qualifier: 'Exten',
             position: 10
      //           hidden: true

           }]
      @EndUserText.label: 'Information'
      //@UI.hidden: true

      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'CL_FLOG_PROCRCPT_DLVSTATUS_TXT'
      cast( 'AA' as char200)                                   as LongTextIDText
}