SAP ABAP Table VPIT_KNA1 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	VPIT_KNA1	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster	KNA1
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	KUNNR	☑	KUNNR	KUNNR	CHAR	10	0	Customer Number
3	LAND1	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	T005
4	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
5	NAME2	☐	NAME2_GP	NAME	CHAR	35	0	Name 2
6	ORT01	☐	ORT01_GP	TEXT35	CHAR	35	0	City
7	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
8	TELF1	☐	TELF1	TEXT16	CHAR	16	0	First telephone number
9	TELFX	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
10	AUFSD	☐	AUFSD_X	KAUFS	CHAR	2	0	Central order block for customer	TVAST
11	FAKSD	☐	FAKSD_X	FAKSP	CHAR	2	0	Central billing block for customer	TVFS
12	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
13	LIFSD	☐	LIFSD_X	LIFSP	CHAR	2	0	Central delivery block for the customer	TVLS
14	SPERR	☐	SPERB_X	XFELD	CHAR	1	0	Central posting block
15	SPERZ	☐	SPERZ	XFELD	CHAR	1	0	Payment Block
16	KNURL	☐	URL	TEXT132	CHAR	132	0	Uniform resource locator

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VPIT_KNA1	AUFSD	TVAST	AUFSP	REF	C	CN
2	VPIT_KNA1	FAKSD	TVFS	FAKSP	REF	C	CN
3	VPIT_KNA1	LAND1	T005	LAND1	REF	C	CN
4	VPIT_KNA1	LIFNR	LFA1	LIFNR	REF	C	CN
5	VPIT_KNA1	LIFSD	TVLS	LIFSP	REF	C	CN
6	VPIT_KNA1	MANDT	T000	MANDT	KEY	1	CN
7	VPIT_KNA1	REGIO	T005S	BLAND	REF	C	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in