TOI0_REL_TC

TSW relevance table for trading contract | #other | Component: Trader's and Scheduler's Workbench
Column Name Description
CLIENT Client
APPLIC FK IS-OIL application index
TCTYP FK Trading Contract Type
PROCESS_IND Indicator for purchasing and sales side of trading contracts Show values
COUNTER IS-Oil: Counter for relevance customizing
Column Name Description
Column Name Description
Column Name Description
Column Name Description
PROCESS_IND Indicator for purchasing and sales side of trading contracts Show values
Column Name Description Domain name
Master Data Relations Join Conditions
IS-OIL application index
  • TOI0_REL_TC.CLIENT == TOI0_J.CLIENT
  • TOI0_REL_TC.APPLIC == TOI0_J.APPLIC
Confirmation Control Key
  • Confirmation Control Key
  • Client
  • TOI0_REL_TC.BSTAE_MM == T163L.BSTAE
  • TOI0_REL_TC.CLIENT == T163L.MANDT
Company Code
  • TOI0_REL_TC.CLIENT == T001.MANDT
  • TOI0_REL_TC.BUKRS == T001.BUKRS
Valuation Type
  • TOI0_REL_TC.CLIENT == T149D.MANDT
  • TOI0_REL_TC.BWTAR == T149D.BWTAR
Valuation Category
  • Valuation Category
  • Client
  • TOI0_REL_TC.BWTTY_MM == T149C.BWTTY
  • TOI0_REL_TC.CLIENT == T149C.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • TOI0_REL_TC.EKGRP == T024.EKGRP
  • TOI0_REL_TC.CLIENT == T024.MANDT
Purchasing organization
  • TOI0_REL_TC.CLIENT == T024E.MANDT
  • TOI0_REL_TC.EKORG == T024E.EKORG
Vendor's account number
  • TOI0_REL_TC.CLIENT == LFA1.MANDT
  • TOI0_REL_TC.ELIFN == LFA1.LIFNR
Check item categories
  • Item Category
  • Client
  • TOI0_REL_TC.HKPSTP == TB2BJ.HKPSTP
  • TOI0_REL_TC.CLIENT == TB2BJ.MANDT
Check Incoterms
  • Incoterms Part 1 Purchasing
  • Client
  • TOI0_REL_TC.INCO1_MM == TINC.INCO1
  • TOI0_REL_TC.CLIENT == TINC.MANDT
Check Incoterms
  • Incoterms Part 1 Sales
  • Client
  • TOI0_REL_TC.INCO1_SD == TINC.INCO1
  • TOI0_REL_TC.CLIENT == TINC.MANDT
Sold-To Party
  • TOI0_REL_TC.CLIENT == KNA1.MANDT
  • TOI0_REL_TC.KUNNR == KNA1.KUNNR
Storage location
  • Storage location
  • Client
  • Plant
  • TOI0_REL_TC.LGORT == T001L.LGORT
  • TOI0_REL_TC.CLIENT == T001L.MANDT
  • TOI0_REL_TC.WERKS == T001L.WERKS
Material Group
  • TOI0_REL_TC.CLIENT == T023.MANDT
  • TOI0_REL_TC.MATKL == T023.MATKL
Material Number
  • Material Number
  • Client
  • TOI0_REL_TC.MATNR == MARA.MATNR
  • TOI0_REL_TC.CLIENT == MARA.MANDT
Industry Sector
  • TOI0_REL_TC.CLIENT == T137.MANDT
  • TOI0_REL_TC.MBRSH == T137.MBRSH
Material types
  • TOI0_REL_TC.CLIENT == T134.MANDT
  • TOI0_REL_TC.MTART == T134.MTART
IS-Oil: Relevance type
  • IS-OIL application index
  • IS-Oil: Relevance type
Division
  • TOI0_REL_TC.CLIENT == TSPA.MANDT
  • TOI0_REL_TC.SPART == TSPA.SPART
Trading Contract Type
  • TOI0_REL_TC.CLIENT == TB2BE.MANDT
  • TOI0_REL_TC.TCTYP == TB2BE.TCTYP
Sales Organization
  • TOI0_REL_TC.CLIENT == TVKO.MANDT
  • TOI0_REL_TC.VKORG == TVKO.VKORG
Shipping Conditions
  • TOI0_REL_TC.CLIENT == TVSB.MANDT
  • TOI0_REL_TC.VSBED_SD == TVSB.VSBED
Shipping point
  • TOI0_REL_TC.CLIENT == TVST.MANDT
  • TOI0_REL_TC.VSTEL_SD == TVST.VSTEL
Distribution Channel
  • Distribution Channel
  • Client
  • TOI0_REL_TC.VTWEG == TVTW.VTWEG
  • TOI0_REL_TC.CLIENT == TVTW.MANDT
Plant
  • TOI0_REL_TC.CLIENT == T001W.MANDT
  • TOI0_REL_TC.WERKS == T001W.WERKS