CFIN_AV_CI_ROOT

Billing Document: Header Data | #masterdata | Component: Accounting View of Logistics Information
Column Name Description
MANDT Client
AV_DBKEY Accounting View DB KEY
Column Name Description
Column Name Description
Column Name Description
ERDAT Date on which the record was created
FKDAT Billing Date
KURRF_DAT Translation date
Column Name Description
VBTYP SD Document Category Show values
FKSTO Billing document is canceled Show values
STCEG_H Origin of Sales Tax ID Number Show values
IUUC_OPERAT_FLAG Delete/Archive Indicator Show values
FKTYP Billing Category Show values
Column Name Description Domain name
AV_CHANGEDTIME Accounting View Changed Time TZNTSTMPS
AV_CHANGEUSER Accounting View Change User UNAME
AV_CREATEDTIME Accounting View Created Time TZNTSTMPS
AV_CREATEUSER Accounting View Create User UNAME
VBELN Billing Document VBELN
SFAKN Number of canceled billing document VBELN
KURRF Exchange Rate for Postings to Financial Accounting KURRF
VALTG Additional Value Days TAGE2
KNUMV Number of the Document Condition KNUMV
LANDTX Tax Departure Country/Region LAND1
DUMMY_AVCI_INCL_EEW_PS Custom Fields: Dummy for Use in Extension Includes
Master Data Relations Join Conditions
Company Code
  • CFIN_AV_CI_ROOT.MANDT == T001.MANDT
  • CFIN_AV_CI_ROOT.BUKRS == T001.BUKRS
Logical system CFIN_AV_CI_ROOT.FINS_LOGSYS == TBDLS.LOGSYS
Pricing Procedure in Pricing
  • ?
  • Pricing Procedure in Pricing
  • ?
  • CFIN_AV_CI_ROOT.MANDT == T683.MANDT
  • CFIN_AV_CI_ROOT.[column in domain "KAPPL"] == T683.KAPPL
  • CFIN_AV_CI_ROOT.KALSM == T683.KALSM
  • CFIN_AV_CI_ROOT.[column in domain "KVEWE"] == T683.KVEWE
Sold-to Party
  • CFIN_AV_CI_ROOT.MANDT == KNA1.MANDT
  • CFIN_AV_CI_ROOT.KUNAG == KNA1.KUNNR
Payer
  • CFIN_AV_CI_ROOT.MANDT == KNA1.MANDT
  • CFIN_AV_CI_ROOT.KUNRG == KNA1.KUNNR
SD Document Currency
  • CFIN_AV_CI_ROOT.MANDT == TCURC.MANDT
  • CFIN_AV_CI_ROOT.WAERK == TCURC.WAERS