SAP ABAP View JGVDB_EWB (IS-M/SD: DB View Retailer - Accounting)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M-MD (Application Component) Master Data
     ⤷ JMDGEN (Package) Generic Master Data Media

Basic Data

View Type	D	Database View
Database View	JGVDB_EWB
Short Description	IS-M/SD: DB View Retailer - Accounting
Root table	JGTGPNR	IS-M: Central Business Partner Table

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	JGTGPNR	JGTGPNR
2	KNA1
3	KNB1

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	KNA1	MANDT	JL	EQ				0	0
2	JGTGPNR	MANDT	JR	EQ			AND	0	0
3	KNA1	KUNNR	JL	EQ				0	0
4	JGTGPNR	KUNNR	JR	EQ			AND	0	0
5	KNA1	MANDT	JL	EQ				0	0
6	KNB1	MANDT	JR	EQ			AND	0	0
7	KNA1	KUNNR	JL	EQ				0	0
8	KNB1	KUNNR	JR	EQ			AND	0	0
9	JGTGPNR	XEUW	NOT	EQ	' '			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	JGTGPNR	MANDT		☐	MANDT	☐	Client
2	GPNR	JGTGPNR	GPNR		☐	GPNR	☐	IS-M: Business Partner Key
3	BUKRS	KNB1	BUKRS		☐	BUKRS	☐	Company Code
4	XGPLOE	JGTGPNR	XGPLOE		☐	JXLV_GP	☐	IS-M: Deletion Flag for General Business Partner
5	XGPLOEKZ	JGTGPNR	XGPLOEKZ		☐	XLOESCHKZ	☐	IS-M: Deletion Indicator (Role-Specific)
6	XGPSPE	JGTGPNR	XGPSPE		☐	XGPSPE	☐	IS-M/SD: Lock Indicator for General Business Partner
7	JKTOKD	JGTGPNR	JKTOKD		☐	JKTOKD	☐	IS-M: Business Partner Account Group
8	MAILN	JGTGPNR	MAILN		☐	JMAILN	☐	IS-M: Mail Address
9	BERUFSL	JGTGPNR	BERUFSL		☐	BERUFSL	☐	IS-M: Occupation
10	JBRSCH	JGTGPNR	BRSCH		☐	BRSCH	☐	Industry key
11	JGEBDAT	JGTGPNR	JGEBDAT		☐	JGEBDAT	☐	IS-M: Date of Birth of a Business Partner
12	GESCH	JGTGPNR	GESCH		☐	JGESCHL	☐	IS-M: Gender Key
13	JFAMST	JGTGPNR	JFAMST		☐	JFAMST	☐	IS-M: Business Partner's Marital Status
14	GPHERK	JGTGPNR	GPHERK		☐	GPHERK	☐	IS-M: Business Partner Origin
15	XNATUR	JGTGPNR	XNATUR		☐	XNATUR	☐	IS-M: Natural Person Indicator
16	XVERMSACH	JGTGPNR	XVERMSACH		☐	XVERMSACH	☐	IS-M: BP Authorized to Receive Gifts
17	XOHNE	JGTGPNR	XOHNE		☐	XCPDK	☐	Indicator: Is the account a one-time account?
18	XDEBI	JGTGPNR	XDEBI		☐	JXDEBI	☐	IS-M: Indicator: Customer Exists
19	KUNNR	JGTGPNR	KUNNR		☐	JKUNNR	☐	IS-M: Customer Number in Previous System
20	FKUNNR	JGTGPNR	FKUNNR		☐	JFKUNNR	☐	IS-M: Customer Number in Non-SAP System
21	XKREDI	JGTGPNR	XKREDI		☐	XKREDI	☐	IS-M: Indicator: Vendor Exists
22	LIFNR	JGTGPNR	LIFNR		☐	JLIFNR	☐	IS-M: Vendor Number in Previous System
23	FLIFNR	JGTGPNR	FLIFNR		☐	JFLIFNR	☐	IS-M: Vendor Number in Non-SAP System
24	XMITARB	JGTGPNR	XMITARB		☐	XMITARB	☐	IS-M: Employee Indicator
25	PERNR	JGTGPNR	PERNR		☐	JPERNR2	☐	IS-M: Personnel Number
26	XNOWERB	JGTGPNR	XNOWERB		☐	XNOWERB	☐	IS-M: No Advertising
27	XEUW	JGTGPNR	XEUW		☐	XEUW	☐	IS-M: Retailer Indicator
28	XEUWLOEV	JGTGPNR	XEUWLOEV		☐	JXLV_EW	☐	IS-M: Deletion Flag for Retailer
29	XEUWLOEKZ	JGTGPNR	XEUWLOEKZ		☐	XLOESCHKZ	☐	IS-M: Deletion Indicator (Role-Specific)
30	XEUWSPE	JGTGPNR	XEUWSPE		☐	XEWSPE	☐	IS-M/SD: Lock Indicator - Retailer
31	KTOKD	KNA1	KTOKD		☐	KTOKD	☐	Customer Account Group
32	LOCCO	KNA1	LOCCO		☐	LOCCO	☐	City Coordinates
33	LOEVM	KNA1	LOEVM		☐	LOEVM_X	☐	Central Deletion Flag for Master Record
34	COUNC	KNA1	COUNC		☐	COUNC	☐	County Code
35	CITYC	KNA1	CITYC		☐	CITYC	☐	City Code
36	SORTL	KNA1	SORTL		☐	SORTL	☐	Sort field
37	SPERR	KNA1	SPERR		☐	SPERB_X	☐	Central posting block
38	SPRAS	KNA1	SPRAS		☐	SPRAS	☐	Language Key
39	STCD1	KNA1	STCD1		☐	STCD1	☐	Tax Number 1
40	STCD2	KNA1	STCD2		☐	STCD2	☐	Tax Number 2
41	STKZA	KNA1	STKZA		☐	STKZA	☐	Indicator: Business Partner Subject to Equalization Tax?
42	STKZU	KNA1	STKZU		☐	STKZU	☐	Liable for VAT
43	STCEG	KNA1	STCEG		☐	STCEG	☐	VAT Registration Number
44	GFORM	KNA1	GFORM		☐	GFORM	☐	Legal status
45	STKZN	KNA1	STKZN		☐	STKZN	☐	Natural Person
46	SPERR_B	KNB1	SPERR		☐	SPERB_B	☐	Posting block for company code
47	LOEVM_B	KNB1	LOEVM		☐	LOEVM_B	☐	Deletion Flag for Master Record (Company Code Level)
48	ZUAWA	KNB1	ZUAWA		☐	DZUAWA	☐	Key for sorting according to assignment numbers
49	BUSAB	KNB1	BUSAB		☐	BUSAB	☐	Accounting clerk
50	AKONT	KNB1	AKONT		☐	AKONT	☐	Reconciliation Account in General Ledger
51	ZAHLS	KNB1	ZAHLS		☐	DZAHLS	☐	Block Key for Payment
52	ZTERM	KNB1	ZTERM		☐	DZTERM	☐	Terms of payment key
53	ZSABE	KNB1	ZSABE		☐	DZSABE_D	☐	User at customer
54	KVERM	KNB1	KVERM		☐	KVERM	☐	Memo
55	ERDAT	KNB1	ERDAT		☐	ERDAT_RF	☐	Date on which the Record Was Created
56	ERNAM	KNB1	ERNAM		☐	ERNAM_RF	☐	Name of Person who Created the Object
57	BEGRU	KNB1	BEGRU		☐	BRGRU	☐	Authorization Group
58	KNRZE	KNB1	KNRZE		☐	KNRZE	☐	Head office account number (in branch accounts)
59	KNRZB	KNB1	KNRZB		☐	KNRZB	☐	Account number of an alternative payer
60	ZAMIM	KNB1	ZAMIM		☐	DZAMIM	☐	Indicator: Payment notice to customer (with cleared items)?
61	ZAMIV	KNB1	ZAMIV		☐	DZAMIV	☐	Indicator: payment notice to sales department?
62	ZAMIR	KNB1	ZAMIR		☐	DZAMIR	☐	Indicator: payment notice to legal department?
63	ZAMIB	KNB1	ZAMIB		☐	DZAMIB	☐	Indicator: Payment notice to the accounting department ?
64	ZAMIO	KNB1	ZAMIO		☐	DZAMIO	☐	Indicator: payment notice to customer (w/o cleared items)?
65	ZWELS	KNB1	ZWELS		☐	DZWELS	☐	List of the Payment Methods to be Considered
66	XVERR	KNB1	XVERR		☐	XVERR_KNB1	☐	Indicator: Clearing between customer and vendor ?
67	WAKON	KNB1	WAKON		☐	WAKON	☐	Terms of payment key for bill of exchange charges
68	VZSKZ	KNB1	VZSKZ		☐	VZSKZ	☐	Interest calculation indicator
69	ZINDT	KNB1	ZINDT		☐	DZINDT	☐	Key date of the last interest calculation
70	ZINRT	KNB1	ZINRT		☐	DZINRT	☐	Interest calculation frequency in months
71	EIKTO	KNB1	EIKTO		☐	EIKTO_D	☐	Our account number at customer
72	FDGRV	KNB1	FDGRV		☐	FDGRV	☐	Planning group
73	VRBKZ	KNB1	VRBKZ		☐	VRBKZ	☐	Export credit insurance institution number
74	VLIBB	KNB1	VLIBB		☐	VLIBB	☐	Amount Insured
75	VRSZL	KNB1	VRSZL		☐	VRSZL	☐	Insurance lead months
76	VRSPR	KNB1	VRSPR		☐	VRSPR	☐	Deductible percentage rate
77	VRSNR	KNB1	VRSNR		☐	VRSNR	☐	Insurance number
78	VERDT	KNB1	VERDT		☐	VERDT	☐	Insurance validity date
79	PERKZ	KNB1	PERKZ		☐	PERKZ_KNB1	☐	Collective invoice variant
80	XDEZV	KNB1	XDEZV		☐	XDEZV	☐	Indicator: Local processing?
81	XAUSZ	KNB1	XAUSZ		☐	XAUSZ	☐	Indicator for periodic account statements
82	WEBTR	KNB1	WEBTR		☐	WEBTR	☐	Bill of exchange limit (in local currency)
83	REMIT	KNB1	REMIT		☐	REMIT	☐	Next payee
84	DATLZ	KNB1	DATLZ		☐	DATLZ	☐	Date of the last interest calculation run
85	XZVER	KNB1	XZVER		☐	XZVER	☐	Indicator: Record Payment History ?
86	TOGRU	KNB1	TOGRU		☐	TOGRU	☐	Tolerance group for the business partner/G/L account
87	KULTG	KNB1	KULTG		☐	KULTG	☐	Probable time until check is paid
88	HBKID	KNB1	HBKID		☐	HBKID	☐	Short key for a house bank
89	XPORE	KNB1	XPORE		☐	XPORE	☐	Indicator: Pay all items separately ?
90	BLNKZ	KNB1	BLNKZ		☐	BLNKZ	☐	Subsidy Indicator for Determining the Reduction Rates
91	ALTKN	KNB1	ALTKN		☐	ALTKN	☐	Previous Master Record Number
92	ZGRUP	KNB1	ZGRUP		☐	DZGRUP	☐	Key for Payment Grouping
93	URLID	KNB1	URLID		☐	URLID	☐	Short Key for Known/Negotiated Leave
94	MGRUP	KNB1	MGRUP		☐	MGRUP	☐	Key for dunning notice grouping

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