FISVD_OPNIT_01

. | view: FISV_OPNIT_01 | Extraction: Not supported | Component: Information System
Tables used: BKPF, BSEG, KNA1, KNB1, LFA1, LFB1, SKB1, FITHA_PBUPL_D, FITHA_PBUPL_D_T, FITHA_PBUPL_K, FITHA_PBUPL_K_T
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
💲 Local Currency (h_hwaer):
dmbtr Amount in local currency
dmbtr_shl null
💲 Currency Key (h_waers):
wrbtr Amount in document currency
wrbtr_shl null
wskto Cash Discount Amount in Document Currency
💲 Currency Key of Second Local Currency (h_hwae2):
dmbe2 null
💲 Currency Key of Third Local Currency (h_hwae3):
dmbe3 null
💲 Currency for Automatic Payment (pycur):
pyamt Amount in Payment Currency
💲 Functional Currency (rfccur):
fcsl null
Column Name Description
Column Name Description
netdt Net Due Date
h_bldat Document Date in Document
h_budat Posting Date in the Document
zfbdt Baseline Date for Due Date Calculation
madat Date of Last Dunning Notice
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
kidno Payment Reference CHAR30
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
umsks Special G/L Transaction Type UMSKS
concat_bseg_key null
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
businesspartner_name1 Name 1 NAME
zbd1t Cash discount days 1 ZBDXT
zbd1p Cash discount percentage 1 PRZ23
zbd2t Cash discount days 2 ZBDXT
zbd2p Cash Discount Percentage 2 PRZ23
zbd3t Net Payment Terms Period ZBDXT
manst Dunning Level MAHNS
vbeln Billing Document VBELN
j_1tpbupl Branch Code BCODE
TH_BranchCodeDescription Branch Code Description FITH_DESC
busab null
togru null
adrnr null
h_bktxt Document Header Text TEXT25
h_xblnr Reference Document Number XBLNR1
h_belnr_sender Document Number of an Accounting Document in Sender System BELNR
h_logsystem_sender Logical System of the Sender LOGSYS
h_bukrs_sender Company Code in Sender System CHAR4
h_gjahr_sender Fiscal Year of an Accounting Document in the Sender System GJAHR
h_awtyp Reference procedure AWTYP
buzei_sender Item Number Within Accounting Document in Sender System BUZEI
filkd Account Number of the Branch MAXKK
xref1 Business Partner Reference Key CHAR12
xref2 Business Partner Reference Key CHAR12
xref3 Reference key for line item CHAR20
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • FISVD_OPNIT_01.BUKRS == T001.BUKRS
  • FISVD_OPNIT_01.MANDT == T001.MANDT
Equity group
  • Company Code
  • Client
  • Equity group
  • Joint venture
  • FISVD_OPNIT_01.BUKRS == T8JF.BUKRS
  • FISVD_OPNIT_01.MANDT == T8JF.MANDT
  • FISVD_OPNIT_01.EGRUP == T8JF.EGRUP
  • FISVD_OPNIT_01.VNAME == T8JF.VNAME
Business Area
  • Business Area
  • Client
  • FISVD_OPNIT_01.GSBER == TGSB.GSBER
  • FISVD_OPNIT_01.MANDT == TGSB.MANDT
Short Key for a House Bank
  • Client
  • Short Key for a House Bank
  • ?
  • FISVD_OPNIT_01.MANDT == T012.MANDT
  • FISVD_OPNIT_01.HBKID == T012.HBKID
  • FISVD_OPNIT_01.[column in domain "BUKRS"] == T012.BUKRS
General Ledger Account
  • Company Code
  • General Ledger Account
  • General Ledger Account
  • Client
  • FISVD_OPNIT_01.BUKRS == SKB1.BUKRS
  • FISVD_OPNIT_01.HKONT == SKB1.SAKNR
  • FISVD_OPNIT_01.KONKO == SKB1.SAKNR
  • FISVD_OPNIT_01.MANDT == SKB1.MANDT
ID for Account Details
  • Client
  • Short Key for a House Bank
  • ID for Account Details
  • ?
  • FISVD_OPNIT_01.MANDT == T012K.MANDT
  • FISVD_OPNIT_01.HBKID == T012K.HBKID
  • FISVD_OPNIT_01.HKTID == T012K.HKTID
  • FISVD_OPNIT_01.[column in domain "BUKRS"] == T012K.BUKRS
Document Type
  • Client
  • Document Type
  • FISVD_OPNIT_01.MANDT == T003.MANDT
  • FISVD_OPNIT_01.H_BLART == T003.BLART
Currency Key
  • Client
  • Currency Key
  • FISVD_OPNIT_01.MANDT == TCURC.MANDT
  • FISVD_OPNIT_01.H_WAERS == TCURC.WAERS
Credit control area
  • Client
  • Credit control area
  • FISVD_OPNIT_01.MANDT == T014.MANDT
  • FISVD_OPNIT_01.KKBER == T014.KKBER
Account Number of an Alternative Payer
  • Client
  • Account Number of an Alternative Payer
  • FISVD_OPNIT_01.MANDT == KNA1.MANDT
  • FISVD_OPNIT_01.KNA1_KNRZA == KNA1.KUNNR
Account number of an alternative payer
  • Account number of an alternative payer
  • Client
  • FISVD_OPNIT_01.KNB1_KNRZB == KNA1.KUNNR
  • FISVD_OPNIT_01.MANDT == KNA1.MANDT
General Ledger Account
  • Company Code
  • General Ledger Account
  • General Ledger Account
  • Client
  • FISVD_OPNIT_01.BUKRS == SKB1.BUKRS
  • FISVD_OPNIT_01.HKONT == SKB1.SAKNR
  • FISVD_OPNIT_01.KONKO == SKB1.SAKNR
  • FISVD_OPNIT_01.MANDT == SKB1.MANDT
Customer Number
  • Client
  • Customer Number
  • FISVD_OPNIT_01.MANDT == KNA1.MANDT
  • FISVD_OPNIT_01.KUNNR == KNA1.KUNNR
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • FISVD_OPNIT_01.LIFNR == LFA1.LIFNR
  • FISVD_OPNIT_01.MANDT == LFA1.MANDT
Dunning Area
  • Company Code
  • Client
  • Dunning Area
  • FISVD_OPNIT_01.BUKRS == T047M.BUKRS
  • FISVD_OPNIT_01.MANDT == T047M.MANDT
  • FISVD_OPNIT_01.MABER == T047M.MABER
Dunning Block
  • Client
  • Dunning Block
  • FISVD_OPNIT_01.MANDT == T040S.MANDT
  • FISVD_OPNIT_01.MANSP == T040S.MANSP
Dunning Key
  • Client
  • Dunning Key
  • FISVD_OPNIT_01.MANDT == T040.MANDT
  • FISVD_OPNIT_01.MSCHL == T040.MSCHL
Update Currency for General Ledger Transaction Figures
  • Client
  • Update Currency for General Ledger Transaction Figures
  • FISVD_OPNIT_01.MANDT == TCURC.MANDT
  • FISVD_OPNIT_01.PSWSL == TCURC.WAERS
Currency for Automatic Payment
  • Client
  • Currency for Automatic Payment
  • FISVD_OPNIT_01.MANDT == TCURC.MANDT
  • FISVD_OPNIT_01.PYCUR == TCURC.WAERS
Recovery Indicator
  • Company Code
  • Client
  • Recovery Indicator
  • FISVD_OPNIT_01.BUKRS == T8JJ.BUKRS
  • FISVD_OPNIT_01.MANDT == T8JJ.MANDT
  • FISVD_OPNIT_01.RECID == T8JJ.RECID
Special G/L Indicator
  • Client
  • Special G/L Indicator
  • ?
  • FISVD_OPNIT_01.MANDT == T074U.MANDT
  • FISVD_OPNIT_01.UMSKZ == T074U.UMSKZ
  • FISVD_OPNIT_01.[column in domain "KOART"] == T074U.KOART
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • FISVD_OPNIT_01.MANDT == T880.MANDT
  • FISVD_OPNIT_01.VBUND == T880.RCOMP
Joint venture
  • Company Code
  • Client
  • Joint venture
  • FISVD_OPNIT_01.BUKRS == T8JV.BUKRS
  • FISVD_OPNIT_01.MANDT == T8JV.MANDT
  • FISVD_OPNIT_01.VNAME == T8JV.VNAME
Payment Method
  • Client
  • ?
  • Payment Method
  • FISVD_OPNIT_01.MANDT == T042Z.MANDT
  • FISVD_OPNIT_01.[column in domain "LAND1"] == T042Z.LAND1
  • FISVD_OPNIT_01.ZLSCH == T042Z.ZLSCH
Payment Block Key
  • Client
  • Payment Block Key
  • FISVD_OPNIT_01.MANDT == T008.MANDT
  • FISVD_OPNIT_01.ZLSPR == T008.ZAHLS