1. Home
  2. Resources
  3. SAP Tables
  4. JHAISZ - IS-M/AM: Assignment Table of Advertisers for OPM Order

SAP Table JHAISZ

IS-M/AM: Assignment Table of Advertisers for OPM Order

JHAISZ (IS-M/AM: Assignment Table of Advertisers for OPM Order) 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 JHAISZ to other SAP tables.

JHAISZ table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
AVM_NR IS-M/AM: Sales Document Number AVM_NR JHAK CHAR 10 0
POS_NR IS-M: Order Item Number POS_NR JHAP NUMC 3 0
INSERENT IS-M: Advertiser INSERENT JJVDB_MK_FK CHAR 10 0
XINSBLANK IS-M: Agency Order Without Advertiser Indicator XINSBLANK CHAR 1 0
X Yes
NULL No
INSZ_NR IS-M: Advertiser assignment number INSZ_NR NUMC 4 0
INS_PROZ IS-M: Percentage Figure for Cost Distribution PAM_PROZ DEC 6 3
AZGR_INS Column MM of the Ad Which the Advertiser is Involved In AZGR_INS NUMC 4 0
ALTINSGPNR IS-M: Alternative Customer Number for Advertiser ALTINSGPNR CHAR 15 0
REGULIERER IS-M: Payer REGULIERER JGTGPNR CHAR 10 0
TAXK1 Tax classification 1 for customer TAXK1 CHAR 1 0
TAXK2 Tax classification 2 for customer TAXK2 CHAR 1 0
TAXK3 Tax classification 3 for customer TAXK3 CHAR 1 0
TAXK4 Tax Classification 4 Customer TAXK4 CHAR 1 0
TAXK5 Tax classification 5 for customer TAXK5 CHAR 1 0
TAXK6 Tax classification 6 for customer TAXK6 CHAR 1 0
TAXK7 Tax classification 7 for customer TAXK7 CHAR 1 0
TAXK8 Tax classification 8 for customer TAXK8 CHAR 1 0
TAXK9 Tax classification 9 for customer TAXK9 CHAR 1 0
GPNR_RECH IS-M: Business Partner - Bill-To Party GPNR_RECH JGTGPNR CHAR 10 0
RECH_ADRNR Address ADRNR CHAR 10 0
RECH_ADVAR IS-M: Address Variant ADRESSVAR CHAR 1 0
1 Address with City/Street
2 PO Box Address
3 Major Customer Postal Code
RECH_ADHER IS-M: Use of Address HERK CHAR 1 0
1 Business Partner
2 IS-M/SD Order
3 Loading/Unloading Pt
4 Voucher Shipping
5 Divert Address
6 Shipping Order
7 Household
A Media Order
B Media Contact Person
C Media Order (One-Time)
WAERG SD Document Currency WAERK TCURC CUKY 5 0
FAKSPP IS-M: Billing Block PAM_FAKSP TVFS CHAR 2 0
XSEPFKKOPF Separate billing document for sales order XSEPFKKOPF CHAR 1 0
X Yes
NULL No
ZTERM Terms of Payment Key DZTERM CHAR 4 0
VALDT Fixed value date VALDT DATS 8 0
VALTG Additional value days VALTG NUMC 2 0
PERFK Invoice dates (calendar identification) PERFK TFACD CHAR 2 0
FAKDATUM IS-M: Planned Billing/Settlement Date JHFKTER DATS 8 0
VORAUSKNZ IS-M: Indicates Whether Advance Billing Required VORAUSKNZ CHAR 1 0
X Yes
NULL No
VORAUSRCH IS-M: "Advance billing required" indicator VORAUSRCH CHAR 1 0
X Yes
NULL No
XRECHN IS-M: Invoice Requested Indicator XRECHN CHAR 1 0
X Yes
NULL No
XKFMAEND IS-M: Business Data was Changed Manually Indicator XKFMAEND CHAR 1 0
X Yes
NULL No
KONDA Price group (customer) KONDA T188 CHAR 2 0
XORTSPREIS IS-M/AM: Local Customer Indicator XORTSPREIS CHAR 1 0
X Yes
NULL No
KALKS Pricing procedure assigned to this customer KALKS TVKD CHAR 1 0
KUKARR_K IS-M: Customer Profile JKUKARR TJJ95 CHAR 2 0
KARENZ IS-M: Grace Period for Price Changes JKARENZ NUMC 4 0
KARENZ_ME Base Unit of Measure MEINS T006 UNIT 3 0
KDGRP Customer group KDGRP T151 CHAR 2 0
KURST Exchange Rate Type KURST TCURV CHAR 4 0
PLTYP Price list type PLTYP T189 CHAR 2 0
ZLSCH Payment Method SCHZW_BSEG T042Z CHAR 1 0
AE IS-M: Agency Commission Entitlement AGEN_AE CHAR 1 0
NULL Grant agency commission as discount
N No agency commission granted
S Grant agency commission separately
BANKS Bank country key BANKS T005 CHAR 3 0
BANKL Bank Keys BANKK BNKA CHAR 15 0
BANKN Bank account number BANKN CHAR 18 0
BKONT Bank Control Key BKONT CHAR 2 0
BVTYP Partner Bank Type BVTYP CHAR 4 0
XEINZUG Indicator: Is there collection authorization ? XEZER CHAR 1 0
X Yes
NULL No
IBAN IBAN (International Bank Account Number) IBAN CHAR 34 0
XSPERR_BON IS-M: "Blocked for reasons of creditworthiness" indicator XSPERR_BON CHAR 1 0
X Yes
NULL No
VKBUR_ZUST Sales office responsible VKBURZUS CHAR 4 0
CCINS Payment cards: Card type CCINS TVCIN CHAR 4 0
CCNUM Payment cards: Card number CCNUM VCNUM CHAR 25 0
DATBI Payment Cards: Valid To DATBI_CC DATS 8 0
CCNAME Payment cards: Name of cardholder CCNAME CHAR 40 0
CVVAL Card Verification Value ISM_CVVAL CHAR 6 0
CVVCT Control Field for Card Verification Value ISM_CVVCT CHAR 1 0
0 Do Not Return Check Result
1 Return Check Result
CVVST Usage Status of Card Verification Value ISM_CVVST CHAR 1 0
0 Check Field Does not Exist
1 Check Field Exists
2 Check Field Unreadable
9 Card has no Check Field
DATE_GEN_RULE_BI IS-M: Date Rule for Generating Billing Dataset ISM_DATE_GEN_RULE_BI TJHGENBI CHAR 2 0
BRAN1 IS-M: Industry Sector for Advertiser BRAN_PAM TBRC CHAR 10 0
ADV_AD_SIZE Share of Ad Size Belonging to the Advertiser ISM_ADV_AD_SIZE QUAN 13 3
CGUID GUID of a Payment Card CARD_GUID RAW 16 0
ENCTP Type of Encryption CCSECA_ENCTYPE CHAR 1 0
1 Data in PCA_SECURITY_RAW
2 Data in CCSEC_ENC or CCSEC_ENCV
3 Data in CCARDEC
MNDID Unique Referene to Mandate per Payment Recipient SEPA_MNDID CHAR 35 0

JHAISZ foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
JHAISZ AVM_NR JHAISZ MANDT JHAK IS-M/AM: Order-Publishing-Media (Header Data) MANDT
JHAISZ AVM_NR JHAISZ AVM_NR JHAK IS-M/AM: Order-Publishing-Media (Header Data) AVM_NR
JHAISZ BANKL SYST MANDT BNKA Bank master record MANDT
JHAISZ BANKL JHAISZ BANKS BNKA Bank master record BANKS
JHAISZ BANKL JHAISZ BANKL BNKA Bank master record BANKL
JHAISZ BANKS SYST MANDT T005 Countries MANDT
JHAISZ BANKS JHAISZ BANKS T005 Countries LAND1
JHAISZ BRAN1 JHAISZ MANDT TBRC Industry Code (Customer Master) MANDT
JHAISZ BRAN1 JHAISZ BRAN1 TBRC Industry Code (Customer Master) BRACO
JHAISZ CCINS SYST MANDT TVCIN Payment cards: Type MANDT
JHAISZ CCINS JHAISZ CCINS TVCIN Payment cards: Type CCINS
JHAISZ CCNUM JHAISZ CCINS VCNUM Credit card master CCINS
JHAISZ CCNUM JHAISZ CCNUM VCNUM Credit card master CCNUM
JHAISZ CCNUM SYST MANDT VCNUM Credit card master MANDT
JHAISZ DATE_GEN_RULE_BI JHAISZ DATE_GEN_RULE_BI TJHGENBI IS-M: Date Rule for Generating Billing Dataset DATE_GEN_RULE_BI
JHAISZ DATE_GEN_RULE_BI JHAISZ MANDT TJHGENBI IS-M: Date Rule for Generating Billing Dataset MANDT
JHAISZ FAKSPP SYST MANDT TVFS Billing: Reasons for Blocking MANDT
JHAISZ FAKSPP JHAISZ FAKSPP TVFS Billing: Reasons for Blocking FAKSP
JHAISZ GPNR_RECH JHAISZ GPNR_RECH JGTGPNR IS-M: Central Business Partner Table GPNR
JHAISZ GPNR_RECH JHAISZ MANDT JGTGPNR IS-M: Central Business Partner Table MANDT
JHAISZ INSERENT JHAISZ MANDT JJVDB_MK_FK Generierte Tabelle zu einem View MANDT
JHAISZ INSERENT JHAISZ INSERENT JJVDB_MK_FK Generierte Tabelle zu einem View GPNR
JHAISZ KALKS SYST MANDT TVKD Customer Pricing Procedures MANDT
JHAISZ KALKS JHAISZ KALKS TVKD Customer Pricing Procedures KALKS
JHAISZ KARENZ_ME SYST MANDT T006 Units of Measurement MANDT
JHAISZ KARENZ_ME JHAISZ KARENZ_ME T006 Units of Measurement MSEHI
JHAISZ KDGRP SYST MANDT T151 Customers: Customer Groups MANDT
JHAISZ KDGRP JHAISZ KDGRP T151 Customers: Customer Groups KDGRP
JHAISZ KONDA JHAISZ KONDA T188 Conditions: Groups for Customer Classifications KONDA
JHAISZ KONDA SYST MANDT T188 Conditions: Groups for Customer Classifications MANDT
JHAISZ KUKARR_K SYST MANDT TJJ95 IS-M/AM: Customer Status MANDT
JHAISZ KUKARR_K JHAISZ KUKARR_K TJJ95 IS-M/AM: Customer Status KUKARR
JHAISZ KURST SYST MANDT TCURV Exchange rate types for currency translation MANDT
JHAISZ KURST JHAISZ KURST TCURV Exchange rate types for currency translation KURST
JHAISZ MANDT JHAISZ MANDT T000 Clients MANDT
JHAISZ PERFK JHAISZ PERFK TFACD Factory calendar definition IDENT
JHAISZ PLTYP SYST MANDT T189 Conditions: Price List Categories MANDT
JHAISZ PLTYP JHAISZ PLTYP T189 Conditions: Price List Categories PLTYP
JHAISZ POS_NR JHAISZ MANDT JHAP IS-M/AM: Order-Publishing-Media Item MANDT
JHAISZ POS_NR JHAISZ AVM_NR JHAP IS-M/AM: Order-Publishing-Media Item AVM_NR
JHAISZ POS_NR JHAISZ POS_NR JHAP IS-M/AM: Order-Publishing-Media Item POS_NR
JHAISZ REGULIERER JHAISZ MANDT JGTGPNR IS-M: Central Business Partner Table MANDT
JHAISZ REGULIERER JHAISZ REGULIERER JGTGPNR IS-M: Central Business Partner Table GPNR
JHAISZ WAERG SYST MANDT TCURC Currency Codes MANDT
JHAISZ WAERG JHAISZ WAERG TCURC Currency Codes WAERS
JHAISZ ZLSCH * T042Z Payment Methods for Automatic Payment LAND1
JHAISZ ZLSCH JHAISZ ZLSCH T042Z Payment Methods for Automatic Payment ZLSCH
JHAISZ ZLSCH SYST MANDT T042Z Payment Methods for Automatic Payment MANDT