SAP ABAP Table JLPA (Sales Document: Partner)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JSD (Package) Appl. dev. R/3 Publishing Sales and Distribution System

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	JLPA	Table Relationship Diagram
Short Description	Sales Document: Partner

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	T000
2	JVBELN	☑	JVBELN	JVBELN	CHAR	10	0	IS-M: Settlement number	JLRK
3	JPOSNR	☑	JPOSNR	JPOSNR	NUMC	6	0	IS-M: Settlement item number	JLRP
4	PARVW	☑	PARVW	PARVW	CHAR	2	0	Partner Role	TPAR
5	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
6	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
7	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
8	PARNR	☐	PARNR	PARNR	NUMC	10	0	Number of contact person
9	ADRNR	☐	ADRNR	ADRNR	CHAR	10	0	Address	*
10	ABLAD	☐	ABLAD	TEXT25	CHAR	25	0	Unloading Point
11	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
12	ADRDA	☐	ADRDA	ADRDA	CHAR	1	0	Address indicator
13	XCPDK	☐	XCPDK	XFELD	CHAR	1	0	Indicator: Is the account a one-time account?

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JLPA	JPOSNR	JLRP	JPOSNR	KEY	1	CN
2	JLPA	JVBELN	JLRK	VBELN	KEY	1	CN
3	JLPA	KUNNR	KNA1	KUNNR	KEY	1	CN
4	JLPA	LAND1	T005	LAND1	KEY	1	CN
5	JLPA	LIFNR	LFA1	LIFNR	KEY	1	CN
6	JLPA	MANDT	T000	MANDT	KEY	1	CN
7	JLPA	PARVW	TPAR	PARVW	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in