FACVD_CLROI_02

Open items of manual clearing (Lock handling) | view: FACV_CLROI_02 | Extraction: Not supported | Component: Fiori UI for General Ledger Accounting
Tables used: BSEC, REGUP, REGUS, BKPF, BSEG, T001, T042, 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 of Second Local Currency (h_hwae2):
dmbe2 null
💲 Currency Key of Third Local Currency (h_hwae3):
dmbe3 null
💲 Currency Key (h_waers):
wrbtr Amount in document currency
wrbtr_shl null
💲 Currency for Automatic Payment (pycur):
pyamt Amount in Payment Currency
💲 Functional Currency (rfccur):
fcsl null
Column Name Description
Column Name Description
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
netdt Net Due Date
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
kna1_begru Authorization Group BRGRU
knb1_begru Authorization Group BRGRU
lfa1_begru Authorization Group BRGRU
lfb1_begru Authorization Group BRGRU
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
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
skb1_begru Authorization Group BRGRU
zuonr Assignment number ZUONR
kidno Payment Reference CHAR30
adrnr null
concat_bseg_key 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
umsks Special G/L Transaction Type UMSKS
vbeln Billing Document VBELN
j_1tpbupl Branch Code BCODE
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
butxt Name of Company Code or Company TEXT25
name1 Name 1 NAME
processing_status null
cpd_accountname Name 1 NAME
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • FACVD_CLROI_02.BUKRS == T001.BUKRS
  • FACVD_CLROI_02.MANDT == T001.MANDT
Equity group
  • Company Code
  • Equity group
  • Client
  • Joint venture
  • FACVD_CLROI_02.BUKRS == T8JF.BUKRS
  • FACVD_CLROI_02.EGRUP == T8JF.EGRUP
  • FACVD_CLROI_02.MANDT == T8JF.MANDT
  • FACVD_CLROI_02.VNAME == T8JF.VNAME
Business Area
  • Client
  • Business Area
  • FACVD_CLROI_02.MANDT == TGSB.MANDT
  • FACVD_CLROI_02.GSBER == TGSB.GSBER
Short Key for a House Bank
  • ?
  • Client
  • Short Key for a House Bank
  • FACVD_CLROI_02.[column in domain "BUKRS"] == T012.BUKRS
  • FACVD_CLROI_02.MANDT == T012.MANDT
  • FACVD_CLROI_02.HBKID == T012.HBKID
General Ledger Account
  • Company Code
  • Client
  • General Ledger Account
  • General Ledger Account
  • FACVD_CLROI_02.BUKRS == SKB1.BUKRS
  • FACVD_CLROI_02.MANDT == SKB1.MANDT
  • FACVD_CLROI_02.HKONT == SKB1.SAKNR
  • FACVD_CLROI_02.KONKO == SKB1.SAKNR
ID for Account Details
  • ?
  • Client
  • Short Key for a House Bank
  • ID for Account Details
  • FACVD_CLROI_02.[column in domain "BUKRS"] == T012K.BUKRS
  • FACVD_CLROI_02.MANDT == T012K.MANDT
  • FACVD_CLROI_02.HBKID == T012K.HBKID
  • FACVD_CLROI_02.HKTID == T012K.HKTID
Document Type
  • Client
  • Document Type
  • FACVD_CLROI_02.MANDT == T003.MANDT
  • FACVD_CLROI_02.H_BLART == T003.BLART
Currency Key
  • Client
  • Currency Key
  • FACVD_CLROI_02.MANDT == TCURC.MANDT
  • FACVD_CLROI_02.H_WAERS == TCURC.WAERS
Credit control area
  • Credit control area
  • Client
  • FACVD_CLROI_02.KKBER == T014.KKBER
  • FACVD_CLROI_02.MANDT == T014.MANDT
Account Number of an Alternative Payer
  • Client
  • Account Number of an Alternative Payer
  • FACVD_CLROI_02.MANDT == KNA1.MANDT
  • FACVD_CLROI_02.KNA1_KNRZA == KNA1.KUNNR
Account number of an alternative payer
  • Client
  • Account number of an alternative payer
  • FACVD_CLROI_02.MANDT == KNA1.MANDT
  • FACVD_CLROI_02.KNB1_KNRZB == KNA1.KUNNR
General Ledger Account
  • Company Code
  • Client
  • General Ledger Account
  • General Ledger Account
  • FACVD_CLROI_02.BUKRS == SKB1.BUKRS
  • FACVD_CLROI_02.MANDT == SKB1.MANDT
  • FACVD_CLROI_02.HKONT == SKB1.SAKNR
  • FACVD_CLROI_02.KONKO == SKB1.SAKNR
Customer Number
  • Customer Number
  • Client
  • FACVD_CLROI_02.KUNNR == KNA1.KUNNR
  • FACVD_CLROI_02.MANDT == KNA1.MANDT
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • FACVD_CLROI_02.LIFNR == LFA1.LIFNR
  • FACVD_CLROI_02.MANDT == LFA1.MANDT
Dunning Area
  • Company Code
  • Client
  • Dunning Area
  • FACVD_CLROI_02.BUKRS == T047M.BUKRS
  • FACVD_CLROI_02.MANDT == T047M.MANDT
  • FACVD_CLROI_02.MABER == T047M.MABER
Dunning Block
  • Client
  • Dunning Block
  • FACVD_CLROI_02.MANDT == T040S.MANDT
  • FACVD_CLROI_02.MANSP == T040S.MANSP
Dunning Key
  • Dunning Key
  • Client
  • FACVD_CLROI_02.MSCHL == T040.MSCHL
  • FACVD_CLROI_02.MANDT == T040.MANDT
Update Currency for General Ledger Transaction Figures
  • Client
  • Update Currency for General Ledger Transaction Figures
  • FACVD_CLROI_02.MANDT == TCURC.MANDT
  • FACVD_CLROI_02.PSWSL == TCURC.WAERS
Currency for Automatic Payment
  • Client
  • Currency for Automatic Payment
  • FACVD_CLROI_02.MANDT == TCURC.MANDT
  • FACVD_CLROI_02.PYCUR == TCURC.WAERS
Recovery Indicator
  • Company Code
  • Client
  • Recovery Indicator
  • FACVD_CLROI_02.BUKRS == T8JJ.BUKRS
  • FACVD_CLROI_02.MANDT == T8JJ.MANDT
  • FACVD_CLROI_02.RECID == T8JJ.RECID
Special G/L Indicator
  • Client
  • ?
  • Special G/L Indicator
  • FACVD_CLROI_02.MANDT == T074U.MANDT
  • FACVD_CLROI_02.[column in domain "KOART"] == T074U.KOART
  • FACVD_CLROI_02.UMSKZ == T074U.UMSKZ
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • FACVD_CLROI_02.MANDT == T880.MANDT
  • FACVD_CLROI_02.VBUND == T880.RCOMP
Joint venture
  • Company Code
  • Client
  • Joint venture
  • FACVD_CLROI_02.BUKRS == T8JV.BUKRS
  • FACVD_CLROI_02.MANDT == T8JV.MANDT
  • FACVD_CLROI_02.VNAME == T8JV.VNAME
Payment Method
  • Payment Method
  • Client
  • ?
  • FACVD_CLROI_02.ZLSCH == T042Z.ZLSCH
  • FACVD_CLROI_02.MANDT == T042Z.MANDT
  • FACVD_CLROI_02.[column in domain "LAND1"] == T042Z.LAND1
Payment Block Key
  • Payment Block Key
  • Client
  • FACVD_CLROI_02.ZLSPR == T008.ZAHLS
  • FACVD_CLROI_02.MANDT == T008.MANDT