SAP ABAP View V_BFOD_KNA (Receivables/customer data)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ KE1 (Package) Profit Center Accounting

Basic Data

View Type	D	Database View
Database View	V_BFOD_KNA
Short Description	Receivables/customer data
Root table	BFOD_A	FI Subsequent BA/PC Adjustment: Customer Items

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	BFOD_A	BFOD_A
2	KNA1

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	BFOD_A	KUNNR	JL	EQ				0	0
2	KNA1	KUNNR	JR	EQ			AND	0	0
3	BFOD_A	MANDT	JL	EQ				0	0
4	KNA1	MANDT	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	BFOD_A	MANDT		☐	MANDT	☐	Client
2	BUKRS	BFOD_A	BUKRS		☐	BUKRS	☐	Company Code
3	BELNR	BFOD_A	BELNR		☐	BELNR_D	☐	Accounting Document Number
4	GJAHR	BFOD_A	GJAHR		☐	GJAHR	☐	Fiscal Year
5	BUZEI	BFOD_A	BUZEI		☐	BUZEI	☐	Number of Line Item Within Accounting Document
6	OPZEI	BFOD_A	OPZEI		☐	OPZEI	☐	Number of the Open Items within an FI Document
7	TLZEI	BFOD_A	TLZEI		☐	TLZEI	☐	Number of a Clearing Item within an FI Open Item
8	AUZEI	BFOD_A	AUZEI		☐	AUZEI	☐	Number of Breakdown by Account Assignments for FI Document
9	LAIDOP	BFOD_A	LAIDOP		☐	LAIDOP	☐	Posting Run for Open Item Allocation
10	LAIDAP	BFOD_A	LAIDAP		☐	LAIDAP	☐	Posting Run for Cleared Item Allocation
11	BUDAT	BFOD_A	BUDAT		☐	BUDAT	☐	Posting Date in the Document
12	AUGDT	BFOD_A	AUGDT		☐	AUGDT	☐	Clearing Date
13	VBUND	BFOD_A	VBUND		☐	RASSC	☐	Company ID of trading partner
14	HKONT	BFOD_A	HKONT		☐	HKONT	☐	General Ledger Account
15	KUNNR	BFOD_A	KUNNR		☐	KUNNR	☐	Customer Number
16	KORRK	BFOD_A	KORRK		☐	KORRK	☐	Adjustment Account
17	SHKZG	BFOD_A	SHKZG		☐	SHKZG	☐	Debit/Credit Indicator
18	DMBTR	BFOD_A	DMBTR		☐	DMBTR	☐	Amount in local currency
19	DMBE2	BFOD_A	DMBE2		☐	DMBE2	☐	Amount in Second Local Currency
20	DMBE3	BFOD_A	DMBE3		☐	DMBE3	☐	Amount in Third Local Currency
21	GSBER	BFOD_A	GSBER		☐	GSBER	☐	Business Area
22	PARGB	BFOD_A	PARGB		☐	PARGB	☐	Trading partner's business area
23	PRCTR	BFOD_A	PRCTR		☐	PRCTR	☐	Profit Center
24	PPRCT	BFOD_A	PPRCT		☐	PPRCTR	☐	Partner Profit Center
25	BRSCH	KNA1	BRSCH		☐	BRSCH	☐	Industry key
26	LAND1	KNA1	LAND1		☐	LAND1_GP	☐	Country Key
27	LIFNR	KNA1	LIFNR		☐	LIFNR	☐	Account Number of Vendor or Creditor
28	NAME1	KNA1	NAME1		☐	NAME1_GP	☐	Name 1
29	NAME2	KNA1	NAME2		☐	NAME2_GP	☐	Name 2
30	NAME3	KNA1	NAME3		☐	NAME3_GP	☐	Name 3
31	NAME4	KNA1	NAME4		☐	NAME4_GP	☐	Name 4
32	ORT01	KNA1	ORT01		☐	ORT01_GP	☐	City
33	RPMKR	KNA1	RPMKR		☐	RPMKR	☐	Regional market
34	BRAN1	KNA1	BRAN1		☐	BRAN1_D	☐	Industry code 1
35	BRAN2	KNA1	BRAN2		☐	BRAN2	☐	Industry code 2
36	BRAN3	KNA1	BRAN3		☐	BRAN3	☐	Industry code 3
37	BRAN4	KNA1	BRAN4		☐	BRAN4	☐	Industry code 4
38	BRAN5	KNA1	BRAN5		☐	BRAN5	☐	Industry code 5
39	UMSAT	KNA1	UMSAT		☐	UMSAT	☐	Annual sales
40	UMJAH	KNA1	UMJAH		☐	UMJAH	☐	Year For Which Sales are Given
41	UWAER	KNA1	UWAER		☐	UWAER	☐	Currency of Sales Volume

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20131127
SAP Release Created in