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 |