SAP ABAP Table ERPS_WEC_ITEM_CATEGORY_DATA (Item Category data)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ WEC-APP-SLS-ERP (Application Component) WebChannel Sales using ERP-SD
     ⤷ ERP_WEC_IPC (Package) WCEM IPC Integration

Basic Data

Table Category	INTTAB	Structure
Structure	ERPS_WEC_ITEM_CATEGORY_DATA	Table Relationship Diagram
Short Description	Item Category data

Delivery and Maintenance

Pool/cluster
Delivery Class
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	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
2	SALES_ORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
3	DISTRIBUTION_CHANNEL	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
4	PROCESS_TYPE	☐	AUART	AUART	CHAR	4	0	Sales Document Type	*
5	.INCLUDE	☐				0	0	Sales Document: Item Categories
6	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
7	PSTYV	☐	PSTYV	PSTYV	CHAR	4	0	Sales document item category	TVPT
8	FKREL	☐	FKREL	FKREL	CHAR	1	0	Relevant for Billing
9	PRSFD	☐	PRSFD	PRSFD	CHAR	1	0	Carry out pricing
10	POSGR	☐	BIFGR	BIFGR	CHAR	4	0	Screen sequence group for document header & item	TVHB
11	PARGR	☐	PARGR	PARGR	CHAR	4	0	Partner Determination Procedure	TVPG
12	PSGRP	☐	CAPID	CAPID	CHAR	4	0	Application	TC04
13	STULI	☐	STULI	STULI	CHAR	1	0	Material structure
14	ASWPA	☐	ASWPA	XFELD	CHAR	1	0	Manual selection for BOM alternatives
15	STRUM	☐	STRUM	STRUM	CHAR	1	0	Structural scope of a material with bill of material
16	EVRWR	☐	EVRWR	XFELD	CHAR	1	0	Determine cost
17	KOWRR	☐	KOWRR	KOWRR	CHAR	1	0	Statistical values
18	FELDP	☐	FELDP	FAWGR	CHAR	4	0	Field Selection for Item	TVHF
19	FAKSP	☐	FAKSP	FAKSP	CHAR	2	0	Lock	TVFS
20	SHELL	☐	SHELL	SHELL	CHAR	1	0	Bill of material in foreground
21	ERLRE	☐	ERLRE	ERLRE	CHAR	1	0	Completion rule for quotation / contract
22	TXN08	☐	TXN08	TXN08	CHAR	8	0	Number of the standard text
23	DIAFM	☐	DIAFM	XFELD	CHAR	1	0	Dialog for Short Quantity
24	KDERL	☐	KDERL	XFELD	CHAR	1	0	Business data allowed at item level ?
25	TXTGR	☐	TXTGR	TXTGR	CHAR	2	0	Text Determination Procedure	TTXG
26	POSAR	☐	POSAR	POSAR	CHAR	1	0	Item type
27	LFREL	☐	LFREL_AP	XFELD	CHAR	1	0	Item is relevant for delivery
28	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
29	ETERL	☐	ETERL	XFELD	CHAR	1	0	Schedule lines allowed
30	GWREL	☐	GWREL	XFELD	CHAR	1	0	Relevant for Weight/Volume
31	KOMPP	☐	KOMPP	KOMPP	CHAR	1	0	Create Deivery Group and Correlate BOM Components
32	FEHGR	☐	FEHGR	FEHGR	CHAR	2	0	Incompletion procedure for sales document	TVUV
33	SHKZG	☐	SHKZG_VA	XFELD	CHAR	1	0	Returns Item
34	EQMAT	☐	EQMAT	XFELD	CHAR	1	0	Material block indicator
35	STGAP	☐	STGAP	STGVB	CHAR	2	0	Statistics group for the item category	TVSF
36	KALSM	☐	KALSMBP	KALSM	CHAR	6	0	Procedure for item output	T683
37	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
38	CMPNT	☐	CMPNT	XFELD	CHAR	1	0	ID: Item with active credit function / relevant for credit
39	STRAT	☐	STRATCON	STRAT2	CHAR	2	0	Form of configuration processing	T476
40	STSMA	☐	J_STSMA	J_STSMA	CHAR	8	0	Status Profile	TJ20
41	MENG1	☐	MENG1	XFELD	CHAR	1	0	Order quantiy for each item is limited to 1
42	ALEKZ	☐	ALEKZ	XFELD	CHAR	1	0	Create purchase order automatically
43	FPART	☐	FPART	FPART	CHAR	2	0	Billing plan/invoice plan type	TFPLA
44	CHAUT	☐	CHAUT	XFELD	CHAR	1	0	Automatic batch determination
45	EXCOP	☐	EXCOP	EXCOP	CHAR	1	0	Carry out legal control for item category
46	SVGNG	☐	SVGNG	SVGNG	CHAR	4	0	Transaction Type for Controlling Technical Objects
47	TYPFD	☐	TYPFD	XFELD	CHAR	1	0	Carry out variant matching
48	LTYPA	☐	LTYPA	LTYPA	CHAR	1	0	Action when material variant determined during configuration
49	LTYPV	☐	LTYPV	LTYPV	CHAR	1	0	Run ATP check on material variants
50	WKMAT	☐	WKMAT	MATNR	CHAR	18	0	Value contract material	MARA
51	RKTIO	☐	RKTIO	RKTIO	CHAR	1	0	Response on reaching release order value in value contract
52	SEGAL	☐	SEGAL	SEGAL	CHAR	2	0	Exclusion/Inclusion indicator for declara. to authorities	T609A
53	STDTE	☐	STDTE	STDTE	CHAR	1	0	Determine date for bill of materials configuration
54	RDERL	☐	RDERL	XFELD	CHAR	1	0	Rounding permitted?
55	EFFEC	☐	EFFEC	XFELD	CHAR	1	0	Indicator: Assign values for parameter effectivities
56	FFPRF	☐	AD01PROFNR	AD01PROFNR	CHAR	8	0	Dynamic Item Processor Profile	AD01C_PROF
57	SCHEME_RMA	☐	RMA_SCHEMA	RMA_SCHEMA	CHAR	4	0	Repair procedure: Procedure	TVRMAS
58	SCHEME_VF	☐	VF_SCHEMA	VF_SCHEMA	CHAR	4	0	Variant matching procedure: procedure	TVVFS
59	FAKTF	☐	FAKTF	FAKTF	CHAR	2	0	Billing Form
60	RRREL	☐	RR_RELTYP	RR_RELTYP	CHAR	1	0	Revenue recognition category
61	ACDATV	☐	RR_ACDATV	RR_ACDATV	CHAR	1	0	Proposed start date for accrual period
62	UVEIB	☐	UVEIB	UVEIB	CHAR	3	0	Doc. pricing procedure for incomplete export/import data	T609B
63	OIBOM	☐	OIB_BOM	OIB_BOM	CHAR	1	0	Use of item category as part of an Oil bill of material(BOM)
64	OIBCST	☐	OIB_CST	XFELD	CHAR	1	0	Oil BoM cost.(X=..from BoM header;' '=..from BoM components)
65	OIUSEREXIT	☐	GRPNO	GRPNO	NUMC	3	0	Number of the routine used for copying	*
66	REVSP	☐	RR_REVSP	RR_REVSP	CHAR	1	0	Revenue Distribution Type
67	REVEVTYP	☐	RR_REVEVTYP_CUST	RR_REVEVTYP_CUST	CHAR	1	0	Revenue Event Type (Customizing)
68	MILL_BATCH_REF	☐	MILL_BATCH_REF	XFELD	CHAR	1	0	MP Returns with Batch Reference
69	MILL_BATCH_SEL_D	☐	MILL_BATCH_SEL_DEF	MILL_BATCH_SEL_FLG	CHAR	1	0	Default Value for Indicator: Batch Selction Control
70	RBACONTROL	☐	RBACONTROL	RBACONTROL	CHAR	1	0	Control of Rules-Based ATP Check
71	.INCLU--AP	☐				0	0	append for BOS
72	LVART	☐	LVART	LVART	CHAR	2	0	Bill of services type
73	.INCLU--AP	☐				0	0	MILL_APP_TVAP
74	.INCLUDE	☐				0	0	MILL_INC_TVAP
75	MILL_SE_KKNMT	☐	MILL_SE_KKNMT	CHAR1	CHAR	1	0	Indicator for characteristic transfer frm cust-mat-info-rcd

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ERPS_WEC_ITEM_CATEGORY_DATA	FAKSP	TVFS	FAKSP	REF	C	CN
2	ERPS_WEC_ITEM_CATEGORY_DATA	FEHGR	TVUV	FEHGR	REF	C	CN
3	ERPS_WEC_ITEM_CATEGORY_DATA	FELDP	TVHF	FAWGR	REF	C	CN
4	ERPS_WEC_ITEM_CATEGORY_DATA	FFPRF	AD01C_PROF	PROFNR
5	ERPS_WEC_ITEM_CATEGORY_DATA	FPART	TFPLA	FPART	REF	C	CN
6	ERPS_WEC_ITEM_CATEGORY_DATA	KALSM	T683	KALSM	REF	C	CN
7	ERPS_WEC_ITEM_CATEGORY_DATA	MANDT	T000	MANDT	KEY	1	CN
8	ERPS_WEC_ITEM_CATEGORY_DATA	PARGR	TVPG	PARGR	REF	C	CN
9	ERPS_WEC_ITEM_CATEGORY_DATA	POSGR	TVHB	BIFGR	REF	C	CN
10	ERPS_WEC_ITEM_CATEGORY_DATA	PSGRP	TC04	CAPID	REF	C	CN
11	ERPS_WEC_ITEM_CATEGORY_DATA	PSTYV	TVPT	PSTYV	KEY	1	CN
12	ERPS_WEC_ITEM_CATEGORY_DATA	SCHEME_RMA	TVRMAS	SCHEME		1	CN
13	ERPS_WEC_ITEM_CATEGORY_DATA	SCHEME_VF	TVVFS	SCHEME
14	ERPS_WEC_ITEM_CATEGORY_DATA	SEGAL	T609A	SEGAL	REF	1	CN
15	ERPS_WEC_ITEM_CATEGORY_DATA	SOBKZ	T148	SOBKZ	REF	C	CN
16	ERPS_WEC_ITEM_CATEGORY_DATA	STGAP	TVSF	STGVB	REF	C	CN
17	ERPS_WEC_ITEM_CATEGORY_DATA	STRAT	T476	STRAT
18	ERPS_WEC_ITEM_CATEGORY_DATA	STSMA	TJ20	STSMA	REF	C	CN
19	ERPS_WEC_ITEM_CATEGORY_DATA	TXTGR	TTXG	TXTGR	REF	C	CN
20	ERPS_WEC_ITEM_CATEGORY_DATA	UVEIB	T609B	UVEIB		1	CN
21	ERPS_WEC_ITEM_CATEGORY_DATA	WKMAT	MARA	MATNR	REF	C	CN

History

Last changed by/on	SAP	20140121
SAP Release Created in