SAP ABAP Table PSPL (Index project -> planned order)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MD03 (Package) Appl. development R/3 MPS/determin. requirements planning

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	PSPL	Table Relationship Diagram
Short Description	Index project -> planned order

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	PSPEL	☑	PS_POSNR	PS_POSNR	NUMC	8	0	WBS Element	*
3	PLNUM	☑	PLNUM	PLNUM	CHAR	10	0	Planned order number	PLAF
4	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	T163K
5	KZVBR	☐	KZVBR	KZVBR	CHAR	1	0	Consumption posting
6	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
7	KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
8	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
9	KDEIN	☐	KDEIN	NUM04	NUMC	4	0	Delivery schedule for sales order

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PSPL	KDAUF	VBUK	VBELN	KEY	1	CN
2	PSPL	KNTTP	T163K	KNTTP	KEY	1	CN
3	PSPL	PLNUM	PLAF	PLNUM	KEY	1	CN
4	PSPL	SOBKZ	T148	SOBKZ	KEY	1	CN

History

Last changed by/on	SAP	20050411
SAP Release Created in