OIA08

LIA Document: Item Data | #itemdata | Component: Exchanges
Column Name Description
MANDT FK Client
UPENUM FK Document number for logical inventory adjustment
MJAHR Material Document Year
SEGNUM Document item no. for logical inventory adjustment
ITEM_TYPE LIA item type Show values
Column Name Description
💲 Currency Key (WAERS):
PYMT Payment amount for LIA
LIA_DMBTR LIA quantity adjustment value in local currency
Column Name Description
📏 LIA transaction unit of measure (MEINS):
MENGE Quantity in transaction UOM
SKMENGE Quantity in stockkeeping UoM
Column Name Description
BLDAT Document Date in Document
BUDAT Posting Date in the Document
_DATAAGING Data Filter Value for Data Aging
Column Name Description
ITEM_TYPE LIA item type Show values
CVIND Customer / vendor posting indicator Show values
NEGADJ Negative adjustment indicator for LIA Show values
MATPST Posting rules for material Show values
Column Name Description Domain name
EXGNUM Exchange agreement number OIA_EXGNUM
ZTERM Terms of payment key ZTERM
SGTXT Item Text TEXT50
OID_EXTBOL External bill of lading OID_EXTBOL
Master Data Relations Join Conditions
Company Code
  • OIA08.MANDT == T001.MANDT
  • OIA08.BUKRS == T001.BUKRS
Purchasing Org for UPE Negotiated Payment
  • OIA08.MANDT == T024E.MANDT
  • OIA08.EKORG == T024E.EKORG
Exchange type
  • OIA08.MANDT == TOIA2.MANDT
  • OIA08.EXGTYP == TOIA2.EXGTYP
Fee accounting process key
  • ?
  • Client
  • Fee accounting process key
  • OIA08.[column in domain "OIA_APPIND"] == TOIAH.APPIND
  • OIA08.MANDT == TOIAH.MANDT
  • OIA08.KTOSL == TOIAH.KTOSL
Client OIA08.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • OIA08.MATNR == MARA.MATNR
  • OIA08.MANDT == MARA.MANDT
LIA transaction unit of measure
  • OIA08.MANDT == T006.MANDT
  • OIA08.MEINS == T006.MSEHI
Invoice cycle
  • OIA08.MANDT == TOIA10.MANDT
  • OIA08.OICYCLE == TOIA10.OIINVCYC
Stockkeeping unit of measure
  • OIA08.MANDT == T006.MANDT
  • OIA08.SKMEINS == T006.MSEHI
Sub Product number
  • Sub-product number
  • Client
  • OIA08.SUBPROD == MARA.MATNR
  • OIA08.MANDT == MARA.MANDT
Tax on sales/purchases code
  • ?
  • Tax on sales/purchases code
  • OIA08.MANDT == T007A.MANDT
  • OIA08.[column in domain "KALSM_D"] == T007A.KALSM
  • OIA08.TAXCD == T007A.MWSKZ
Sales Org for UPE Negotiated payment
  • OIA08.MANDT == TVKO.MANDT
  • OIA08.VKORG == TVKO.VKORG
Currency Key
  • OIA08.MANDT == TCURC.MANDT
  • OIA08.WAERS == TCURC.WAERS
Plant
  • OIA08.MANDT == T001W.MANDT
  • OIA08.WERKS == T001W.WERKS
Block Key for Payment
  • Block Key for Payment
  • Client
  • OIA08.ZLSPR == T008.ZAHLS
  • OIA08.MANDT == T008.MANDT