I_FldLogsDeliverySerialItmDets

DDL: I_FLDLOGSDELIVERYSERIALITMDETS SQL: IFLGSEROBD Type: view COMPOSITE
10 Fields 1 Data Sources 1 Associations

Serial numbers Batch for OBD

I_FldLogsDeliverySerialItmDets is a Composite CDS View that provides data about "Serial numbers Batch for OBD" in SAP S/4HANA. It reads from 1 data source (I_OutboundDeliveryItem) and exposes 10 fields with key fields DeliveryDocument, DeliveryDocumentItem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_OutboundDeliveryItem I_OutboundDeliveryItem from

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_FldLogsSerialNmbrDeliveryDoc _DeliverySerialItems $projection.DeliveryDocument = _DeliverySerialItems.DeliveryDocument and $projection.DeliveryDocumentItem = _DeliverySerialItems.DeliveryDocumentItem

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IFLGSEROBD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Serial numbers Batch for OBD view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
VDM.viewType #COMPOSITE view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY DeliveryDocument OutboundDelivery LE Delivery
KEY DeliveryDocumentItem OutboundDeliveryItem Logistics Execution Delivery Item
Batch Batch Lot No.
ValuationType InventoryValuationType Valuation Type
DeliveryDocumentItemText DeliveryDocumentItemText
ActualDeliveryQuantity ActualDeliveryQuantity Base quantity
DeliveryQuantityUnit DeliveryQuantityUnit Unit of measure
StorageLocation StorageLocation StorageLocation
Material Material Vehicle Model
_DeliverySerialItems _DeliverySerialItems

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_FldLogsDeliverySerialItmDets.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IFLGSEROBD

CREATE VIEW I_FldLogsDeliverySerialItmDets AS
SELECT
  OutboundDelivery AS DeliveryDocument,
  OutboundDeliveryItem AS DeliveryDocumentItem,
  Batch,
  InventoryValuationType AS ValuationType,
  DeliveryDocumentItemText,
  ActualDeliveryQuantity,
  DeliveryQuantityUnit,
  StorageLocation,
  Material
FROM I_OutboundDeliveryItem
LEFT OUTER JOIN I_FldLogsSerialNmbrDeliveryDoc AS _DeliverySerialItems ON DeliveryDocument = _DeliverySerialItems.DeliveryDocument AND DeliveryDocumentItem = _DeliverySerialItems.DeliveryDocumentItem  -- association [1..*]
;

Learn More