I_GoodsInvoiceHistory

DDL: I_GOODSINVOICEHISTORY SQL: IGIHDATA Type: view COMPOSITE
24 Fields 2 Data Sources

Goods Invoice History Data

I_GoodsInvoiceHistory is a Composite CDS View that provides data about "Goods Invoice History Data" in SAP S/4HANA. It reads from 2 data sources (I_MpProcHistoryInvoiceStatus, I_PurchaseOrderHistory) and exposes 24 fields with key fields PurchaseOrder, PurchaseOrderItem, MaterialDocument, MaterialDocumentItem.

Data Sources (2)

SourceAliasJoin Type
I_MpProcHistoryInvoiceStatus HistoryStatus left_outer
I_PurchaseOrderHistory PurchaseOrderHistory from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IGIHDATA view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Goods Invoice History Data view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder I_PurchaseOrderHistory PurchaseOrder Purchasing Document
KEY PurchaseOrderItem
KEY MaterialDocument I_PurchaseOrderHistory MaterialDocument Material Doc.
KEY MaterialDocumentItem I_PurchaseOrderHistory MaterialDocumentItem Material Document Item
Material I_PurchaseOrderHistory Material Vehicle Model
GoodsMovementType I_PurchaseOrderHistory GoodsMovementType Movement Type
DebitCreditCode I_PurchaseOrderHistory DebitCreditCode Single-Character Flag
MaterialDocumentYear I_PurchaseOrderHistory MaterialDocumentYear Material Document Year
PurchaseOrderHistCategory I_PurchaseOrderHistory PurchaseOrderHistCategory PO History Cat.
PostingDate I_PurchaseOrderHistory PostingDate Posting Date for GR
Quantity I_PurchaseOrderHistory Quantity Value
DeliveryQuantityUnit
InvoiceListStatus I_MpProcHistoryInvoiceStatus InvoiceListStatus Inv. status
InvoiceListStatusDesc
InvoiceReferenceFiscalYear I_MpProcHistoryInvoiceStatus InvoiceReferenceFiscalYear Invoice Reference Fiscal Year
InvoiceAmtInCoCodeCrcy I_PurchaseOrderHistory InvoiceAmtInPurOrdTransacCrcy FC invoice amnt
PurOrdAmountInCompanyCodeCrcy I_PurchaseOrderHistory PurchaseOrderAmount Gross Amount
Currency I_PurchaseOrderHistory Currency Valuation Crcy
PurchaseOrderType
PurchasingOrganization
PurchasingGroup
Plant
_Currency _Currency
_UnitOfMeasure _UnitOfMeasure

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_GoodsInvoiceHistory.
-- 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: IGIHDATA

CREATE VIEW I_GoodsInvoiceHistory AS
SELECT
  PurchaseOrderHistory.PurchaseOrder AS PurchaseOrder,
  ltrim(PurchaseOrderHistory.PurchaseOrderItem,'0') AS PurchaseOrderItem,
  PurchaseOrderHistory.MaterialDocument AS MaterialDocument,
  PurchaseOrderHistory.MaterialDocumentItem AS MaterialDocumentItem,
  PurchaseOrderHistory.Material AS Material,
  PurchaseOrderHistory.GoodsMovementType AS GoodsMovementType,
  PurchaseOrderHistory.DebitCreditCode AS DebitCreditCode,
  PurchaseOrderHistory.MaterialDocumentYear AS MaterialDocumentYear,
  PurchaseOrderHistory.PurchaseOrderHistCategory AS PurchaseOrderHistCategory,
  PurchaseOrderHistory.PostingDate AS PostingDate,
  PurchaseOrderHistory.Quantity AS Quantity,
  PurchaseOrderHistory._PurchaseOrderItem.PurchaseOrderQuantityUnit AS DeliveryQuantityUnit,
  HistoryStatus.InvoiceListStatus AS InvoiceListStatus,
  _InvoiceListStatus._Text[1:Language = $session.system_language].InvoiceListStatusDesc AS InvoiceListStatusDesc,
  HistoryStatus.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  PurchaseOrderHistory.InvoiceAmtInPurOrdTransacCrcy AS InvoiceAmtInCoCodeCrcy,
  PurchaseOrderHistory.PurchaseOrderAmount AS PurOrdAmountInCompanyCodeCrcy,
  PurchaseOrderHistory.Currency AS Currency,
  PurchaseOrderHistory._PurchaseOrderItem._PurchaseOrder.PurchaseOrderType AS PurchaseOrderType,
  PurchaseOrderHistory._PurchaseOrderItem._PurchaseOrder.PurchasingOrganization AS PurchasingOrganization,
  PurchaseOrderHistory._PurchaseOrderItem._PurchaseOrder.PurchasingGroup AS PurchasingGroup,
  PurchaseOrderHistory._PurchaseOrderItem.Plant AS Plant
FROM I_PurchaseOrderHistory AS PurchaseOrderHistory
LEFT OUTER JOIN I_MpProcHistoryInvoiceStatus AS HistoryStatus ON /* join condition not captured in parsed metadata */
;

Learn More