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.

1 data source(s) 5 fields

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

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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FLDLOGSDELIVERYDOCITEM",
"I_FLDLOGSRBLSUPPLIERITEM",
"I_PURCHASINGDOCUMENTITEM"
],
"ASSOCIATED":
[
"E_DELIVERYDOCUMENTITEM",
"E_FLDLOGSSUPPLIERITEM",
"E_PURCHASINGDOCUMENTITEM"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More