SAP ABAP Table VWSPRT1 (Sec. partner data (debtor-issuer) (SPRT1/SANS1/PARZJ))

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-SR-DE (Application Component) Germany
     ⤷ VVSRG (Package) Statutory Reporting Germany

Basic Data

Table Category	INTTAB	Structure
Structure	VWSPRT1	Table Relationship Diagram
Short Description	Sec. partner data (debtor-issuer) (SPRT1/SANS1/PARZJ)

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	Partner data DA (debtor) SPRT1/SANS1/PARZJ
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	.INCLUDE	☐				0	0	Address formating function module transfer structure
4	ANRED	☐	ANRED	TEXT15	CHAR	15	0	Title
5	NAME1	☐	NAME1_ADRS	TEXT40	CHAR	40	0	Name 1 of an address
6	NAME2	☐	NAME2_ADRS	TEXT40	CHAR	40	0	Name 2 of an address
7	NAME3	☐	NAME3_ADRS	TEXT40	CHAR	40	0	Name 3 of an address
8	NAME4	☐	NAME4_ADRS	TEXT40	CHAR	40	0	Name 4 of an address
9	STRAS	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
10	PFACH	☐	PFACH_BAS	PFACH	CHAR	10	0	PO box
11	PSTL2	☐	PSTL2_BAS	PSTLZ	CHAR	10	0	PO Box postal code
12	PFORT	☐	PFORT_ADRS	TEXT40	CHAR	40	0	PO Box city
13	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
14	PSTLZ	☐	PSTLZ_BAS	PSTLZ	CHAR	10	0	Postal code
15	ORT01	☐	ORT01_GP	TEXT35	CHAR	35	0	City
16	ORT02	☐	ORT01_GP	TEXT35	CHAR	35	0	City
17	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
18	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
19	INLND	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
20	ANZZL	☐	ANZEI	ANZEI	DEC	2	0	Number of lines in address
21	PRIOR	☐	PRITY_ADRS	CHAR9	CHAR	9	0	Address lines priority
22	WAREN	☐	WAREN	WAREN	CHAR	1	0	Delivery address ID
23	LINE0	☐	LINES	LINES	CHAR	80	0	Address line
24	LINE1	☐	LINES	LINES	CHAR	80	0	Address line
25	LINE2	☐	LINES	LINES	CHAR	80	0	Address line
26	LINE3	☐	LINES	LINES	CHAR	80	0	Address line
27	LINE4	☐	LINES	LINES	CHAR	80	0	Address line
28	LINE5	☐	LINES	LINES	CHAR	80	0	Address line
29	LINE6	☐	LINES	LINES	CHAR	80	0	Address line
30	LINE7	☐	LINES	LINES	CHAR	80	0	Address line
31	LINE8	☐	LINES	LINES	CHAR	80	0	Address line
32	LINE9	☐	LINES	LINES	CHAR	80	0	Address line
33	LINEK	☐	LINES	LINES	CHAR	80	0	Address line
34	LINED	☐	LINES	LINES	CHAR	80	0	Address line
35	LINED0	☐	LINES	LINES	CHAR	80	0	Address line
36	PO_BOX_LOBBY	☐	AD_PO_BOX_LBY	TEXT40	CHAR	40	0	PO Box Lobby
37	DELI_SERV_TYPE	☐	AD_DELIVERY_SERVICE_TYPE	AD_DELIVERY_SERVICE_TYPE	CHAR	4	0	Type of Delivery Service
38	DELI_SERV_NUMBER	☐	AD_DELIVERY_SERVICE_NUMBER	CHAR10	CHAR	10	0	Number of Delivery Service
39	COUNTY	☐	AD_COUNTY	TEXT40	CHAR	40	0	County
40	TOWNSHIP	☐	AD_TOWNSHIP	TEXT40	CHAR	40	0	Township
41	PARTNR	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
42	STAFF_REF	☐	BP_STAFF_R	XFELD	CHAR	1	0	Employee
43	NATION	☐	BP_CNTR_N	LAND1	CHAR	3	0	Nationality	*
44	ROLETYP	☐	BU_RLTYP	BU_RLTYP	CHAR	6	0	BDT: Object part	*
45	IND_SECTOR	☐	BU_INDSECT	BU_INDSECT	CHAR	10	0	Industry sector	*
46	LEGAL_ENTY	☐	BU_LEGENTY	BU_LEGENTY	CHAR	2	0	BP: Legal form of organization	*
47	LEGAL_ORG	☐	BU_LEGAL_ORG	BU_LEGAL_ORG	CHAR	2	0	Legal Entity of Organization	*
48	COMP_RE	☐	BP_COMP_RE	BP_COMP_RE	CHAR	1	0	Organization Relationship

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VWSPRT1	MANDT	T000	MANDT

History

Last changed by/on	SAP	20140121
SAP Release Created in