P_Sales_Division

Private View for Sales Division | view: P_TVTA | TRAN | Extraction: Not supported | Component: Commodity Contracts, Expenses, Basic Functions
Tables used: TVTA
Column Name Description
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
  • Business Area
  • Client
  • P_SALES_DIVISION.GSBER == TGSB.GSBER
  • P_SALES_DIVISION.MANDT == TGSB.MANDT
Branch for export operations
  • ?
  • ?
  • Branch for export operations
  • Client
  • P_SALES_DIVISION.[column in domain "BUKRS"] == J_1BBRANCH.BUKRS
  • P_SALES_DIVISION.[column in domain "GLO_BUPLA_TYPE_CODE"] == J_1BBRANCH.BUPLA_TYPE
  • P_SALES_DIVISION.J_1AESNR == J_1BBRANCH.BRANCH
  • P_SALES_DIVISION.MANDT == J_1BBRANCH.MANDT
Branch for domestic operations
  • ?
  • ?
  • Branch for domestic operations
  • Client
  • P_SALES_DIVISION.[column in domain "BUKRS"] == J_1BBRANCH.BUKRS
  • P_SALES_DIVISION.[column in domain "GLO_BUPLA_TYPE_CODE"] == J_1BBRANCH.BUPLA_TYPE
  • P_SALES_DIVISION.J_1ASNR == J_1BBRANCH.BRANCH
  • P_SALES_DIVISION.MANDT == J_1BBRANCH.MANDT
Credit control area
  • Credit control area
  • Client
  • P_SALES_DIVISION.KKBER == T014.KKBER
  • P_SALES_DIVISION.MANDT == T014.MANDT
Dunning Area
  • ?
  • Dunning Area
  • Client
  • P_SALES_DIVISION.[column in domain "BUKRS"] == T047M.BUKRS
  • P_SALES_DIVISION.MABER == T047M.MABER
  • P_SALES_DIVISION.MANDT == T047M.MANDT
Reference division for document types (by sales area)
  • Reference division for document types (by sales area)
  • Client
  • P_SALES_DIVISION.SPAAU == TSPA.SPART
  • P_SALES_DIVISION.MANDT == TSPA.MANDT
Reference division for conditions
  • Reference division for conditions
  • Client
  • P_SALES_DIVISION.SPAKO == TSPA.SPART
  • P_SALES_DIVISION.MANDT == TSPA.MANDT
Reference division for customers
  • Reference division for customers
  • Client
  • P_SALES_DIVISION.SPAKU == TSPA.SPART
  • P_SALES_DIVISION.MANDT == TSPA.MANDT
Division
  • Division
  • Client
  • Sales Organization
  • P_SALES_DIVISION.SPART == TVKOS.SPART
  • P_SALES_DIVISION.MANDT == TVKOS.MANDT
  • P_SALES_DIVISION.VKORG == TVKOS.VKORG
Reference sales org.for sales doc.types (by sales area)
  • Reference sales org.for sales doc.types (by sales area)
  • Client
  • P_SALES_DIVISION.VKOAU == TVKO.VKORG
  • P_SALES_DIVISION.MANDT == TVKO.MANDT
Sales Organization
  • Client
  • Sales Organization
  • P_SALES_DIVISION.MANDT == TVKO.MANDT
  • P_SALES_DIVISION.VKORG == TVKO.VKORG
Distribution channel for sales doc types
  • Distribution channel for sales doc types
  • Client
  • P_SALES_DIVISION.VTWAU == TVTW.VTWEG
  • P_SALES_DIVISION.MANDT == TVTW.MANDT
Distribution Channel
  • Client
  • Sales Organization
  • Distribution Channel
  • P_SALES_DIVISION.MANDT == TVKOV.MANDT
  • P_SALES_DIVISION.VKORG == TVKOV.VKORG
  • P_SALES_DIVISION.VTWEG == TVKOV.VTWEG
Reference distribution channel for conditions
  • Reference distribution channel for conditions
  • Client
  • P_SALES_DIVISION.VTWKO == TVTW.VTWEG
  • P_SALES_DIVISION.MANDT == TVTW.MANDT
Reference distrib.channel for cust.and material masters
  • Client
  • Reference distrib.channel for cust.and material masters
  • P_SALES_DIVISION.MANDT == TVTW.MANDT
  • P_SALES_DIVISION.VTWKU == TVTW.VTWEG