SAP ABAP Table JHVVAABK (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JHVVAABK	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	VTNR	☑	ABS_VTNR	ABS_VTNR	NUMC	6	0	IS-M: Contract Number	JHTVAABK
3	ABRGNR	☑	ABRGNR	ABRGNR	NUMC	4	0	IS-M/AM: Contract Settlement Number	JHTVAABK
4	REGULIERER	☑	REGULIERER	GPNR	CHAR	10	0	IS-M: Payer	JJVDB_MK
5	INSERENT	☑	INSERENT	GPNR	CHAR	10	0	IS-M: Advertiser	JJVDB_MK_FK
6	TRENNUNG	☑	JH_TRENNUNG	CHAR10	CHAR	10	0	IS-M/AM: Split Criteria for Payer/Advertiser Records
7	AVKORG	☑	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
8	AVTWEG	☑	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
9	ASPART	☑	SPART	SPART	CHAR	2	0	Division	TSPA
10	AAB_WEINH	☐	AB_WEINH	WAERS	CUKY	5	0	IS-M: Currency Key for Contract	TCURC
11	AB_BRUTTO	☐	AB_BRUTTO	WERTV8	CURR	15	2	IS-M: Contract Gross
12	ABRMM	☐	ABRMM	SAEMM	QUAN	12	3	IS-M: Quantity (mm, Pages, Seconds)
13	ABRME	☐	ABRME	SAEME	DEC	5	0	IS-M: Number
14	ABR_STATUS	☐	ABR_STATUS	ABR_STATUS	CHAR	1	0	IS-M: Contract Settlement Status
15	STORNOGRD	☐	STOGRD_PAM	STOGRD_PAM	CHAR	3	0	IS-M: Cancellation Reason	TJHSTOG
16	FAKSP	☐	FAKSP	FAKSP	CHAR	2	0	Lock	TVFS
17	DATEAAFS	☐	DATEAAFS	DATUM	DATS	8	0	IS-M/AM: Billing Block Date for Contract Settlement
18	RAB_IST	☐	RAB_IST	WERTV7	CURR	13	2	IS-M: Contract Discount Granted to Date
19	RAB_SOLL	☐	RAB_SOLL	WERTV7	CURR	13	2	IS-M: Current Contract Discount
20	BON_IST	☐	BON_IST	WERTV7	CURR	13	2	IS-M: Contract Bonus Granted to Date
21	BON_SOLL	☐	BON_SOLL	WERTV7	CURR	13	2	IS-M/AM: Current Contract Bonus
22	ABETR_IST	☐	ABETR_IST	WERTV8	CURR	15	2	IS-M: Contract Settlement Amount Paid to Date
23	ABETR_SOLL	☐	ABETR_SOLL	WERTV8	CURR	15	2	IS-M: Current Contract Settlement Amount
24	GL_BETRAG	☐	GL_BETRAG	WERTV8	CURR	15	2	IS-M: Credit/Debit Memo Amount for Contract Settlement
25	R_DATUM	☐	R_DATUM	DATUM	DATS	8	0	IS-M: Date of Last Interim/Final Settlement
26	MNGABRM	☐	MNGABRM	ABS_MENGE	QUAN	12	3	IS-M: Quantity for settlement
27	MEINHABRM	☐	AB_MEINH	MEINS	UNIT	3	0	IS-M: Contract Units of Measurement
28	UMSABRM	☐	UMSABRM	WERTV8	CURR	15	2	IS-M: Sales Volume for Contract Settlement
29	WEINHABRM	☐	AB_WEINH	WAERS	CUKY	5	0	IS-M: Currency Key for Contract	TCURC
30	AERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
31	AERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
32	AERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
33	AAENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
34	AAENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
35	AAENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
36	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
37	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVKOV
38	SPART	☐	SPART	SPART	CHAR	2	0	Division	TVTA
39	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVKBZ
40	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
41	XORG_ERG	☐	XORG_ERG	XFELD	CHAR	1	0	IS-M: Contract has Explicitly Assigned Sales Areas
42	ABINHNR	☐	ABINHNR	GPNR	CHAR	10	0	IS-M/AM: Number of Contract Holder	JGTGPNR
43	IHREZ	☐	IHREZ	TEXT12	CHAR	12	0	Your Reference
44	KDMI	☐	ISM_CP_CNTRCT_HLDR	BU_PARTNER	CHAR	10	0	IS-M: Contact Person for Contract Holder
45	XQUASI	☐	XQUASI	XFELD	CHAR	1	0	IS-M: System Contracts Yes/No Indicator
46	XGE_GESCH	☐	XGE_GESCH	XFELD	CHAR	1	0	IS-M: Barter Deal Indicator
47	XKUBO	☐	XKUBO	XFELD	CHAR	1	0	IS-M: Indicator Customer Bonus Contract
48	XTO_BEST	☐	XTO_BEST	XFELD	CHAR	1	0	IS-M: "Confirnation Required" Indicator
49	XTO_WARN	☐	XTO_WARN	XFELD	CHAR	1	0	IS-M: Advance Warning Indicator
50	XWARN_GEN	☐	XWARN_GEN	XFELD	CHAR	1	0	IS-M: Generate non-fulfillment warning
51	XTO_HINW	☐	XTO_HINW	XFELD	CHAR	1	0	IS-M: Generate end note indicator
52	XHINW_GEN	☐	XHINW_GEN	XFELD	CHAR	1	0	IS-M: Generate validity period end note indicator
53	XBESTK	☐	XBESTK	XFELD	CHAR	1	0	IS-M: Contract Status (Created/Confirmed)
54	B_DATUM	☐	B_DATUM	DATUM	DATS	8	0	IS-M: Confirmation Date
55	XNEUSTAT	☐	XNEUSTAT	XFELD	CHAR	1	0	IS-M: Renewal status (renewed y/n)
56	E_DATUM	☐	ER_DATUM		DATS	8	0	IS-M: Contract Renewal Date
57	V_NUMMER	☐	V_NUMMER	SYNUM01	NUMC	1	0	IS-M: Current Number of Advance Warning
58	V_DATUM	☐	V_DATUM	DATUM	DATS	8	0	IS-M: Advance Warning Date
59	XENDK	☐	XENDK	XFELD	CHAR	1	0	IS-M: Status of runtime end note
60	H_DATUM	☐	H_DATUM	DATUM	DATS	8	0	IS-M: Date of End of Validity Period Note (Contract)
61	XABRSPERR	☐	XABRSPERR	XFELD	CHAR	1	0	IS-M: Settlement Block
62	ABRECHK	☐	ABRECHK	ABRECHK	CHAR	1	0	IS-M: Settlement Type
63	XABR	☐	XABR	XFELD	CHAR	1	0	IS-M: Perform Settlement Yes/No Indicator
64	EABR_NACHL	☐	EABR_NACHL	SYNUM02	NUMC	2	0	IS-M: Time of Final Settlement After Runtime (in Months)
65	XLOEVM	☐	LOEVM_ISP	XFELD	CHAR	1	0	Deletion Flag for Master Data in Media Sales & Distribution
66	XLOEKZ	☐	LOEKZ_ISP	XFELD	CHAR	1	0	Deletion Indicator for Master Data in Media Sales & Dist.
67	XLFZAEN	☐	XLFZAEN	XFELD	CHAR	1	0	IS-M: Validity Period in Contract Changed
68	LFZBEG	☐	LFZBEG	DATUM	DATS	8	0	IS-M: Start of Validity Period
69	LFZEND	☐	LFZEND	DATUM	DATS	8	0	IS-M: End of Validity Period
70	B_AUSR	☐	ABSCHL_BEG	ABSCHL_BEG	CHAR	1	0	IS-M: Rule for Contract Start	TJJV14
71	E_AUSR	☐	ABSCHL_END	ABSCHL_END	CHAR	1	0	IS-M: Rule for Contract End	TJJV15
72	XABE	☐	XABSCH_ERN	XFELD	CHAR	1	0	IS-M: Automatic Contract Renewal?
73	FVTNR	☐	ABS_FVTNR	ABS_VTNR	NUMC	6	0	IS-M: Number of Follow-On Contract	JHTVKO
74	VVTNR	☐	ABS_VVTNR	ABS_VTNR	NUMC	6	0	IS-M: Predecessor to Current Contract	JHTVKO
75	XNOBEL	☐	XNOBEL	XFELD	CHAR	1	0	IS-M: Do Not Perform Subsequent Debit
76	XZWABR	☐	XZWABR	XFELD	CHAR	1	0	IS-M: Perform Interim Settlement Automatically
77	XBEARB	☐	XGENEHM	XFELD	CHAR	1	0	IS-M: Postprocess/Approve Contract
78	ABS_NACHB	☐	ABS_NACHB	NATXT	CHAR	73	0	IS-M: Post-Editing Reason
79	XKONZERN	☐	XKONZERN	XFELD	CHAR	1	0	IS-M: Group Contract
80	XINSKUM	☐	XINSKUM	XFELD	CHAR	1	0	IS-M: Cumulation Rule for Contract Assignments
81	ABS_TYP1	☐	ABS_TYP	ABS_TYP	CHAR	1	0	IS-M/AM: Contract Category	TJH11
82	XBEST_PR	☐	XBEST_PR	XFELD	CHAR	1	0	IS-M: Apply Best Conditions to Number / Quantity
83	XPOSAEN	☐	XPOSAEN	XFELD	CHAR	1	0	IS-M: "Contract Item Changed" Indicator
84	XZIELAEN	☐	XZIELAEN	XFELD	CHAR	1	0	IS-M: "Target Quantities in COA Changed" Indicator
85	PR_BASIS	☐	PR_BASIS	PR_BASIS	CHAR	1	0	IS-M: Basis for scale access (number/quantity)
86	MENGE1	☐	ABS_MENGE1	ABS_MENGE	QUAN	12	3	IS-M/AM: Agreed Quantity to be Sold
87	EINH1	☐	AB_MEINH	MEINS	UNIT	3	0	IS-M: Contract Units of Measurement
88	AB_ZIEL1	☐	AB_ZIEL1	WERTV8	CURR	15	2	IS-M/AM: Target Quantity for Monetary Contract
89	AB_WEINH	☐	AB_WEINH	WAERS	CUKY	5	0	IS-M: Currency Key for Contract	TCURC
90	RKSCHL	☐	KSCHL	KSCHL	CHAR	4	0	Condition Type
91	BKSCHL	☐	KSCHL	KSCHL	CHAR	4	0	Condition Type
92	MENGE2	☐	ABS_MENGE2	ABS_MENGE	QUAN	12	3	IS-M/AM: Agreed Quantity to be Sold
93	EINH2	☐	AB_MEINH	MEINS	UNIT	3	0	IS-M: Contract Units of Measurement
94	MEINH	☐	AB_MEINH	MEINS	UNIT	3	0	IS-M: Contract Units of Measurement	T006
95	ORIG_MENG1	☐	ABS_MENGE1	ABS_MENGE	QUAN	12	3	IS-M/AM: Agreed Quantity to be Sold
96	ORIG_MENG2	☐	ABS_MENGE2	ABS_MENGE	QUAN	12	3	IS-M/AM: Agreed Quantity to be Sold
97	ORIG_ZIEL1	☐	AB_ZIEL1	WERTV8	CURR	15	2	IS-M/AM: Target Quantity for Monetary Contract
98	XAB_PREIS	☐	XAB_PREIS	XFELD	CHAR	1	0	IS-M/AM: Basic Price from Contract Indicator
99	XAB_PRLST	☐	XAB_PRLST	XFELD	CHAR	1	0	IS-M: Do not Overfulfill Contract Indicator
100	AB_PREIS	☐	AB_PREIS	WERTV8	CURR	15	2	IS-M: Current Valid Price from Contract
101	AB_KPREIS	☐	AB_KPREIS	WERTV8	CURR	15	2	IS-M: Price from Scale
102	AB_VPREIS	☐	AB_VPREIS	WERTV8	CURR	15	2	IS-M: Agreed Price from Contract
103	FMP_KPEIN	☐	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
104	FMP_KMEIN	☐	KMEIN	MEINS	UNIT	3	0	Condition Unit	T006
105	RKNUMV	☐	AB_RKNUMV	RABATT	DEC	5	2	IS-M: Discount from Scale
106	RABATT	☐	AB_RABATT	RABATT	DEC	5	2	IS-M: Current Valid Contract Discount Rate
107	VRABATT	☐	VRABATT	RABATT	DEC	5	2	IS-M: Agreed Discount
108	XRABAEN	☐	XRABAEN	XFELD	CHAR	1	0	IS-M/AM: Discount Changed Manually
109	XRAB_CH	☐	XRAB_CH	XFELD	CHAR	1	0	IS-M: Current discount change
110	XRABA	☐	XRABATTANP	XFELD	CHAR	1	0	IS-M/AM: Indicator: Adjust Discount During Contract Period?
111	XERFUELLT	☐	XERFUELLT	XFELD	CHAR	1	0	IS-M/AM: Contract Fulfilled Yes/No Indicator
112	XRABAN	☐	XRABAN	XFELD	CHAR	1	0	IS-M: Next discount level characteristic reached
113	XRABAZW	☐	XRABAZW	XFELD	CHAR	1	0	IS-M/AM: Discount change with next interim settlement
114	XRABSPERR	☐	XRABSPERR	XFELD	CHAR	1	0	IS-M: Block higher-level discounts indicator
115	XBRUTTO	☐	XBRUTTO	XFELD	CHAR	1	0	IS-M: Gross Contract Characteristic
116	BKNUMV	☐	AB_BKNUMV	RABATT	DEC	5	2	IS-M/AM: Bonus from Scale
117	XVBONUS	☐	XVBONUS	XFELD	CHAR	1	0	IS-M: Advance Bonus Indicator
118	AKTBONUS	☐	AKTBONUS	RABATT	DEC	5	2	IS-M/AM: Current Valid Contract Bonus
119	VBONUS	☐	VBONUS	RABATT	DEC	5	2	IS-M: Agreed Bonus
120	XGUTSCHR	☐	XGUTSCHR	XFELD	CHAR	1	0	IS-M: Do not perform credit memo characteristic
121	FREITEXT	☐	ABS_TEXT	FREITEXT	CHAR	50	0	IS-M: Freely Definable Text
122	L_FKT_DAT	☐	L_FKT_DAT	DATUM	DATS	8	0	IS-M: Last Actual Billing Date
123	L_AE_DAT	☐	L_AE_DAT	DATUM	DATS	8	0	IS-M: Last Publication Date
124	ABS_ZUST	☐	ABS_ZUST	XUBNAME	CHAR	12	0	IS-M: Person Responsible	USR02
125	FRD_VTNR	☐	FRD_VTNR	CHAR15	CHAR	15	0	IS-M: Externally Assigned Contract Number
126	MM_VTNR	☐	MM_VTNR	MM_VTNR	CHAR	10	0	IS-M: Contract Number for Media-Mix Contract	JHTMXK
127	KOFRS	☐	ISM_CONKOFRS	GRPNO	NUMC	3	0	IS-M: Scale Base Formula Provided From the Contract	TFRM
128	LEVEL_BP	☐	JH_BWCOALEVEL_BP	JH_BWCOALEVEL_BP	CHAR	1	0	IS-M/AM: Contract BW Classification for Contract Holder
129	LEVEL_BU	☐	JH_BWCOALEVEL_BU	JH_BWCOALEVEL_BU	CHAR	1	0	IS-M/AM: Contract BW Classification for Booking Unit
130	SAERBMO	☐	SRBMO	WERTV8	CURR	15	2	Total sales vol.all acc.assignments qualifying for discount
131	SAERBMM	☐	SRBMM	SAEMM	QUAN	12	3	IS-M: Total qty all acc.assignments qualifying for discount
132	SAERBME	☐	SRBME	SAEME	DEC	5	0	IS-M: Total No.All Acc.Assignments Qualifying for Discount
133	SAEBOMO	☐	SBOMO	WERTV8	CURR	15	2	IS-M: Total sales vol.all accept.assignments qual.for bonus
134	SAEBOMM	☐	SBOMM	SAEMM	QUAN	12	3	IS-M: Total quantity of all accpt.assignments qual.for bonus
135	SAEBOME	☐	SBOME	SAEME	DEC	5	0	IS-M: Total Number All Acc.Assignments Qualifying for Bonus
136	SAEMRNRMO	☐	SMRNRMO	WERTV8	CURR	15	2	Total sales vol.all orig.acc.assignments count.towards disc.
137	SAEMRNRMM	☐	SMRNRMM	SAEMM	QUAN	12	3	Total qty all acc.original assignments count.towards disc.
138	SAEMRNRME	☐	SMRNRME	SAEME	DEC	5	0	Total No.of All Acc.Original Assignments Count.Towards Disc.
139	SAEMBNBMO	☐	SMBNBMO	WERTV8	CURR	15	2	Total sales vol.of all acc.orig.assignments count.twrd bonus
140	SAEMBNBMM	☐	SMBNBMM	SAEMM	QUAN	12	3	Total qty of all original acc.assignments counting twrd bon.
141	SAEMBNBME	☐	SMBNBME	SAEME	DEC	5	0	Total No.of All Acc.Original Assignments Count.Twrds Bonus
142	SAERFRRMO	☐	SRFRRMO	WERTV8	CURR	15	2	Total sales vol.all acc.assignments qual.for dis.frm othr BU
143	SAERFRRMM	☐	SRFRRMM	SAEMM	QUAN	12	3	Total qty all acc.assignments qual.for disc.from other BU
144	SAERFRRME	☐	SRFRRME	SAEME	DEC	5	0	Total No.All Acc.Assignments Qual.for Discount From Other BU
145	SAEBFRMO	☐	SBFRMO	WERTV8	CURR	15	2	Total sales vol. all acc.assign. qual.for bonus from othr BU
146	SAEBFRMM	☐	SBFRMM	SAEMM	QUAN	12	3	Total qty of all accp.assignments qual.for bonus frm othr BU
147	SAEBFRME	☐	SBFRME	SAEME	DEC	5	0	Total Number of Assignments Qualify.for Bonus From Other BU
148	SAEFRMO	☐	SFRMO	WERTV8	CURR	15	2	Total sales vol.of all accepted assignments from other BU
149	SAEFRMM	☐	SFRMM	SAEMM	QUAN	12	3	IS-M: Total quantity of all accept.assignments from other BU
150	SAEFRME	☐	SFRME	SAEME	DEC	5	0	IS-M: Total Number of All Accepted Assignments From Other BU
151	SAEMFRBMO	☐	SMFRBMO	WERTV8	CURR	15	2	Total sales vol.all acc.assign.count.twrds bonus frm othr BU
152	SAEMFRBMM	☐	SMFRBMM	SAEMM	QUAN	12	3	Total qty all acc.assignmnts count.twrds bonus from other BU
153	SAEMFRBME	☐	SMFRBME	SAEME	DEC	5	0	Total No.All Acc.Assignmnts Count.Twrds Bonus From Other BU
154	SAEVBMO	☐	SVBMO	WERTV8	CURR	15	2	IS-M: Total sales vol.all acc.assignments from other SA
155	SAEVBMM	☐	SVBMM	SAEMM	QUAN	12	3	IS-M: Total qty all acc.assignments from other sales area
156	SAEVBME	☐	SVBME	SAEME	DEC	5	0	IS-M: Total Number of All Accepted Assignments From Other SA
157	SAEMAMO	☐	SMAMO	WERTV8	CURR	15	2	IS-M: Total sales volume of all accepted manual assignments
158	SAEMAMM	☐	SMAMM	SAEMM	QUAN	12	3	IS-M: Total quantity of all manual assignments accepted
159	SAEMAME	☐	SMAME	SAEME	DEC	5	0	IS-M: Total Number of All Manual Assignments Accepted
160	SAEMRMO	☐	SMRMO	WERTV8	CURR	15	2	Total sales vol.from all acc.assignments count.toward disc.
161	SAEMRMM	☐	SMRMM	SAEMM	QUAN	12	3	Total qty of all acc.assignments counting towards discount
162	SAEMRME	☐	SMRME	SAEME	DEC	5	0	IS-M: Total No.of All Acc.Assignments Counting Towards Disc.
163	SAEMBMO	☐	SMBMO	WERTV8	CURR	15	2	IS-M: Total sales vol.of all acc.assignments count.twd bon.
164	SAEMBMM	☐	SMBMM	SAEMM	QUAN	12	3	IS-M: Total qty of all accept.assignments counting twrd bon.
165	SAEMBME	☐	SMBME	SAEME	DEC	5	0	IS-M: Total No.All Accept.Assignments Which Count Twrds Bon.
166	SFKRBMO	☐	SRBMO_FK	WERTV8	CURR	15	2	Total sales vol.all billed assignments qualifying for disc.
167	SFKRBMM	☐	SRBMM_FK	SAEMM	QUAN	12	3	Total qty all billed assignments qualifying for discount
168	SFKRBME	☐	SRBME_FK	SAEME	DEC	5	0	IS-M: Total No.All Bill.Assignments Qualifying for Discount
169	SFKBOMO	☐	SBOMO_FK	WERTV8	CURR	15	2	Total sales vol.all billed assignments qualifying for bonus
170	SFKBOMM	☐	SBOMM_FK	SAEMM	QUAN	12	3	Total qty of all billed assignments qualifying for bonus
171	SFKBOME	☐	SBOME_FK	SAEME	DEC	5	0	Total Number of All Billed Assignments Qualifying for Bonus
172	SFKMRNRMO	☐	SMRNRMO_FK	WERTV8	CURR	15	2	Total sales vol.all billed orig.assignments count.twrd disc.
173	SFKMRNRMM	☐	SMRNRMM_FK	SAEMM	QUAN	12	3	Total qty all billed original assignments count.twrd disc.
174	SFKMRNRME	☐	SMRNRME_FK	SAEME	DEC	5	0	Total No.of All Billed Original Assignments Count.Twrd Disc.
175	SFKMBNBMO	☐	SMBNBMO_FK	WERTV8	CURR	15	2	Total sales vol.all bill.original assignments count.twd bon.
176	SFKMBNBMM	☐	SMBNBMM_FK	SAEMM	QUAN	12	3	Total qty of all billed original assignments count.twrd bon.
177	SFKMBNBME	☐	SMBNBME_FK	SAEME	DEC	5	0	Total No.of All Billed Original Assignments Count.Twrd Bonus
178	SFKRFRRMO	☐	SRFRRMO_FK	WERTV8	CURR	15	2	Total sales vol.all bill.assignm.qual.for disc from other BU
179	SFKRFRRMM	☐	SRFRRMM_FK	SAEMM	QUAN	12	3	Total qty all billed assignments qual.for disc.from other BU
180	SFKRFRRME	☐	SRFRRME_FK	SAEME	DEC	5	0	Total No.All Billed Assignments Qual.for Disc.From Other BU
181	SFKBFRMO	☐	SBFRMO_FK	WERTV8	CURR	15	2	Total sales vol.all bill.assign.qual.for bonus from other BU
182	SFKBFRMM	☐	SBFRMM_FK	SAEMM	QUAN	12	3	Total qty all billed assignments qual.for bonus frm other BU
183	SFKBFRME	☐	SBFRME_FK	SAEME	DEC	5	0	Total No.All Billed Assignments Qual.for Bonus From Other BU
184	SFKFRMO	☐	SFRMO_FK	WERTV8	CURR	15	2	Total sales volume of all billed assignments from other BU
185	SFKFRMM	☐	SFRMM_FK	SAEMM	QUAN	12	3	Total quantity of all billed assignments from other BU
186	SFKFRME	☐	SFRME_FK	SAEME	DEC	5	0	Total Number of All Billed Assignments From Other BU
187	SFKMFRBMO	☐	SMFRBMO_FK	WERTV8	CURR	15	2	Total sales vol.all bill.assign.count.twrd bon.from othr BU
188	SFKMFRBMM	☐	SMFRBMM_FK	SAEMM	QUAN	12	3	Total qty all billed assignments count.twrd bonus frm oth.BU
189	SFKMFRBME	☐	SMFRBME_FK	SAEME	DEC	5	0	Total No.of All Bill.Assignments From Othr BU Count.Twrd Bon
190	SFKVBMO	☐	SVBMO_FK	WERTV8	CURR	15	2	Total sales vol. from all billed assignments from other SAs
191	SFKVBMM	☐	SVBMM_FK	SAEMM	QUAN	12	3	Total quantity all billed assignments from other SA
192	SFKVBME	☐	SVBME_FK	SAEME	DEC	5	0	Total Number of All Billed Assignments From Other SA
193	SFKMAMO	☐	SMAMO_FK	WERTV8	CURR	15	2	Total sales volume of all billed manual assignments
194	SFKMAMM	☐	SMAMM_FK	SAEMM	QUAN	12	3	IS-M: Total quantity of all billed manual assignments
195	SFKMAME	☐	SMAME_FK	SAEME	DEC	5	0	IS-M: Total Number of All Billed Manual Assignments
196	SFKMRMO	☐	SMRMO_FK	WERTV8	CURR	15	2	Total sales vol.all billed assignments count.toward discount
197	SFKMRMM	☐	SMRMM_FK	SAEMM	QUAN	12	3	Total quantity of all billed assignments counting twrd disc.
198	SFKMRME	☐	SMRME_FK	SAEME	DEC	5	0	Total Number of All Billed Assignments Counting Toward Disc.
199	SFKMBMO	☐	SMBMO_FK	WERTV8	CURR	15	2	Total sales vol.all billed assignments counting twrd bonus
200	SFKMBMM	☐	SMBMM_FK	SAEMM	QUAN	12	3	Total quantity of all billed assignments counting twrd bon.
201	SFKMBME	☐	SMBME_FK	SAEME	DEC	5	0	Total Number of All Billed Assignments That Count Twrd Bonus
202	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
203	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
204	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
205	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
206	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
207	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
208	CZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
209	MK_LOEVM	☐	LOEVM_ISP	XFELD	CHAR	1	0	Deletion Flag for Master Data in Media Sales & Distribution
210	MK_LOEKZ	☐	LOEKZ_ISP	XFELD	CHAR	1	0	Deletion Indicator for Master Data in Media Sales & Dist.
211	XNK	☐	XNEUKUNDE	XFELD	CHAR	1	0	IS-M: New customer indicator
212	KUKARR	☐	JKUKARR	JKUKARR	CHAR	2	0	IS-M: Customer Profile	TJJ95
213	KONKAUS	☐	KONKAUS	KONKAUS	CHAR	2	0	IS-M: Competitor exclusion	TJH89
214	MK_XAGEN	☐	XAGENTUR	XFELD	CHAR	1	0	IS-M: Agency Indicator
215	MK_XSTR	☐	XAGEN_STR	XFELD	CHAR	1	0	IS-M: Distribution Agency Indicator
216	MK_XPLAN	☐	XAGEN_PLAN	XFELD	CHAR	1	0	IS-M: Planning Agency Indicator
217	MK_XART	☐	XAGEN_KREA	XFELD	CHAR	1	0	IS-M: Creative Boutique Indicator
218	MK_ABRKAG	☐	JABRKALAG	WFCID	CHAR	2	0	IS-M: Agency Billing Schedule (Calendar Identification)	TJG61
219	MKAGEN_GRU	☐	AGEN_GRUP	AGEN_GRUP	CHAR	1	0	IS-M: Agency Type	TJGJ4
220	AE	☐	AGEN_AE	AGEN_AE	CHAR	1	0	IS-M: Agency Commission Entitlement
221	MK_DUB	☐	JDUBIOS	JDUBIOS	CHAR	1	0	IS-M: Credit Query Indicator	TJGJ0
222	MK_BON	☐	JBONITAET	JBONITAET	CHAR	2	0	IS-M: Creditworthiness Indicator	TJGJ2
223	XMAN	☐	XMANUSKRIP	XFELD	CHAR	1	0	IS-M: Processing of Ad Booking Details Requested Indicator
224	ZTEGR	☐	GR_ZTERM	GR_ZTERM	CHAR	2	0	IS-M: Terms of Payment Group	TJJB7
225	TOL	☐	SIZE_TOL	CHAR03	CHAR	3	0	IS-M: Deviation tolerance as a percentage value
226	RE_STELL	☐	RE_STELL	RE_STELL	CHAR	1	0	IS-M: Billing split	TJJB3
227	DRSTS	☐	JHDRSTS	JHDRSTS	CHAR	2	0	IS-M: Print Control Procedure	TJJB5
228	XORTSPR	☐	XORTSPREIS	XFELD	CHAR	1	0	IS-M/AM: Local Customer Indicator
229	VKBOF	☐	JVKBUR_OFF	VKBUR	CHAR	4	0	IS-M: Alternative sales office for collecting responses	TVKBZ
230	BLART	☐	PAM_BELART	PAM_BELART	CHAR	4	0	IS-M: Voucher Type (Proof)	TJJB1
231	BLANZ	☐	PAM_BELANZ	NUMC5	NUMC	5	0	IS-M: Number of Voucher Copies
232	ZLSCHB	☐	JHZLSCHB	ZLSCH	CHAR	1	0	IS-M/AM: Payment Method for Customer Bonus Settlement	T042Z
233	K_ANZ	☐	KARENZANZ	JKARENZ	NUMC	4	0	IS-M/AM: Grace Period for Changes to Ad Prices
234	K_ANZ_ME	☐	JJMEINS	MEINS	UNIT	3	0	IS-M: Basic Unit of Measure for Time	T006
235	K_DL	☐	KARENZDL	JKARENZ	NUMC	4	0	IS-M: Grace Period for Changes to Service Prices
236	K_DL_ME	☐	JJMEINS	MEINS	UNIT	3	0	IS-M: Basic Unit of Measure for Time	T006
237	K_SI	☐	KARENZSI	JKARENZ	NUMC	4	0	IS-M: Grace Period for Changes to Prices of Ad Inserts
238	K_SI_ME	☐	JJMEINS	MEINS	UNIT	3	0	IS-M: Basic Unit of Measure for Time	T006
239	K_VER	☐	KARENZVER	JKARENZ	NUMC	4	0	IS-M: Grace Period for Changes to Distribution Prices
240	K_VER_ME	☐	JJMEINS	MEINS	UNIT	3	0	IS-M: Basic Unit of Measure for Time	T006
241	K_WSP	☐	KARENZWSP	JKARENZ	NUMC	4	0	IS-M: Grace Period for Changes to Commercial Prices
242	K_WSP_ME	☐	JJMEINS	MEINS	UNIT	3	0	IS-M: Basic Unit of Measure for Time	T006
243	K_OL	☐	KARENZOL	JKARENZ	NUMC	4	0	IS-M: Grace Period for Price Changes in Online Advertising
244	K_OL_ME	☐	JJMEINS	MEINS	UNIT	3	0	IS-M: Basic Unit of Measure for Time	T006
245	XABSCHL	☐	XABSCHLUSS	XFELD	CHAR	1	0	IS-M: Contract Customer Indicator
246	ABE	☐	ABSCH_ERN	JNFELD	CHAR	1	0	IS-M: Indicator: Automatic Contract Renewal
247	MAX_UNT	☐	MAX_UNT	NUMC2	NUMC	2	0	IS-M: Maximum Interruption in Validity Period (in Months)
248	MAX_RDAT	☐	MAX_RDAT	SYNUM02	NUMC	2	0	IS-M: Maximum Backdating Start of Validity Period (Months)
249	MENGA	☐	ANPASS	JNFELD	CHAR	1	0	Quantity Adjustment for Contract Validity Period Change
250	ARAB	☐	ARABATT	JNFELD	CHAR	1	0	IS-M: Qualifies for Contract Indicator
251	RABA	☐	RABATTANP	JH_XRABANP	CHAR	1	0	IS-M: Disc./Price Adjustment During Contract Validity Period
252	RABSPERR	☐	RABSPERR	JNFELD	CHAR	1	0	IS-M: Block higher-level discounts indicator
253	RANPASS	☐	RANPASS	JNFELD	CHAR	1	0	IS-M: Increase Discount in the Case of Over-Fulfillment Ind.
254	RANPASSL	☐	RANPASSL	JNFELD	CHAR	1	0	IS-M: Reduce Discount in the Case of Non-Fulfillment Ind.
255	QABR	☐	QABR	QABR	CHAR	1	0	IS-M: Define Settlement for System Contracts
256	REG_DAU	☐	ABSCHLZEIT	SYNUM02	NUMC	2	0	IS-M: Standard Validity Period for Contracts (in Months)
257	AB_TOL	☐	ABSCHL_TOL	NUMC03	NUMC	3	0	IS-M: Contract Tolerance Quantity for Non-Fulfillment (in %)
258	ZLSCHA	☐	JHZLSCHA	ZLSCH	CHAR	1	0	IS-M: Payment Method for Contract Settlement	T042Z
259	FAKSA	☐	PAM_FAKSP	FAKSP	CHAR	2	0	IS-M: Billing Block	TVFS
260	BEST_PR	☐	BEST_PR	JNFELD	CHAR	1	0	IS-M: Apply Best Conditions to Number / Quantity
261	PAR_ABS	☐	PAR_ABS	JNFELD	CHAR	1	0	IS-M: Work with Parallel Contracts Indicator
262	AB_VOR	☐	AB_VOR	JNFELD	CHAR	1	0	IS-M: Advance Bonus Indicator
263	TO_WARN	☐	TO_WARN	JNFELD	CHAR	1	0	IS-M: Generate Advance Warning Automatically
264	MIN_GUT	☐	MIN_GUTSCH	ISPBETR07	CURR	7	2	IS-M: De Minimis Limitation for Contract Credit Memo
265	MIN_LAST	☐	MIN_LAST	ISPBETR07	CURR	7	2	IS-M/AM: De Minimis Limitation for Contract Debit Memo
266	MB_AUSR	☐	ABSCHL_BEG	ABSCHL_BEG	CHAR	1	0	IS-M: Rule for Contract Start	TJJV14
267	ME_AUSR	☐	ABSCHL_END	ABSCHL_END	CHAR	1	0	IS-M: Rule for Contract End	TJJV15
268	MEABR_NACHL	☐	EABR_NACHL	SYNUM02	NUMC	2	0	IS-M: Time of Final Settlement After Runtime (in Months)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JHVVAABK	AAB_WEINH	TCURC	WAERS	REF	1	CN
2	JHVVAABK	ABINHNR	JGTGPNR	GPNR	REF	1	CN
3	JHVVAABK	ABRGNR	JHTVAABK	ABRGNR	KEY	1	CN
4	JHVVAABK	ABS_TYP1	TJH11	ABS_TYP	REF	1	CN
5	JHVVAABK	ABS_ZUST	USR02	BNAME	KEY	1	CN
6	JHVVAABK	AB_WEINH	TCURC	WAERS	REF	1	CN
7	JHVVAABK	ASPART	TSPA	SPART		1	CN
8	JHVVAABK	AVKORG	TVKO	VKORG		1	CN
9	JHVVAABK	AVTWEG	TVTW	VTWEG		1	CN
10	JHVVAABK	BLART	TJJB1	BLART	REF	1	CN
11	JHVVAABK	B_AUSR	TJJV14	B_AUSR	REF	1	CN
12	JHVVAABK	DRSTS	TJJB5	DRSTS	REF	1	CN
13	JHVVAABK	E_AUSR	TJJV15	E_AUSR	REF	1	CN
14	JHVVAABK	FAKSA	TVFS	FAKSP	REF	1	CN
15	JHVVAABK	FAKSP	TVFS	FAKSP		1	CN
16	JHVVAABK	FMP_KMEIN	T006	MSEHI	REF	C	CN
17	JHVVAABK	FVTNR	JHTVKO	VTNR	REF	C	C
18	JHVVAABK	INSERENT	JJVDB_MK_FK	GPNR	KEY	1	CN
19	JHVVAABK	KOFRS	TFRM	GRPNO	REF	C	CN
20	JHVVAABK	KONKAUS	TJH89	KONKAUS	REF	C	CN
21	JHVVAABK	KUKARR	TJJ95	KUKARR	REF	C	CN
22	JHVVAABK	K_ANZ_ME	T006	MSEHI	REF	C	CN
23	JHVVAABK	K_DL_ME	T006	MSEHI	REF	C	CN
24	JHVVAABK	K_OL_ME	T006	MSEHI	REF	C	CN
25	JHVVAABK	K_SI_ME	T006	MSEHI	REF	C	CN
26	JHVVAABK	K_VER_ME	T006	MSEHI	REF	C	CN
27	JHVVAABK	K_WSP_ME	T006	MSEHI	REF	C	CN
28	JHVVAABK	MANDT	T000	MANDT	KEY	1	CN
29	JHVVAABK	MB_AUSR	TJJV14	B_AUSR	REF	C	CN
30	JHVVAABK	MEINH	T006	MSEHI	REF	1	CN
31	JHVVAABK	ME_AUSR	TJJV15	E_AUSR	REF	C	CN
32	JHVVAABK	MKAGEN_GRU	TJGJ4	AGEN_GRU	REF	1	N
33	JHVVAABK	MK_ABRKAG	TJG61	IDENT
34	JHVVAABK	MK_BON	TJGJ2	BONITAET	KEY	1	CN
35	JHVVAABK	MK_DUB	TJGJ0	DUBIOS	KEY	1	CN
36	JHVVAABK	MM_VTNR	JHTMXK	VTNR	REF	C	CN
37	JHVVAABK	REGULIERER	JJVDB_MK	GPNR	KEY	1	CN
38	JHVVAABK	RE_STELL	TJJB3	RE_STELL	REF	1	CN
39	JHVVAABK	SPART	TVTA	SPART	REF	1	CN
40	JHVVAABK	STORNOGRD	TJHSTOG	STORNOGRD		1	CN
41	JHVVAABK	VKBOF	TVKBZ	VKBUR	REF	1	CN
42	JHVVAABK	VKBUR	TVKBZ	VKBUR	REF	1	CN
43	JHVVAABK	VKGRP	TVBVK	VKGRP	REF	1	CN
44	JHVVAABK	VKORG	TVKO	VKORG	REF	1	CN
45	JHVVAABK	VTNR	JHTVAABK	VTNR	KEY	1	CN
46	JHVVAABK	VTWEG	TVKOV	VTWEG	REF	1	CN
47	JHVVAABK	VVTNR	JHTVKO	VTNR
48	JHVVAABK	WEINHABRM	TCURC	WAERS		1	CN
49	JHVVAABK	ZLSCHA	T042Z	ZLSCH	KEY	1	CN
50	JHVVAABK	ZLSCHB	T042Z	ZLSCH	REF	1	CN
51	JHVVAABK	ZTEGR	TJJB7	ZTEGR	REF	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in