SAP ABAP Table TOI0_REL_SD (IS-OIL: Relevance customizing for SD Documents)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL (Application Component) Industry Solution Oil
     ⤷ OI0_IF (Package) Common objects new Interfaces/BAPI

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	TOI0_REL_SD	Table Relationship Diagram
Short Description	IS-OIL: Relevance customizing for SD Documents

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	APPLIC	☑	OI0_APPLIC	OI0_APPLIC	NUMC	4	0	IS-OIL application index	TOI0_J
3	VBTYP	☑	VBTYP	VBTYP	CHAR	1	0	SD document category	TOI0_REL_DOCS
4	AUART	☑	AUART	AUART	CHAR	4	0	Sales Document Type	TVAK
5	COUNTER	☑	OI0_COUNTER	OI0_COUNTER	NUMC	9	0	IS-Oil: Counter for relevance customizing
6	.INCLUDE	☐				0	0	IS-OIL: Relevance data fields for SD Documents
7	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
8	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
9	SPART	☐	SPART	SPART	CHAR	2	0	Division	*
10	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
11	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
12	VSTEL	☐	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point	*
13	LADGR	☐	LADGR	LADGR	CHAR	4	0	Loading Group	*
14	MBRSH	☐	MBRSH	MBRSH	CHAR	1	0	Industry sector	*
15	MTART	☐	MTART	MTART	CHAR	4	0	Material type	*
16	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
17	LZONE	☐	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered	*
18	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
19	VSBED	☐	VSBED	VSBED	CHAR	2	0	Shipping conditions	*
20	OIC_MOT	☐	OIC_MOT	VKTRA	CHAR	2	0	IS-OIL MAP external details mode of transport	*
21	TPLST	☐	TPLST	TPLST	CHAR	4	0	Transportation planning point	*
22	KUNNR	☐	KUNWE	KUNNR	CHAR	10	0	Ship-to party	KNA1
23	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
24	CCAPGR	☐	OIK_CCAPGR	CHAR4	CHAR	4	0	OIL-TPI: Customer Capacity Group	TOIKCCAPGR
25	GRTYPE	☐	OIK_GRTYPE	OIK_GRTYPE	CHAR	2	0	OIL-TPI: Group Type	TOIKGRTYPE
26	GRNAME	☐	OIK_GRNAME	CHAR20	CHAR	20	0	OIL-TPI: Group Name
27	INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	TINC
28	PSTYV	☐	PSTYV	PSTYV	CHAR	4	0	Sales document item category	TVPT
29	RELEVANCE_TYPE	☐	OI0_RELTYPE	OI0_RELTYPE	CHAR	6	0	IS-Oil: Relevance type	TOI0_REL_VAL

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TOI0_REL_SD	APPLIC	TOI0_J	APPLIC
2	TOI0_REL_SD	AUART	TVAK	AUART
3	TOI0_REL_SD	BWTAR	T149D	BWTAR
4	TOI0_REL_SD	CCAPGR	TOIKCCAPGR	CCAPGR
5	TOI0_REL_SD	CLIENT	T000	MANDT
6	TOI0_REL_SD	GRTYPE	TOIKGRTYPE	GRTYPE
7	TOI0_REL_SD	INCO1	TINC	INCO1
8	TOI0_REL_SD	KUNNR	KNA1	KUNNR
9	TOI0_REL_SD	PSTYV	TVPT	PSTYV
10	TOI0_REL_SD	RELEVANCE_TYPE	TOI0_REL_VAL	RELEVANCE_TYPE
11	TOI0_REL_SD	VBTYP	TOI0_REL_DOCS	VBTYP	KEY

History

Last changed by/on	SAP	20130529
SAP Release Created in	46C