SAP ABAP Table JLPAVB (Mix Structure for XJLPA/YJLPA)

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	INTTAB	Structure
Structure	JLPAVB	Table Relationship Diagram
Short Description	Mix Structure for XJLPA/YJLPA

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	.INCLUDE	☐				0	0	Sales Document: Partner
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	JVBELN	☐	JVBELN	JVBELN	CHAR	10	0	IS-M: Settlement number	JLRK
4	JPOSNR	☐	JPOSNR	JPOSNR	NUMC	6	0	IS-M: Settlement item number	JLRP
5	PARVW	☐	PARVW	PARVW	CHAR	2	0	Partner Role	TPAR
6	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
7	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
8	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
9	PARNR	☐	PARNR	PARNR	NUMC	10	0	Number of contact person
10	ADRNR	☐	ADRNR	ADRNR	CHAR	10	0	Address	*
11	ABLAD	☐	ABLAD	TEXT25	CHAR	25	0	Unloading Point
12	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
13	ADRDA	☐	ADRDA	ADRDA	CHAR	1	0	Address indicator
14	XCPDK	☐	XCPDK	XFELD	CHAR	1	0	Indicator: Is the account a one-time account?
15	.INCLUDE	☐				0	0	Sales Document Partner: Dynamic Part
16	UPDKZ	☐	UPDKZ_D	UPDKZ	CHAR	1	0	Update indicator
17	.INCLUDE	☐				0	0	Sales Document Partner: Dynamic Part
18	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
19	NRART	☐	NRART	NRART	CHAR	2	0	Type of partner number	*
20	FEHGR	☐	FEHGR	FEHGR	CHAR	2	0	Incompletion procedure for sales document	*
21	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
22	TELFX	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
23	TELTX	☐	TELTX	TEXT30	CHAR	30	0	Teletex number
24	TELX1	☐	TELX1	TEXT30	CHAR	30	0	Telex number
25	CNTPA	☐	CNT_PARVW	INT6	NUMC	6	0	Counter for partner functions
26	REFOBJTYPE	☐	SWO_OBJTYP	OJ_NAME	CHAR	10	0	Object Type	*
27	REFOBJKEY	☐	SWO_TYPEID	SWO_TYPEID	CHAR	70	0	Object key
28	REFLOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
29	STCD1	☐	STCD1	STCD1	CHAR	16	0	Tax Number 1
30	STCD2	☐	STCD2	STCD2	CHAR	11	0	Tax Number 2
31	STCD3	☐	STCD3	CHAR18	CHAR	18	0	Tax Number 3
32	STCD4	☐	STCD4	CHAR18	CHAR	18	0	Tax Number 4
33	STKZN	☐	STKZN	STKZN	CHAR	1	0	Natural Person
34	STCDT	☐	J_1ATOID	J_1ATOID	CHAR	2	0	Tax Number Type	*
35	J_1KFREPRE	☐	REPRES	REPRES	CHAR	10	0	Name of Representative
36	J_1KFTBUS	☐	GESTYP	GESTYP	CHAR	30	0	Type of Business	*
37	J_1KFTIND	☐	INDTYP	INDTYP	CHAR	30	0	Type of Industry	*

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in