I_GoodsInvoiceHistory

Goods Invoice History Data | view: IGIHDATA | Extraction: Not supported | Component: Commercial Project Management - Project Workspace
Tables used: EKKOEKPORBKPRBKPBRBDRSEGRSEGEKBEEKBEHT163BTVBST
Column Name Description
PurchaseOrder FK Purchase Order Number
PurchaseOrderItem null
MaterialDocument Number of Material Document
MaterialDocumentItem Item in Material Document
Column Name Description
💲 Currency Key (Currency):
InvoiceAmtInCoCodeCrcy Invoice Amount in PO Currency
PurOrdAmountInCompanyCodeCrcy Amount in Document Currency
Column Name Description
📏 Purchase Order Unit of Measure (DeliveryQuantityUnit):
Quantity Quantity
Column Name Description
PostingDate Posting Date in the Document
Column Name Description
DebitCreditCode Debit/Credit Indicator Show values
InvoiceListStatus Invoice document status Show values
Column Name Description Domain name
MaterialDocumentYear Material Document Year GJAHR
InvoiceListStatusDesc Status Description TEXT20
InvoiceReferenceFiscalYear Fiscal Year GJAHR
Master Data Relations Join Conditions
Currency Key
  • Client
  • Currency Key
  • I_GOODSINVOICEHISTORY.MANDT == TCURC.MANDT
  • I_GOODSINVOICEHISTORY.CURRENCY == TCURC.WAERS
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • I_GOODSINVOICEHISTORY.MANDT == T006.MANDT
  • I_GOODSINVOICEHISTORY.DELIVERYQUANTITYUNIT == T006.MSEHI
Movement type (inventory management)
  • Client
  • Movement type (inventory management)
  • I_GOODSINVOICEHISTORY.MANDT == T156.MANDT
  • I_GOODSINVOICEHISTORY.GOODSMOVEMENTTYPE == T156.BWART
Material Number
  • Client
  • Material Number
  • I_GOODSINVOICEHISTORY.MANDT == MARA.MANDT
  • I_GOODSINVOICEHISTORY.MATERIAL == MARA.MATNR
Plant
  • Client
  • Plant
  • I_GOODSINVOICEHISTORY.MANDT == T001W.MANDT
  • I_GOODSINVOICEHISTORY.PLANT == T001W.WERKS
Purchase Order History Category
  • Client
  • Purchase Order History Category
  • I_GOODSINVOICEHISTORY.MANDT == T163B.MANDT
  • I_GOODSINVOICEHISTORY.PURCHASEORDERHISTCATEGORY == T163B.BEWTP
Purchase Order Type
  • Client
  • ?
  • Purchase Order Type
  • I_GOODSINVOICEHISTORY.MANDT == T161.MANDT
  • I_GOODSINVOICEHISTORY.[column in domain "BSTYP"] == T161.BSTYP
  • I_GOODSINVOICEHISTORY.PURCHASEORDERTYPE == T161.BSART
Purchasing Group
  • Purchasing Group
  • Client
  • I_GOODSINVOICEHISTORY.PURCHASINGGROUP == T024.EKGRP
  • I_GOODSINVOICEHISTORY.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • I_GOODSINVOICEHISTORY.PURCHASINGORGANIZATION == T024E.EKORG
  • I_GOODSINVOICEHISTORY.MANDT == T024E.MANDT