CFIN_AV_SO_ROOT

Sales Document: Header Data | #masterdata | Component: Accounting View of Logistics Information
Column Name Description
MANDT Client
AV_DBKEY Accounting View DB KEY
Column Name Description
💲 SD Document Currency (WAERK):
NETWR Net Value of the Sales Order in Document Currency
Column Name Description
Column Name Description
ERDAT Date on which the record was created
AEDAT Last Changed On
AUDAT Document Date (Date Received/Sent)
Column Name Description
VGTYP Document Category of Preceding SD Document Show values
VBTYP SD Document Category Show values
TRVOG Transaction Group Show values
IUUC_OPERAT_FLAG Delete/Archive Indicator 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 Sales Document VBELN
VGBEL Document number of the reference document VBELN
KOSTL Cost Center KOSTL
ERNAM Name of Person Responsible for Creating the Object USNAM
KNUMV Number of the Document Condition KNUMV
DUMMY_AVSO_INCL_EEW_PS Custom Fields: Dummy for Use in Extension Includes
Master Data Relations Join Conditions
Sales Document Type
  • CFIN_AV_SO_ROOT.MANDT == TVAK.MANDT
  • CFIN_AV_SO_ROOT.AUART == TVAK.AUART
Company Code to Be Billed
  • CFIN_AV_SO_ROOT.MANDT == T001.MANDT
  • CFIN_AV_SO_ROOT.BUKRS_VF == T001.BUKRS
Logical system CFIN_AV_SO_ROOT.FINS_LOGSYS == TBDLS.LOGSYS
Pricing Procedure in Pricing
  • ?
  • Pricing Procedure in Pricing
  • ?
  • CFIN_AV_SO_ROOT.MANDT == T683.MANDT
  • CFIN_AV_SO_ROOT.[column in domain "KAPPL"] == T683.KAPPL
  • CFIN_AV_SO_ROOT.KALSM == T683.KALSM
  • CFIN_AV_SO_ROOT.[column in domain "KVEWE"] == T683.KVEWE
Controlling Area
  • CFIN_AV_SO_ROOT.MANDT == TKA01.MANDT
  • CFIN_AV_SO_ROOT.KOKRS == TKA01.KOKRS
Sold-to Party
  • CFIN_AV_SO_ROOT.MANDT == KNA1.MANDT
  • CFIN_AV_SO_ROOT.KUNNR == KNA1.KUNNR
Tax Departure Country/Region
  • Tax Departure Country/Region
  • Client
  • CFIN_AV_SO_ROOT.LANDTX == T005.LAND1
  • CFIN_AV_SO_ROOT.MANDT == T005.MANDT
Division
  • Sales Organization
  • Distribution Channel
  • Division
  • Client
  • CFIN_AV_SO_ROOT.VKORG == TVTA.VKORG
  • CFIN_AV_SO_ROOT.VTWEG == TVTA.VTWEG
  • CFIN_AV_SO_ROOT.SPART == TVTA.SPART
  • CFIN_AV_SO_ROOT.MANDT == TVTA.MANDT
Sales group
  • Sales group
  • Sales office
  • CFIN_AV_SO_ROOT.MANDT == TVBVK.MANDT
  • CFIN_AV_SO_ROOT.VKGRP == TVBVK.VKGRP
  • CFIN_AV_SO_ROOT.VKBUR == TVBVK.VKBUR
Sales Organization
  • CFIN_AV_SO_ROOT.MANDT == TVKO.MANDT
  • CFIN_AV_SO_ROOT.VKORG == TVKO.VKORG
Distribution Channel
  • Sales Organization
  • Client
  • Distribution Channel
  • CFIN_AV_SO_ROOT.VKORG == TVKOV.VKORG
  • CFIN_AV_SO_ROOT.MANDT == TVKOV.MANDT
  • CFIN_AV_SO_ROOT.VTWEG == TVKOV.VTWEG
SD Document Currency
  • CFIN_AV_SO_ROOT.MANDT == TCURC.MANDT
  • CFIN_AV_SO_ROOT.WAERK == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Sales Organization
  • Client
  • Distribution Channel
  • Division
  • Sales office
  • CFIN_AV_SO_ROOT.VKORG == TVKBZ.VKORG
  • CFIN_AV_SO_ROOT.MANDT == TVKBZ.MANDT
  • CFIN_AV_SO_ROOT.VTWEG == TVKBZ.VTWEG
  • CFIN_AV_SO_ROOT.SPART == TVKBZ.SPART
  • CFIN_AV_SO_ROOT.VKBUR == TVKBZ.VKBUR