FISVD_OPNITM_01

Open Items of Manual Clearing | view: FISV_OPNITM_01 | Extraction: Not supported | Component: Information System
Tables used: BSEGKNA1KNB1LFA1LFB1SKB1
Column Name Description
bukrs FK Company Code
gjahr Fiscal Year
belnr Document Number of an Accounting Document
buzei Number of Line Item Within Accounting Document
Column Name Description
💲 Currency Key (h_waers):
dmbtr Amount in local currency
dmbtr_shl null
wrbtr Amount in document currency
wrbtr_shl null
Column Name Description
Column Name Description
netdt Net Due Date
h_bldat Document Date in Document
h_budat Posting Date in the Document
Column Name Description
koart Account type Show values
shkzg Debit/Credit Indicator Show values
xzahl Indicator: Is Posting Key Used in a Payment Transaction? Show values
Column Name Description Domain name
zuonr Assignment number ZUONR
sgtxt Item Text TEXT50
rebzg Document No. of the Invoice to Which the Transaction Belongs BELNR
rebzj Fiscal Year of the Relevant Invoice (for Credit Memo) GJAHR
rebzz Line Item in the Relevant Invoice BUZEI
rebzt Follow-On Document Type REBZT
kna1_begru Authorization Group BRGRU
knb1_begru Authorization Group BRGRU
lfa1_begru Authorization Group BRGRU
lfb1_begru Authorization Group BRGRU
skb1_begru Authorization Group BRGRU
adrnr null
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • FISVD_OPNITM_01.BUKRS == T001.BUKRS
  • FISVD_OPNITM_01.MANDT == T001.MANDT
General Ledger Account
  • Company Code
  • Client
  • General Ledger Account
  • General Ledger Account
  • FISVD_OPNITM_01.BUKRS == SKB1.BUKRS
  • FISVD_OPNITM_01.MANDT == SKB1.MANDT
  • FISVD_OPNITM_01.KONKO == SKB1.SAKNR
  • FISVD_OPNITM_01.HKONT == SKB1.SAKNR
Document Type
  • Document Type
  • Client
  • FISVD_OPNITM_01.H_BLART == T003.BLART
  • FISVD_OPNITM_01.MANDT == T003.MANDT
Currency Key
  • Client
  • Currency Key
  • FISVD_OPNITM_01.MANDT == TCURC.MANDT
  • FISVD_OPNITM_01.H_WAERS == TCURC.WAERS
General Ledger Account
  • Company Code
  • Client
  • General Ledger Account
  • General Ledger Account
  • FISVD_OPNITM_01.BUKRS == SKB1.BUKRS
  • FISVD_OPNITM_01.MANDT == SKB1.MANDT
  • FISVD_OPNITM_01.KONKO == SKB1.SAKNR
  • FISVD_OPNITM_01.HKONT == SKB1.SAKNR
Customer Number
  • Customer Number
  • Client
  • FISVD_OPNITM_01.KUNNR == KNA1.KUNNR
  • FISVD_OPNITM_01.MANDT == KNA1.MANDT
Account Number of Supplier
  • Client
  • Account Number of Supplier
  • FISVD_OPNITM_01.MANDT == LFA1.MANDT
  • FISVD_OPNITM_01.LIFNR == LFA1.LIFNR
Update Currency for General Ledger Transaction Figures
  • Update Currency for General Ledger Transaction Figures
  • Client
  • FISVD_OPNITM_01.PSWSL == TCURC.WAERS
  • FISVD_OPNITM_01.MANDT == TCURC.MANDT