SAP Table JJIVM
IS-PAM: Media sales area customer (data part)
JJIVM (IS-PAM: Media sales area customer (data part)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link JJIVM to other SAP tables.
JJIVM table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MK_LOEVM
Deletion Flag for Master Data in Media Sales & Distribution
|
LOEVM_ISP |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
MK_LOEKZ
Deletion Indicator for Master Data in Media Sales & Dist.
|
LOEKZ_ISP |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
ERFUSER
Created By
|
ERFUSER |
CHAR
|
12 | 0 | ||||||||||||
|
ERFDATE
Created On
|
ERFDATE |
DATS
|
8 | 0 | ||||||||||||
|
ERFTIME
Time Created
|
ERFTIME |
TIMS
|
6 | 0 | ||||||||||||
|
AENUSER
Last Changed By
|
AENUSER |
CHAR
|
12 | 0 | ||||||||||||
|
AENDATE
Date of Last Change
|
AENDATE |
DATS
|
8 | 0 | ||||||||||||
|
AENTIME
Time of Last Change
|
AENTIME |
TIMS
|
6 | 0 | ||||||||||||
|
XNK
IS-M: New customer indicator
|
XNEUKUNDE |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
KUKARR
IS-M: Customer Profile
|
JKUKARR | TJJ95 |
CHAR
|
2 | 0 | |||||||||||
|
KONKAUS
IS-M: Competitor exclusion
|
KONKAUS | TJH89 |
CHAR
|
2 | 0 | |||||||||||
|
MK_XAGEN
IS-M: Agency Indicator
|
XAGENTUR |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
MK_XSTR
IS-M: Distribution Agency Indicator
|
XAGEN_STR |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
MK_XPLAN
IS-M: Planning Agency Indicator
|
XAGEN_PLAN |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
MK_XART
IS-M: Creative Boutique Indicator
|
XAGEN_KREA |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
MK_ABRKAG
IS-M: Agency Billing Schedule (Calendar Identification)
|
JABRKALAG | TJG61 |
CHAR
|
2 | 0 | |||||||||||
|
MKAGEN_GRU
IS-M: Agency Type
|
AGEN_GRUP | TJGJ4 |
CHAR
|
1 | 0 | |||||||||||
|
AE
IS-M: Agency Commission Entitlement
|
AGEN_AE |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
MK_DUB
IS-M: Credit Query Indicator
|
JDUBIOS | TJGJ0 |
CHAR
|
1 | 0 | |||||||||||
|
MK_BON
IS-M: Creditworthiness Indicator
|
JBONITAET | TJGJ2 |
CHAR
|
2 | 0 | |||||||||||
|
XMAN
IS-M: Processing of Ad Booking Details Requested Indicator
|
XMANUSKRIP |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
ZTEGR
IS-M: Terms of Payment Group
|
GR_ZTERM | TJJB7 |
CHAR
|
2 | 0 | |||||||||||
|
TOL
IS-M: Deviation tolerance as a percentage value
|
SIZE_TOL |
CHAR
|
3 | 0 | ||||||||||||
|
RE_STELL
IS-M: Billing split
|
RE_STELL | TJJB3 |
CHAR
|
1 | 0 | |||||||||||
|
DRSTS
IS-M: Print Control Procedure
|
JHDRSTS | TJJB5 |
CHAR
|
2 | 0 | |||||||||||
|
XORTSPR
IS-M/AM: Local Customer Indicator
|
XORTSPREIS |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
VKBOF
IS-M: Alternative sales office for collecting responses
|
JVKBUR_OFF | TVKBZ |
CHAR
|
4 | 0 | |||||||||||
|
BLART
IS-M: Voucher Type (Proof)
|
PAM_BELART | TJJB1 |
CHAR
|
4 | 0 | |||||||||||
|
BLANZ
IS-M: Number of Voucher Copies
|
PAM_BELANZ |
NUMC
|
5 | 0 | ||||||||||||
|
ZLSCHB
IS-M/AM: Payment Method for Customer Bonus Settlement
|
JHZLSCHB | T042Z |
CHAR
|
1 | 0 | |||||||||||
|
K_ANZ
IS-M/AM: Grace Period for Changes to Ad Prices
|
KARENZANZ |
NUMC
|
4 | 0 | ||||||||||||
|
K_ANZ_ME
IS-M: Basic Unit of Measure for Time
|
JJMEINS | T006 |
UNIT
|
3 | 0 | |||||||||||
|
K_DL
IS-M: Grace Period for Changes to Service Prices
|
KARENZDL |
NUMC
|
4 | 0 | ||||||||||||
|
K_DL_ME
IS-M: Basic Unit of Measure for Time
|
JJMEINS | T006 |
UNIT
|
3 | 0 | |||||||||||
|
K_SI
IS-M: Grace Period for Changes to Prices of Ad Inserts
|
KARENZSI |
NUMC
|
4 | 0 | ||||||||||||
|
K_SI_ME
IS-M: Basic Unit of Measure for Time
|
JJMEINS | T006 |
UNIT
|
3 | 0 | |||||||||||
|
K_VER
IS-M: Grace Period for Changes to Distribution Prices
|
KARENZVER |
NUMC
|
4 | 0 | ||||||||||||
|
K_VER_ME
IS-M: Basic Unit of Measure for Time
|
JJMEINS | T006 |
UNIT
|
3 | 0 | |||||||||||
|
K_WSP
IS-M: Grace Period for Changes to Commercial Prices
|
KARENZWSP |
NUMC
|
4 | 0 | ||||||||||||
|
K_WSP_ME
IS-M: Basic Unit of Measure for Time
|
JJMEINS | T006 |
UNIT
|
3 | 0 | |||||||||||
|
K_OL
IS-M: Grace Period for Price Changes in Online Advertising
|
KARENZOL |
NUMC
|
4 | 0 | ||||||||||||
|
K_OL_ME
IS-M: Basic Unit of Measure for Time
|
JJMEINS | T006 |
UNIT
|
3 | 0 | |||||||||||
|
XABSCHL
IS-M: Contract Customer Indicator
|
XABSCHLUSS |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
ABE
IS-M: Indicator: Automatic Contract Renewal
|
ABSCH_ERN |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
MAX_UNT
IS-M: Maximum Interruption in Validity Period (in Months)
|
MAX_UNT |
NUMC
|
2 | 0 | ||||||||||||
|
MAX_RDAT
IS-M: Maximum Backdating Start of Validity Period (Months)
|
MAX_RDAT |
NUMC
|
2 | 0 | ||||||||||||
|
MENGA
Quantity Adjustment for Contract Validity Period Change
|
ANPASS |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
ARAB
IS-M: Qualifies for Contract Indicator
|
ARABATT |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
RABA
IS-M: Disc./Price Adjustment During Contract Validity Period
|
RABATTANP |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
RABSPERR
IS-M: Block higher-level discounts indicator
|
RABSPERR |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
RANPASS
IS-M: Increase Discount in the Case of Over-Fulfillment Ind.
|
RANPASS |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
RANPASSL
IS-M: Reduce Discount in the Case of Non-Fulfillment Ind.
|
RANPASSL |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
QABR
IS-M: Define Settlement for System Contracts
|
QABR |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
B_AUSR
IS-M: Rule for Contract Start
|
ABSCHL_BEG | TJJV14 |
CHAR
|
1 | 0 | |||||||||||
|
E_AUSR
IS-M: Rule for Contract End
|
ABSCHL_END | TJJV15 |
CHAR
|
1 | 0 | |||||||||||
|
REG_DAU
IS-M: Standard Validity Period for Contracts (in Months)
|
ABSCHLZEIT |
NUMC
|
2 | 0 | ||||||||||||
|
AB_TOL
IS-M: Contract Tolerance Quantity for Non-Fulfillment (in %)
|
ABSCHL_TOL |
NUMC
|
3 | 0 | ||||||||||||
|
ZLSCHA
IS-M: Payment Method for Contract Settlement
|
JHZLSCHA | T042Z |
CHAR
|
1 | 0 | |||||||||||
|
FAKSA
IS-M: Billing Block
|
PAM_FAKSP | TVFS |
CHAR
|
2 | 0 | |||||||||||
|
EABR_NACHL
IS-M: Time of Final Settlement After Runtime (in Months)
|
EABR_NACHL |
NUMC
|
2 | 0 | ||||||||||||
|
BEST_PR
IS-M: Apply Best Conditions to Number / Quantity
|
BEST_PR |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
PAR_ABS
IS-M: Work with Parallel Contracts Indicator
|
PAR_ABS |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
AB_VOR
IS-M: Advance Bonus Indicator
|
AB_VOR |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
TO_WARN
IS-M: Generate Advance Warning Automatically
|
TO_WARN |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
MIN_GUT
IS-M: De Minimis Limitation for Contract Credit Memo
|
MIN_GUTSCH |
CURR
|
7 | 2 | ||||||||||||
|
MIN_LAST
IS-M/AM: De Minimis Limitation for Contract Debit Memo
|
MIN_LAST |
CURR
|
7 | 2 | ||||||||||||
JJIVM foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| JJIVM | BLART | SYST | MANDT |
TJJB1
IS-M/AM: Document Type
|
MANDT |
| JJIVM | BLART | JJIVM | BLART |
TJJB1
IS-M/AM: Document Type
|
BLART |
| JJIVM | B_AUSR | JJIVM | B_AUSR |
TJJV14
IS-M: Rules for Start of Contract Validity Period
|
B_AUSR |
| JJIVM | DRSTS | SYST | MANDT |
TJJB5
IS-M/AM: Print Control Procedure
|
MANDT |
| JJIVM | DRSTS | JJIVM | DRSTS |
TJJB5
IS-M/AM: Print Control Procedure
|
DRSTS |
| JJIVM | E_AUSR | JJIVM | E_AUSR |
TJJV15
IS-M: Rules for End of Contract Validity Period
|
E_AUSR |
| JJIVM | FAKSA | SYST | MANDT |
TVFS
Billing: Reasons for Blocking
|
MANDT |
| JJIVM | FAKSA | JJIVM | FAKSA |
TVFS
Billing: Reasons for Blocking
|
FAKSP |
| JJIVM | KONKAUS | JJIVM | KONKAUS |
TJH89
IS-M/AM: Competitor Exclusion
|
KONKAUS |
| JJIVM | KONKAUS | SYST | MANDT |
TJH89
IS-M/AM: Competitor Exclusion
|
MANDT |
| JJIVM | KUKARR | SYST | MANDT |
TJJ95
IS-M/AM: Customer Status
|
MANDT |
| JJIVM | KUKARR | JJIVM | KUKARR |
TJJ95
IS-M/AM: Customer Status
|
KUKARR |
| JJIVM | K_ANZ_ME | SYST | MANDT |
T006
Units of Measurement
|
MANDT |
| JJIVM | K_ANZ_ME | JJIVM | K_ANZ_ME |
T006
Units of Measurement
|
MSEHI |
| JJIVM | K_DL_ME | SYST | MANDT |
T006
Units of Measurement
|
MANDT |
| JJIVM | K_DL_ME | JJIVM | K_DL_ME |
T006
Units of Measurement
|
MSEHI |
| JJIVM | K_OL_ME | SYST | MANDT |
T006
Units of Measurement
|
MANDT |
| JJIVM | K_OL_ME | JJIVM | K_OL_ME |
T006
Units of Measurement
|
MSEHI |
| JJIVM | K_SI_ME | SYST | MANDT |
T006
Units of Measurement
|
MANDT |
| JJIVM | K_SI_ME | JJIVM | K_SI_ME |
T006
Units of Measurement
|
MSEHI |
| JJIVM | K_VER_ME | SYST | MANDT |
T006
Units of Measurement
|
MANDT |
| JJIVM | K_VER_ME | JJIVM | K_VER_ME |
T006
Units of Measurement
|
MSEHI |
| JJIVM | K_WSP_ME | JJIVM | K_WSP_ME |
T006
Units of Measurement
|
MSEHI |
| JJIVM | K_WSP_ME | SYST | MANDT |
T006
Units of Measurement
|
MANDT |
| JJIVM | MKAGEN_GRU | SYST | MANDT |
TJGJ4
IS-M/SD: Indicator for Agency Type
|
MANDT |
| JJIVM | MKAGEN_GRU | JJIVM | MKAGEN_GRU |
TJGJ4
IS-M/SD: Indicator for Agency Type
|
AGEN_GRU |
| JJIVM | MK_ABRKAG | SYST | MANDT |
TJG61
IS-M/SD: Billing Calendar for BP
|
MANDT |
| JJIVM | MK_ABRKAG | JJIVM | MK_ABRKAG |
TJG61
IS-M/SD: Billing Calendar for BP
|
IDENT |
| JJIVM | MK_BON | SYST | MANDT |
TJGJ2
IS-M/SD: Credit Query Indicator
|
MANDT |
| JJIVM | MK_BON | JJIVM | MK_BON |
TJGJ2
IS-M/SD: Credit Query Indicator
|
BONITAET |
| JJIVM | MK_DUB | SYST | MANDT |
TJGJ0
IS-M/SD: Credit Query Indicator
|
MANDT |
| JJIVM | MK_DUB | JJIVM | MK_DUB |
TJGJ0
IS-M/SD: Credit Query Indicator
|
DUBIOS |
| JJIVM | RE_STELL | SYST | MANDT |
TJJB3
IS-M/AM: Billing Split
|
MANDT |
| JJIVM | RE_STELL | JJIVM | RE_STELL |
TJJB3
IS-M/AM: Billing Split
|
RE_STELL |
| JJIVM | VKBOF | JJTVM | VKORG |
TVKBZ
Org.Unit: Sales Office: Assignment to Organizational Unit
|
VKORG |
| JJIVM | VKBOF | JJTVM | VTWEG |
TVKBZ
Org.Unit: Sales Office: Assignment to Organizational Unit
|
VTWEG |
| JJIVM | VKBOF | JJTVM | SPART |
TVKBZ
Org.Unit: Sales Office: Assignment to Organizational Unit
|
SPART |
| JJIVM | VKBOF | JJIVM | VKBOF |
TVKBZ
Org.Unit: Sales Office: Assignment to Organizational Unit
|
VKBUR |
| JJIVM | VKBOF | SYST | MANDT |
TVKBZ
Org.Unit: Sales Office: Assignment to Organizational Unit
|
MANDT |
| JJIVM | ZLSCHA | SYST | MANDT |
T042Z
Payment Methods for Automatic Payment
|
MANDT |
| JJIVM | ZLSCHA | JGTSADR | LAND1 |
T042Z
Payment Methods for Automatic Payment
|
LAND1 |
| JJIVM | ZLSCHA | JJIVM | ZLSCHA |
T042Z
Payment Methods for Automatic Payment
|
ZLSCH |
| JJIVM | ZLSCHB | JGTSADR | LAND1 |
T042Z
Payment Methods for Automatic Payment
|
LAND1 |
| JJIVM | ZLSCHB | JJIVM | ZLSCHB |
T042Z
Payment Methods for Automatic Payment
|
ZLSCH |
| JJIVM | ZLSCHB | SYST | MANDT |
T042Z
Payment Methods for Automatic Payment
|
MANDT |
| JJIVM | ZTEGR | SYST | MANDT |
TJJB7
IS-M/AM: Terms of Payment Group
|
MANDT |
| JJIVM | ZTEGR | JJIVM | ZTEGR |
TJJB7
IS-M/AM: Terms of Payment Group
|
ZTEGR |