TVTA

Organizational Unit: Sales Area(s) | #masterdata | Component: Account Determination
Column Name Description
MANDT Client
VKORG FK Sales Organization
VTWEG FK Distribution Channel
SPART FK Division
Column Name Description
Column Name Description
Column Name Description
Column Name Description
REGGB Rule for determining the business area Show values
REVFP Rule for transferring the results of the availability check Show values
FIXMG Delivery Date and Quantity Fixed Show values
AFIND Promo determination Show values
HIDE Customization of SD Input Help Entries Show values
J_3GKBAUL ETM-Relevant Indicator Show values
OID_CHECKC Check customer ship-to/sold-to warning/error/information Show values
Column Name Description Domain name
Master Data Relations Join Conditions
Business Area
  • TVTA.MANDT == TGSB.MANDT
  • TVTA.GSBER == TGSB.GSBER
Branch for export operations
  • ?
  • Branch for export operations
  • Client
  • ?
Branch for domestic operations
  • ?
  • Branch for domestic operations
  • Client
  • ?
Credit control area
  • TVTA.MANDT == T014.MANDT
  • TVTA.KKBER == T014.KKBER
Dunning Area
  • Dunning Area
  • ?
  • TVTA.MANDT == T047M.MANDT
  • TVTA.MABER == T047M.MABER
  • TVTA.[column in domain "BUKRS"] == T047M.BUKRS
Reference division for document types (by sales area)
  • TVTA.MANDT == TSPA.MANDT
  • TVTA.SPAAU == TSPA.SPART
Reference division for conditions
  • TVTA.MANDT == TSPA.MANDT
  • TVTA.SPAKO == TSPA.SPART
Reference division for customers
  • TVTA.MANDT == TSPA.MANDT
  • TVTA.SPAKU == TSPA.SPART
Division
  • Sales Organization
  • Division
  • TVTA.MANDT == TVKOS.MANDT
  • TVTA.VKORG == TVKOS.VKORG
  • TVTA.SPART == TVKOS.SPART
Reference sales org.for sales doc.types (by sales area)
  • TVTA.MANDT == TVKO.MANDT
  • TVTA.VKOAU == TVKO.VKORG
Sales Organization
  • TVTA.MANDT == TVKO.MANDT
  • TVTA.VKORG == TVKO.VKORG
Distribution channel for sales doc types
  • Distribution channel for sales doc types
  • Client
  • TVTA.VTWAU == TVTW.VTWEG
  • TVTA.MANDT == TVTW.MANDT
Distribution Channel
  • Sales Organization
  • Client
  • Distribution Channel
  • TVTA.VKORG == TVKOV.VKORG
  • TVTA.MANDT == TVKOV.MANDT
  • TVTA.VTWEG == TVKOV.VTWEG
Reference distribution channel for conditions
  • Reference distribution channel for conditions
  • Client
  • TVTA.VTWKO == TVTW.VTWEG
  • TVTA.MANDT == TVTW.MANDT
Reference distrib.channel for cust.and material masters
  • Reference distrib.channel for cust.and material masters
  • Client
  • TVTA.VTWKU == TVTW.VTWEG
  • TVTA.MANDT == TVTW.MANDT