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