I_FldLogsKitOutbDelivIndrctRef

DDL: I_FLDLOGSKITOUTBDELIVINDRCTREF Type: view_entity COMPOSITE

Kit Outbound Delivery with Indirect PO Ref

I_FldLogsKitOutbDelivIndrctRef is a Composite CDS View that provides data about "Kit Outbound Delivery with Indirect PO Ref" in SAP S/4HANA. It reads from 4 data sources (I_FldLogsDeliveryDocItem, I_FldLogsExtLinksStkTranspReqn, I_PurchasingDocumentItem, I_PurchasingDocumentItem) and exposes 6 fields with key fields PurchasingDocument, PurchasingDocumentItem.

4 data source(s) 6 fields

Data Sources (4)

SourceAliasJoin Type
I_FldLogsDeliveryDocItem _DeliveryDocumentItem inner
I_FldLogsExtLinksStkTranspReqn _Doclinks inner
I_PurchasingDocumentItem _stockreq inner
I_PurchasingDocumentItem PO from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Kit Outbound Delivery with Indirect PO Ref view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #COMPOSITE view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument I_PurchasingDocumentItem PurchasingDocument
KEY PurchasingDocumentItem I_PurchasingDocumentItem PurchasingDocumentItem
DeliveryDocument I_FldLogsDeliveryDocItem DeliveryDocument
DeliveryDocumentItem I_FldLogsDeliveryDocItem DeliveryDocumentItem
ActualDeliveryQuantity I_FldLogsDeliveryDocItem ActualDeliveryQuantity
DeliveryQuantityUnit I_FldLogsDeliveryDocItem DeliveryQuantityUnit 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Kit Outbound Delivery with Indirect PO Ref'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #L,
  dataClass: #TRANSACTIONAL
}
@VDM: {
lifecycle.contract.type: #SAP_INTERNAL_API,
viewType: #COMPOSITE
}
define view entity I_FldLogsKitOutbDelivIndrctRef
  as select from I_PurchasingDocumentItem       as PO
    inner join   I_FldLogsExtLinksStkTranspReqn as _Doclinks             on  _Doclinks.PurchaseRequisition     = PO.PurchaseRequisition
                                                                         and _Doclinks.PurchaseRequisitionItem = PO.PurchaseRequisitionItem
    inner join   I_PurchasingDocumentItem       as _stockreq             on  _stockreq.PurchaseRequisition     = _Doclinks.RefPurchaseRequisition
                                                                         and _stockreq.PurchaseRequisitionItem = _Doclinks.RefPurchaseRequisitionItem
    inner join   I_FldLogsDeliveryDocItem       as _DeliveryDocumentItem on  _DeliveryDocumentItem.ReferenceSDDocument    = _stockreq.PurchasingDocument
                                                                         and _DeliveryDocumentItem.PurchasingDocumentItem = _stockreq.PurchasingDocumentItem
{
  key PO.PurchasingDocument,
  key PO.PurchasingDocumentItem,
      _DeliveryDocumentItem.DeliveryDocument,
      _DeliveryDocumentItem.DeliveryDocumentItem,
      @Semantics.quantity.unitOfMeasure: 'DeliveryQuantityUnit'
      _DeliveryDocumentItem.ActualDeliveryQuantity,
      _DeliveryDocumentItem.DeliveryQuantityUnit
}
where
  _DeliveryDocumentItem.DeliveryDocument is not initial
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FLDLOGSDELIVERYDOCITEM",
"I_FLDLOGSEXTLINKSSTKTRANSPREQN",
"I_PURCHASINGDOCUMENTITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More