FACVD_CLRIT_03

Open items which are not cleared in session of mnl clearing | view: FACV_CLRIT_03 | TRAN | Extraction: Not supported | Component: Fiori UI for General Ledger Accounting
Column Name Description
Column Name Description
dmbtr Amount in local currency
dmbtr_shl null
💲 Currency Key (h_waers):
wskto Cash Discount Amount in Document Currency
wrbtr Amount in document currency
wrbtr_shl 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
gjahr Fiscal Year GJAHR
belnr Document Number of an Accounting Document BELNR
buzei Number of Line Item Within Accounting Document BUZEI
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
NetDueOutstandingDays null
sgtxt Item Text TEXT50
skb1_begru Authorization Group BRGRU
zuonr Assignment number ZUONR
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
processing_status null
processor User Name USERNAME
processor_text Full Name of Person TEXT80
drft_uuid Draft key (raw16) RAW16
butxt Name of Company Code or Company TEXT25
name1 Name 1 NAME
busab null
busab_sname Name of Accounting Clerk TEXT30
h_logsystem_sender Logical System of the Sender LOGSYS
h_bukrs_sender Company Code in Sender System CHAR4
h_belnr_sender Document Number of an Accounting Document in Sender System BELNR
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
blart_ltext Document Type Name TEXT20
toler Grace Days TOLER_043G
j_1tpbupl Branch Code BCODE
TH_BranchCodeDescription Branch Code Description FITH_DESC
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
  • FACVD_CLRIT_03.BUKRS == T001.BUKRS
  • FACVD_CLRIT_03.MANDT == T001.MANDT
General Ledger Account
  • Company Code
  • General Ledger Account
  • General Ledger Account
  • Client
  • FACVD_CLRIT_03.BUKRS == SKB1.BUKRS
  • FACVD_CLRIT_03.KONKO == SKB1.SAKNR
  • FACVD_CLRIT_03.HKONT == SKB1.SAKNR
  • FACVD_CLRIT_03.MANDT == SKB1.MANDT
Document Type
  • Document Type
  • Client
  • FACVD_CLRIT_03.H_BLART == T003.BLART
  • FACVD_CLRIT_03.MANDT == T003.MANDT
Currency Key
  • Currency Key
  • Client
  • FACVD_CLRIT_03.H_WAERS == TCURC.WAERS
  • FACVD_CLRIT_03.MANDT == TCURC.MANDT
General Ledger Account
  • Company Code
  • General Ledger Account
  • General Ledger Account
  • Client
  • FACVD_CLRIT_03.BUKRS == SKB1.BUKRS
  • FACVD_CLRIT_03.KONKO == SKB1.SAKNR
  • FACVD_CLRIT_03.HKONT == SKB1.SAKNR
  • FACVD_CLRIT_03.MANDT == SKB1.MANDT
Customer Number
  • Customer Number
  • Client
  • FACVD_CLRIT_03.KUNNR == KNA1.KUNNR
  • FACVD_CLRIT_03.MANDT == KNA1.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • FACVD_CLRIT_03.LAND1 == T005.LAND1
  • FACVD_CLRIT_03.MANDT == T005.MANDT
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • FACVD_CLRIT_03.LIFNR == LFA1.LIFNR
  • FACVD_CLRIT_03.MANDT == LFA1.MANDT
Dunning Area
  • Dunning Area
  • Company Code
  • Client
  • FACVD_CLRIT_03.MABER == T047M.MABER
  • FACVD_CLRIT_03.BUKRS == T047M.BUKRS
  • FACVD_CLRIT_03.MANDT == T047M.MANDT
Dunning Block
  • Client
  • Dunning Block
  • FACVD_CLRIT_03.MANDT == T040S.MANDT
  • FACVD_CLRIT_03.MANSP == T040S.MANSP
Dunning Key
  • Dunning Key
  • Client
  • FACVD_CLRIT_03.MSCHL == T040.MSCHL
  • FACVD_CLRIT_03.MANDT == T040.MANDT
Update Currency for General Ledger Transaction Figures
  • Update Currency for General Ledger Transaction Figures
  • Client
  • FACVD_CLRIT_03.PSWSL == TCURC.WAERS
  • FACVD_CLRIT_03.MANDT == TCURC.MANDT
Special G/L Indicator
  • ?
  • Client
  • Special G/L Indicator
  • FACVD_CLRIT_03.[column in domain "KOART"] == T074U.KOART
  • FACVD_CLRIT_03.MANDT == T074U.MANDT
  • FACVD_CLRIT_03.UMSKZ == T074U.UMSKZ
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • FACVD_CLRIT_03.MANDT == T880.MANDT
  • FACVD_CLRIT_03.VBUND == T880.RCOMP
Payment Method
  • Country/Region Key
  • Payment Method
  • Client
  • FACVD_CLRIT_03.LAND1 == T042Z.LAND1
  • FACVD_CLRIT_03.ZLSCH == T042Z.ZLSCH
  • FACVD_CLRIT_03.MANDT == T042Z.MANDT
Payment Block Key
  • Payment Block Key
  • Client
  • FACVD_CLRIT_03.ZLSPR == T008.ZAHLS
  • FACVD_CLRIT_03.MANDT == T008.MANDT