SAP ABAP Table V_BFOD_KNA (Generated Table for View)

Basic Data

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

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
3	BELNR	☑	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
4	GJAHR	☑	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
5	BUZEI	☑	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
6	OPZEI	☑	OPZEI	SUZEI	NUMC	2	0	Number of the Open Items within an FI Document
7	TLZEI	☑	TLZEI	SUZEI	NUMC	2	0	Number of a Clearing Item within an FI Open Item
8	AUZEI	☑	AUZEI	NUMC5	NUMC	5	0	Number of Breakdown by Account Assignments for FI Document
9	LAIDOP	☐	LAIDOP	AFTLF	NUMC	4	0	Posting Run for Open Item Allocation	RF180
10	LAIDAP	☐	LAIDAP	AFTLF	NUMC	4	0	Posting Run for Cleared Item Allocation	RF180
11	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
12	AUGDT	☐	AUGDT	DATUM	DATS	8	0	Clearing Date
13	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner
14	HKONT	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account
15	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
16	KORRK	☐	KORRK	SAKNR	CHAR	10	0	Adjustment Account
17	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
18	DMBTR	☐	DMBTR	WERT7	CURR	13	2	Amount in local currency
19	DMBE2	☐	DMBE2	WERT7	CURR	13	2	Amount in Second Local Currency
20	DMBE3	☐	DMBE3	WERT7	CURR	13	2	Amount in Third Local Currency
21	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area
22	PARGB	☐	PARGB	GSBER	CHAR	4	0	Trading partner's business area
23	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center
24	PPRCT	☐	PPRCTR	PRCTR	CHAR	10	0	Partner Profit Center
25	BRSCH	☐	BRSCH	BRSCH	CHAR	4	0	Industry key	T016
26	LAND1	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	T005
27	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
28	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
29	NAME2	☐	NAME2_GP	NAME	CHAR	35	0	Name 2
30	NAME3	☐	NAME3_GP	NAME	CHAR	35	0	Name 3
31	NAME4	☐	NAME4_GP	NAME	CHAR	35	0	Name 4
32	ORT01	☐	ORT01_GP	TEXT35	CHAR	35	0	City
33	RPMKR	☐	RPMKR	RPMKR	CHAR	5	0	Regional market
34	BRAN1	☐	BRAN1_D	BRACO	CHAR	10	0	Industry code 1	TBRC
35	BRAN2	☐	BRAN2	BRACO	CHAR	10	0	Industry code 2	TBRC
36	BRAN3	☐	BRAN3	BRACO	CHAR	10	0	Industry code 3	TBRC
37	BRAN4	☐	BRAN4	BRACO	CHAR	10	0	Industry code 4	TBRC
38	BRAN5	☐	BRAN5	BRACO	CHAR	10	0	Industry code 5	TBRC
39	UMSAT	☐	UMSAT	UMSAT	CURR	8	2	Annual sales
40	UMJAH	☐	UMJAH	JAHR	NUMC	4	0	Year For Which Sales are Given
41	UWAER	☐	UWAER	WAERS	CUKY	5	0	Currency of Sales Volume	TCURC

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_BFOD_KNA	BRAN1	TBRC	BRACO	KEY	1	CN
2	V_BFOD_KNA	BRAN2	TBRC	BRACO	KEY	1	CN
3	V_BFOD_KNA	BRAN3	TBRC	BRACO	KEY	1	CN
4	V_BFOD_KNA	BRAN4	TBRC	BRACO	KEY	1	CN
5	V_BFOD_KNA	BRAN5	TBRC	BRACO	KEY	1	CN
6	V_BFOD_KNA	BRSCH	T016	BRSCH	REF	C	CN
7	V_BFOD_KNA	BUKRS	T001	BUKRS
8	V_BFOD_KNA	KUNNR	KNA1	KUNNR
9	V_BFOD_KNA	LAIDAP	RF180	AFTLF
10	V_BFOD_KNA	LAIDOP	RF180	AFTLF
11	V_BFOD_KNA	LAND1	T005	LAND1	REF	C	CN
12	V_BFOD_KNA	LIFNR	LFA1	LIFNR	REF	C	CN
13	V_BFOD_KNA	MANDT	T000	MANDT
14	V_BFOD_KNA	UWAER	TCURC	WAERS	REF	1	C

History

Last changed by/on	SAP	20131127
SAP Release Created in