I_LatestGIRelatedMatDoc

DDL: I_LATESTGIRELATEDMATDOC SQL: ILTSTGIRLTDDOC Type: view BASIC Package: VDM_LE_SHP_OBD_COMMON
12 Fields 2 Data Sources

Latest Goods Issue Material Document

I_LatestGIRelatedMatDoc is a Basic CDS View that provides data about "Latest Goods Issue Material Document" in SAP S/4HANA. It reads from 2 data sources (I_DeliveryDocument, P_latestgirltdmatdoc) and exposes 12 fields with key fields PrecedingDocument, PrecedingDocumentCategory, SubsequentDocument, SubsequentDocumentCategory. Part of development package VDM_LE_SHP_OBD_COMMON.

Data Sources (2)

SourceAliasJoin Type
I_DeliveryDocument Delivery inner
P_latestgirltdmatdoc P_latestgirltdmatdoc from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ILTSTGIRLTDDOC view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Latest Goods Issue Material Document view
VDM.viewType #BASIC view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY PrecedingDocument Flow PrecedingDocument SD Document
KEY PrecedingDocumentCategory Flow PrecedingDocumentCategory
KEY SubsequentDocument Flow SubsequentDocument
KEY SubsequentDocumentCategory Flow SubsequentDocumentCategory
SubsequentDocumentItem Flow SubsequentDocumentItem
CreationDate Flow CreationDate Time Stamp
CreationTime Flow CreationTime Time of Change
MaterialDocument Flow SubsequentDocument
MaterialDocumentYear Flow MaterialDocumentYear Material Document Year
GoodsMovementType Flow GoodsMovementType Movement Type
ReceivingPlant I_DeliveryDocument ReceivingPlant Receiving Plant
_ReceivingPlant I_DeliveryDocument _ReceivingPlant

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_LatestGIRelatedMatDoc.
-- 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: ILTSTGIRLTDDOC

CREATE VIEW I_LatestGIRelatedMatDoc AS
SELECT
  Flow.PrecedingDocument AS PrecedingDocument,
  Flow.PrecedingDocumentCategory AS PrecedingDocumentCategory,
  Flow.SubsequentDocument AS SubsequentDocument,
  Flow.SubsequentDocumentCategory AS SubsequentDocumentCategory,
  Flow.SubsequentDocumentItem AS SubsequentDocumentItem,
  Flow.CreationDate AS CreationDate,
  Flow.CreationTime AS CreationTime,
  Flow.SubsequentDocument AS MaterialDocument,
  Flow.MaterialDocumentYear AS MaterialDocumentYear,
  Flow.GoodsMovementType AS GoodsMovementType,
  Delivery.ReceivingPlant AS ReceivingPlant,
  Delivery._ReceivingPlant AS _ReceivingPlant
FROM P_latestgirltdmatdoc
INNER JOIN I_DeliveryDocument AS Delivery ON /* join condition not captured in parsed metadata */
;

Learn More