SAP ABAP Table SPCIPPROFKEYS (Key fields and values of IP profiles)

Hierarchy

☛ ECC-DIMP (Software Component) DIMP
   ⤷ IS-AD-SPC-PR (Application Component) Provisioning
     ⤷ AD_SPC_PH3_IP (Package) SPEC 2000 Initial Provisioning

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	SPCIPPROFKEYS	Table Relationship Diagram
Short Description	Key fields and values of IP profiles

Delivery and Maintenance

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

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	PROFILE	☑	ADSPC_PROF	CHAR4	CHAR	4	0	Profile for creating master data from IP	SPCIPPROFILEKEYS
3	CLASSIFICATION	☐	CLASSIFICATION_DATA	XFELD	CHAR	1	0	IP: Classification Data
4	SALES	☐	SALES_DATA	XFELD	CHAR	1	0	IP: Sales Data
5	PURCHASING	☐	PURCHASING_DATA	XFELD	CHAR	1	0	IP: Purchasing Data
6	MRP	☐	IP_MRP_DATA	XFELD	CHAR	1	0	IP: MRP Data
7	FORECASTING	☐	FORECASTING_DATA	XFELD	CHAR	1	0	IP: Forecasting Data
8	WORK_SCHEDULING	☐	WORK_SCHEDULING_DATA	XFELD	CHAR	1	0	IP: Work Scheduling Data
9	PRODUCTION_RES	☐	PRODUCTION_RES_DATA	XFELD	CHAR	1	0	IP: Production Resource/Tool Data
10	STORAGE	☐	STORAGE_DATA	XFELD	CHAR	1	0	IP: Storage Data
11	WAREHOUSE_MGT	☐	WAREHOUSE_MGT_DATA	XFELD	CHAR	1	0	IP: Warehouse Management Data
12	QUALITY_MGT	☐	QUALITY_MGT_DATA	XFELD	CHAR	1	0	IP: Quality Management Data
13	ACCOUNTING	☐	ACCOUNTING_DATA	XFELD	CHAR	1	0	IP: Accounting Data
14	COSTING	☐	COSTING_DATA	XFELD	CHAR	1	0	IP: Costing Data
15	INFO_RECORD	☐	INFO_RECORD	XFELD	CHAR	1	0	IP: Info records
16	CONDITION_RECORD	☐	COND_RECORD_FLAG	XFELD	CHAR	1	0	IP: Condition records
17	LANGUAGE	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
18	PLANT	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
19	STLOC	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
20	VALAREA	☐	BWKEY	BWKEY	CHAR	4	0	Valuation area	T001K
21	WHNUM	☐	LGNUM	LGNUM	CHAR	3	0	Warehouse Number / Warehouse Complex	T300
22	STTYPE	☐	LGTYP	LGTYP	CHAR	3	0	Storage Type	T301
23	SALESORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
24	DISCH	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
25	PURORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
26	INFRECCAT	☐	ESOKZ	ESOKZ	CHAR	1	0	Purchasing info record category
27	COND_TABLE	☐	KOTABNR	KOTABNR	NUMC	3	0	Condition table	T681
28	APPLICATION	☐	KAPPL	KAPPL	CHAR	2	0	Application	T681A
29	COND_UNP	☐	KSCHA	KSCHL	CHAR	4	0	Condition Type	T685
30	COND_DISC	☐	KSCHA	KSCHL	CHAR	4	0	Condition Type	T685

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SPCIPPROFKEYS	APPLICATION	T681A	KAPPL	REF	1	CN
2	SPCIPPROFKEYS	CLIENT	T000	MANDT	KEY	1	CN
3	SPCIPPROFKEYS	COND_DISC	T685	KSCHL	REF	1	CN
4	SPCIPPROFKEYS	COND_TABLE	T681	KOTABNR	REF	1	CN
5	SPCIPPROFKEYS	COND_UNP	T685	KSCHL	REF	1	CN
6	SPCIPPROFKEYS	DISCH	TVTW	VTWEG		1	CN
7	SPCIPPROFKEYS	LANGUAGE	T002	SPRAS	REF	1	CN
8	SPCIPPROFKEYS	PLANT	T001W	WERKS	REF	1	CN
9	SPCIPPROFKEYS	PROFILE	SPCIPPROFILEKEYS	PROFILE	KEY	1	C
10	SPCIPPROFKEYS	PURORG	T024E	EKORG	REF	1	CN
11	SPCIPPROFKEYS	SALESORG	TVKO	VKORG		1	CN
12	SPCIPPROFKEYS	STLOC	T001L	LGORT	KEY	1	CN
13	SPCIPPROFKEYS	STTYPE	T301	LGTYP		1	CN
14	SPCIPPROFKEYS	VALAREA	T001K	BWKEY		1	CN
15	SPCIPPROFKEYS	WHNUM	T300	LGNUM		1	CN

History

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