SAP ABAP Table JJVDB_MK (Generated Table for View)
Basic Data
Table Category | VIEW | General view structure |
General view structure | JJVDB_MK |
![]() |
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 | CLNT | 3 | 0 | Client | T000 | |
2 | ![]() |
GPNR | GPNR | CHAR | 10 | 0 | IS-M: Business Partner Key | ||
3 | ![]() |
VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | TVKO | |
4 | ![]() |
VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | TVTW | |
5 | ![]() |
SPART | SPART | CHAR | 2 | 0 | Division | TSPA | |
6 | ![]() |
JXLV_GP | XFELD | CHAR | 1 | 0 | IS-M: Deletion Flag for General Business Partner | ||
7 | ![]() |
XLOESCHKZ | XFELD | CHAR | 1 | 0 | IS-M: Deletion Indicator (Role-Specific) | ||
8 | ![]() |
XGPSPE | XFELD | CHAR | 1 | 0 | IS-M/SD: Lock Indicator for General Business Partner | ||
9 | ![]() |
ERFUSER | USNAM | CHAR | 12 | 0 | Created By | ||
10 | ![]() |
ERFDATE | DATUM | DATS | 8 | 0 | Created On | ||
11 | ![]() |
ERFTIME | UZEIT | TIMS | 6 | 0 | Time Created | ||
12 | ![]() |
AENUSER | USNAM | CHAR | 12 | 0 | Last Changed By | ||
13 | ![]() |
AENDATE | DATUM | DATS | 8 | 0 | Date of Last Change | ||
14 | ![]() |
AENTIME | UZEIT | TIMS | 6 | 0 | Time of Last Change | ||
15 | ![]() |
JKTOKD | JKTOKD | CHAR | 4 | 0 | IS-M: Business Partner Account Group | TJG37 | |
16 | ![]() |
JMAILN | SO_OBJ_NAM | CHAR | 12 | 0 | IS-M: Mail Address | ||
17 | ![]() |
BERUFSL | BERUFSL | CHAR | 8 | 0 | IS-M: Occupation | TJG05 | |
18 | ![]() |
GFORM | GFORM | CHAR | 2 | 0 | Legal status | TVGF | |
19 | ![]() |
BRSCH | BRSCH | CHAR | 4 | 0 | Industry key | T016 | |
20 | ![]() |
BRAN1_D | BRACO | CHAR | 10 | 0 | Industry code 1 | TBRC | |
21 | ![]() |
BRAN2 | BRACO | CHAR | 10 | 0 | Industry code 2 | TBRC | |
22 | ![]() |
BRAN3 | BRACO | CHAR | 10 | 0 | Industry code 3 | TBRC | |
23 | ![]() |
BRAN4 | BRACO | CHAR | 10 | 0 | Industry code 4 | TBRC | |
24 | ![]() |
BRAN5 | BRACO | CHAR | 10 | 0 | Industry code 5 | TBRC | |
25 | ![]() |
JGEBDAT | DATUM | DATS | 8 | 0 | IS-M: Date of Birth of a Business Partner | ||
26 | ![]() |
JGESCHL | JGESCHL | CHAR | 1 | 0 | IS-M: Gender Key | ||
27 | ![]() |
JFAMST | JFAMST | CHAR | 1 | 0 | IS-M: Business Partner's Marital Status | TJG45 | |
28 | ![]() |
GPHERK | GPHERK | CHAR | 2 | 0 | IS-M: Business Partner Origin | TJG41 | |
29 | ![]() |
XNATUR | XFELD | CHAR | 1 | 0 | IS-M: Natural Person Indicator | ||
30 | ![]() |
XCPDK | XFELD | CHAR | 1 | 0 | Indicator: Is the account a one-time account? | ||
31 | ![]() |
JXDEBI | XFELD | CHAR | 1 | 0 | IS-M: Indicator: Customer Exists | ||
32 | ![]() |
JFKUNNR | KUNNR | CHAR | 10 | 0 | IS-M: Customer Number in Non-SAP System | ||
33 | ![]() |
XKREDI | XFELD | CHAR | 1 | 0 | IS-M: Indicator: Vendor Exists | ||
34 | ![]() |
JLIFNR | LIFNR | CHAR | 10 | 0 | IS-M: Vendor Number in Previous System | LFA1 | |
35 | ![]() |
JFLIFNR | LIFNR | CHAR | 10 | 0 | IS-M: Vendor Number in Non-SAP System | ||
36 | ![]() |
XMITARB | XFELD | CHAR | 1 | 0 | IS-M: Employee Indicator | ||
37 | ![]() |
JPERNR2 | JPERNR | CHAR | 20 | 0 | IS-M: Personnel Number | ||
38 | ![]() |
XNOWERB | XFELD | CHAR | 1 | 0 | IS-M: No Advertising | ||
39 | ![]() |
KATR1 | ATTR1 | CHAR | 2 | 0 | Attribute 1 | TVK1 | |
40 | ![]() |
KATR2 | ATTR2 | CHAR | 2 | 0 | Attribute 2 | TVK2 | |
41 | ![]() |
KATR3 | ATTR3 | CHAR | 2 | 0 | Attribute 3 | TVK3 | |
42 | ![]() |
KATR4 | ATTR4 | CHAR | 2 | 0 | Attribute 4 | TVK4 | |
43 | ![]() |
KATR5 | ATTR5 | CHAR | 2 | 0 | Attribute 5 | TVK5 | |
44 | ![]() |
KATR6 | ATTR6 | CHAR | 3 | 0 | Attribute 6 | TVK6 | |
45 | ![]() |
KATR7 | ATTR7 | CHAR | 3 | 0 | Attribute 7 | TVK7 | |
46 | ![]() |
KATR8 | ATTR8 | CHAR | 3 | 0 | Attribute 8 | TVK8 | |
47 | ![]() |
KATR9 | ATTR9 | CHAR | 3 | 0 | Attribute 9 | TVK9 | |
48 | ![]() |
KATR10 | ATTR10 | CHAR | 3 | 0 | Attribute 10 | TVK0 | |
49 | ![]() |
XMEDIAK | XFELD | CHAR | 1 | 0 | IS-M: Media customer | ||
50 | ![]() |
XMKLV | XFELD | CHAR | 1 | 0 | IS-M: Deletion Flag for Media Customer | ||
51 | ![]() |
XLOESCHKZ | XFELD | CHAR | 1 | 0 | IS-M: Deletion Indicator (Role-Specific) | ||
52 | ![]() |
XMKSPE | XFELD | CHAR | 1 | 0 | IS-M: Lock Indicator for Media Customer | ||
53 | ![]() |
JBONITAET | JBONITAET | CHAR | 2 | 0 | IS-M: Creditworthiness Indicator | TJGJ2 | |
54 | ![]() |
AUFSD_X | KAUFS | CHAR | 2 | 0 | Central order block for customer | TVAST | |
55 | ![]() |
LOEVM_X | XFELD | CHAR | 1 | 0 | Central Deletion Flag for Master Record | ||
56 | ![]() |
BRSCH | BRSCH | CHAR | 4 | 0 | Industry key | T016 | |
57 | ![]() |
FAKSD_X | FAKSP | CHAR | 2 | 0 | Central billing block for customer | TVFS | |
58 | ![]() |
KTOKD | KTOKD | CHAR | 4 | 0 | Customer Account Group | T077D | |
59 | ![]() |
SPERB_X | XFELD | CHAR | 1 | 0 | Central posting block | ||
60 | ![]() |
REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | ||
61 | ![]() |
COUNC | COUNC | CHAR | 3 | 0 | County Code | ||
62 | ![]() |
CITYC | CITYC | CHAR | 4 | 0 | City Code | ||
63 | ![]() |
TXJCD | TXJCD | CHAR | 15 | 0 | Tax Jurisdiction | TTXJ | |
64 | ![]() |
AUFSD_V | KAUFS | CHAR | 2 | 0 | Customer order block (sales area) | TVAST | |
65 | ![]() |
LOEVM_V | XFELD | CHAR | 1 | 0 | Deletion flag for customer (sales level) | ||
66 | ![]() |
STGKU | STGKU | CHAR | 1 | 0 | Customer Statistics Group | TVSD | |
67 | ![]() |
KALKS | KALKS | CHAR | 1 | 0 | Pricing procedure assigned to this customer | TVKD | |
68 | ![]() |
KDGRP | KDGRP | CHAR | 2 | 0 | Customer group | T151 | |
69 | ![]() |
KONDA | KONDA | CHAR | 2 | 0 | Price Group (Customer) | T188 | |
70 | ![]() |
PLTYP | PLTYP | CHAR | 2 | 0 | Price list type | T189 | |
71 | ![]() |
INCO1 | INCO1 | CHAR | 3 | 0 | Incoterms (part 1) | TINC | |
72 | ![]() |
INCO2 | INCO2 | CHAR | 28 | 0 | Incoterms (part 2) | ||
73 | ![]() |
EIKTO | CHAR12 | CHAR | 12 | 0 | Shipper's (Our) Account Number at the Customer or Vendor | ||
74 | ![]() |
MRNKZ | XFELD | CHAR | 1 | 0 | Manual invoice maintenance | ||
75 | ![]() |
PERFK | WFCID | CHAR | 2 | 0 | Invoice dates (calendar identification) | TFACD | |
76 | ![]() |
WAERS_V02D | WAERS | CUKY | 5 | 0 | Currency | TCURC | |
77 | ![]() |
KTGRD | KTGRD | CHAR | 2 | 0 | Account assignment group for this customer | TVKT | |
78 | ![]() |
DZTERM | ZTERM | CHAR | 4 | 0 | Terms of payment key | ||
79 | ![]() |
VKGRP | VKGRP | CHAR | 3 | 0 | Sales group | TVBVK | |
80 | ![]() |
VKBUR | VKBUR | CHAR | 4 | 0 | Sales office | TVBUR | |
81 | ![]() |
KURST | KURST | CHAR | 4 | 0 | Exchange Rate Type | TCURV | |
82 | ![]() |
LOEVM_ISP | XFELD | CHAR | 1 | 0 | Deletion Flag for Master Data in Media Sales & Distribution | ||
83 | ![]() |
LOEKZ_ISP | XFELD | CHAR | 1 | 0 | Deletion Indicator for Master Data in Media Sales & Dist. | ||
84 | ![]() |
ERFUSER | USNAM | CHAR | 12 | 0 | Created By | ||
85 | ![]() |
ERFDATE | DATUM | DATS | 8 | 0 | Created On | ||
86 | ![]() |
ERFTIME | UZEIT | TIMS | 6 | 0 | Time Created | ||
87 | ![]() |
AENUSER | USNAM | CHAR | 12 | 0 | Last Changed By | ||
88 | ![]() |
AENDATE | DATUM | DATS | 8 | 0 | Date of Last Change | ||
89 | ![]() |
AENTIME | UZEIT | TIMS | 6 | 0 | Time of Last Change | ||
90 | ![]() |
XNEUKUNDE | XFELD | CHAR | 1 | 0 | IS-M: New customer indicator | ||
91 | ![]() |
KONKAUS | KONKAUS | CHAR | 2 | 0 | IS-M: Competitor exclusion | TJH89 | |
92 | ![]() |
XMANUSKRIP | XFELD | CHAR | 1 | 0 | IS-M: Processing of Ad Booking Details Requested Indicator | ||
93 | ![]() |
SIZE_TOL | CHAR03 | CHAR | 3 | 0 | IS-M: Deviation tolerance as a percentage value | ||
94 | ![]() |
RE_STELL | RE_STELL | CHAR | 1 | 0 | IS-M: Billing split | TJJB3 | |
95 | ![]() |
XORTSPREIS | XFELD | CHAR | 1 | 0 | IS-M/AM: Local Customer Indicator | ||
96 | ![]() |
PAM_BELART | PAM_BELART | CHAR | 4 | 0 | IS-M: Voucher Type (Proof) | TJJB1 | |
97 | ![]() |
PAM_BELANZ | NUMC5 | NUMC | 5 | 0 | IS-M: Number of Voucher Copies | ||
98 | ![]() |
XABSCHLUSS | XFELD | CHAR | 1 | 0 | IS-M: Contract Customer Indicator | ||
99 | ![]() |
MAX_UNT | NUMC2 | NUMC | 2 | 0 | IS-M: Maximum Interruption in Validity Period (in Months) | ||
100 | ![]() |
ABSCHL_BEG | ABSCHL_BEG | CHAR | 1 | 0 | IS-M: Rule for Contract Start | TJJV14 | |
101 | ![]() |
ABSCHL_END | ABSCHL_END | CHAR | 1 | 0 | IS-M: Rule for Contract End | TJJV15 | |
102 | ![]() |
ABSCHLZEIT | SYNUM02 | NUMC | 2 | 0 | IS-M: Standard Validity Period for Contracts (in Months) | ||
103 | ![]() |
ABSCHL_TOL | NUMC03 | NUMC | 3 | 0 | IS-M: Contract Tolerance Quantity for Non-Fulfillment (in %) | ||
104 | ![]() |
MIN_GUTSCH | ISPBETR07 | CURR | 7 | 2 | IS-M: De Minimis Limitation for Contract Credit Memo | ||
105 | ![]() |
MIN_LAST | ISPBETR07 | CURR | 7 | 2 | IS-M/AM: De Minimis Limitation for Contract Debit Memo | ||
106 | ![]() |
JBONITAET | JBONITAET | CHAR | 2 | 0 | IS-M: Creditworthiness Indicator | TJGJ2 | |
107 | ![]() |
XAGENTUR | XFELD | CHAR | 1 | 0 | IS-M: Agency Indicator | ||
108 | ![]() |
XAGEN_KREA | XFELD | CHAR | 1 | 0 | IS-M: Creative Boutique Indicator | ||
109 | ![]() |
XAGEN_STR | XFELD | CHAR | 1 | 0 | IS-M: Distribution Agency Indicator | ||
110 | ![]() |
XAGEN_PLAN | XFELD | CHAR | 1 | 0 | IS-M: Planning Agency Indicator | ||
111 | ![]() |
JABRKALAG | WFCID | CHAR | 2 | 0 | IS-M: Agency Billing Schedule (Calendar Identification) | TJG61 | |
112 | ![]() |
AGEN_GRUP | AGEN_GRUP | CHAR | 1 | 0 | IS-M: Agency Type | TJGJ4 | |
113 | ![]() |
JKUKARR | JKUKARR | CHAR | 2 | 0 | IS-M: Customer Profile | TJJ95 | |
114 | ![]() |
JDUBIOS | JDUBIOS | CHAR | 1 | 0 | IS-M: Credit Query Indicator | TJGJ0 | |
115 | ![]() |
KARENZANZ | JKARENZ | NUMC | 4 | 0 | IS-M/AM: Grace Period for Changes to Ad Prices | ||
116 | ![]() |
JJMEINS | MEINS | UNIT | 3 | 0 | IS-M: Basic Unit of Measure for Time | T006 | |
117 | ![]() |
KARENZDL | JKARENZ | NUMC | 4 | 0 | IS-M: Grace Period for Changes to Service Prices | ||
118 | ![]() |
JJMEINS | MEINS | UNIT | 3 | 0 | IS-M: Basic Unit of Measure for Time | T006 | |
119 | ![]() |
KARENZSI | JKARENZ | NUMC | 4 | 0 | IS-M: Grace Period for Changes to Prices of Ad Inserts | ||
120 | ![]() |
JJMEINS | MEINS | UNIT | 3 | 0 | IS-M: Basic Unit of Measure for Time | T006 | |
121 | ![]() |
KARENZVER | JKARENZ | NUMC | 4 | 0 | IS-M: Grace Period for Changes to Distribution Prices | ||
122 | ![]() |
JJMEINS | MEINS | UNIT | 3 | 0 | IS-M: Basic Unit of Measure for Time | T006 | |
123 | ![]() |
KARENZWSP | JKARENZ | NUMC | 4 | 0 | IS-M: Grace Period for Changes to Commercial Prices | ||
124 | ![]() |
JJMEINS | MEINS | UNIT | 3 | 0 | IS-M: Basic Unit of Measure for Time | T006 | |
125 | ![]() |
KARENZOL | JKARENZ | NUMC | 4 | 0 | IS-M: Grace Period for Price Changes in Online Advertising | ||
126 | ![]() |
JJMEINS | MEINS | UNIT | 3 | 0 | IS-M: Basic Unit of Measure for Time | T006 | |
127 | ![]() |
JKUNNR | KUNNR | CHAR | 10 | 0 | IS-M: Customer Number in Previous System | KNA1 | |
128 | ![]() |
VKBUR | VKBUR | CHAR | 4 | 0 | Sales office | TVBUR | |
129 | ![]() |
XVERLAG | XFELD | CHAR | 1 | 0 | IS-M: Publisher Indicator | ||
130 | ![]() |
XLOESCH | XFELD | CHAR | 1 | 0 | IS-M: Deletion Flag (Role-Specific) | ||
131 | ![]() |
XSPERR | XFELD | CHAR | 1 | 0 | IS-M: Lock Indicator (Role-Specific) | ||
132 | ![]() |
XVERLEIG | XFELD | CHAR | 1 | 0 | IS-M: Indicator: Owned By Publisher | ||
133 | ![]() |
ISPVERL | TEXT11 | CHAR | 11 | 0 | IS-M: Publisher ISPC Number - Obsolete from Rel. 3.04 | ||
134 | ![]() |
REMELD_ISP | CHAR20 | CHAR | 20 | 0 | IS-M/SD: Reference Document in Legacy System | ||
135 | ![]() |
JDUBIOS | JDUBIOS | CHAR | 1 | 0 | IS-M: Credit Query Indicator | TJGJ0 | |
136 | ![]() |
XAGENTUR | XFELD | CHAR | 1 | 0 | IS-M: Agency Indicator | ||
137 | ![]() |
XARLV | XFELD | CHAR | 1 | 0 | IS-M: Agency Deletion Flag | ||
138 | ![]() |
XLOESCHKZ | XFELD | CHAR | 1 | 0 | IS-M: Deletion Indicator (Role-Specific) | ||
139 | ![]() |
XARSPE | XFELD | CHAR | 1 | 0 | IS-M: Agency Lock Indicator | ||
140 | ![]() |
XAGEN_KREA | XFELD | CHAR | 1 | 0 | IS-M: Creative Boutique Indicator | ||
141 | ![]() |
XAGEN_STR | XFELD | CHAR | 1 | 0 | IS-M: Distribution Agency Indicator | ||
142 | ![]() |
XAGEN_PLAN | XFELD | CHAR | 1 | 0 | IS-M: Planning Agency Indicator | ||
143 | ![]() |
AGEN_GRUP | AGEN_GRUP | CHAR | 1 | 0 | IS-M: Agency Type | TJGJ4 | |
144 | ![]() |
VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | TVKO | |
145 | ![]() |
XINSERENT | XINSERENT | CHAR | 1 | 0 | IS-M: Selection Indicator for Advertiser | ||
146 | ![]() |
XISLV | XFELD | CHAR | 1 | 0 | IS-M: Advertiser Deletion Flag | ||
147 | ![]() |
XLOESCHKZ | XFELD | CHAR | 1 | 0 | IS-M: Deletion Indicator (Role-Specific) | ||
148 | ![]() |
XISSPE | XFELD | CHAR | 1 | 0 | IS-M: Advertiser Lock Indicator | ||
149 | ![]() |
STCEG | STCEG | CHAR | 20 | 0 | VAT Registration Number | ||
150 | ![]() |
FAKSD_V | FAKSP | CHAR | 2 | 0 | Billing block for customer (sales and distribution) | TVFS | |
151 | ![]() |
JHDRSTS | JHDRSTS | CHAR | 2 | 0 | IS-M: Print Control Procedure | TJJB5 | |
152 | ![]() |
JVKBUR_OFF | VKBUR | CHAR | 4 | 0 | IS-M: Alternative sales office for collecting responses | TVKBZ | |
153 | ![]() |
JHZLSCHB | ZLSCH | CHAR | 1 | 0 | IS-M/AM: Payment Method for Customer Bonus Settlement | T042Z | |
154 | ![]() |
ABSCH_ERN | JNFELD | CHAR | 1 | 0 | IS-M: Indicator: Automatic Contract Renewal | ||
155 | ![]() |
MAX_RDAT | SYNUM02 | NUMC | 2 | 0 | IS-M: Maximum Backdating Start of Validity Period (Months) | ||
156 | ![]() |
ANPASS | JNFELD | CHAR | 1 | 0 | Quantity Adjustment for Contract Validity Period Change | ||
157 | ![]() |
RABATTANP | JH_XRABANP | CHAR | 1 | 0 | IS-M: Disc./Price Adjustment During Contract Validity Period | ||
158 | ![]() |
RABSPERR | JNFELD | CHAR | 1 | 0 | IS-M: Block higher-level discounts indicator | ||
159 | ![]() |
RANPASS | JNFELD | CHAR | 1 | 0 | IS-M: Increase Discount in the Case of Over-Fulfillment Ind. | ||
160 | ![]() |
RANPASSL | JNFELD | CHAR | 1 | 0 | IS-M: Reduce Discount in the Case of Non-Fulfillment Ind. | ||
161 | ![]() |
QABR | QABR | CHAR | 1 | 0 | IS-M: Define Settlement for System Contracts | ||
162 | ![]() |
JHZLSCHA | ZLSCH | CHAR | 1 | 0 | IS-M: Payment Method for Contract Settlement | T042Z | |
163 | ![]() |
PAM_FAKSP | FAKSP | CHAR | 2 | 0 | IS-M: Billing Block | TVFS | |
164 | ![]() |
EABR_NACHL | SYNUM02 | NUMC | 2 | 0 | IS-M: Time of Final Settlement After Runtime (in Months) | ||
165 | ![]() |
BEST_PR | JNFELD | CHAR | 1 | 0 | IS-M: Apply Best Conditions to Number / Quantity | ||
166 | ![]() |
PAR_ABS | JNFELD | CHAR | 1 | 0 | IS-M: Work with Parallel Contracts Indicator | ||
167 | ![]() |
TO_WARN | JNFELD | CHAR | 1 | 0 | IS-M: Generate Advance Warning Automatically | ||
168 | ![]() |
AGEN_AE | AGEN_AE | CHAR | 1 | 0 | IS-M: Agency Commission Entitlement | ||
169 | ![]() |
AB_VOR | JNFELD | CHAR | 1 | 0 | IS-M: Advance Bonus Indicator | ||
170 | ![]() |
GR_ZTERM | GR_ZTERM | CHAR | 2 | 0 | IS-M: Terms of Payment Group | TJJB7 | |
171 | ![]() |
ARABATT | JNFELD | CHAR | 1 | 0 | IS-M: Qualifies for Contract Indicator | ||
172 | ![]() |
XCPDK | XFELD | CHAR | 1 | 0 | Indicator: Is the account a one-time account? |
Foreign Keys
History
Last changed by/on | SAP | 20131127 |
SAP Release Created in |