JHAISZ SAP (IS-M/AM: Assignment Table of Advertisers for OPM Order) Table details

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




ABAP Code to SELECT data from JHAISZ
Related tables to JHAISZ
Access table JHAISZ




Table field list including key, data, relationships and ABAP select examples

JHAISZ is a standard SAP Table which is used to store IS-M/AM: Assignment Table of Advertisers for OPM Order data and is available within R/3 SAP systems depending on the version and release level.

The JHAISZ table consists of various fields, each holding specific information or linking keys about IS-M/AM: Assignment Table of Advertisers for OPM Order data available in SAP. These include AVM_NR (IS-M/AM: Sales Document Number), POS_NR (IS-M: Order Item Number), INSERENT (IS-M: Advertiser), XINSBLANK (IS-M: Agency Order Without Advertiser Indicator).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP JHAISZ table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
AVM_NRIS-M/AM: Sales Document Number AVM_NRCHAR10JHAKALPHAAVM_NRJHAMJHA
POS_NRIS-M: Order Item Number POS_NRNUMC3JHAPAVM_PNR
INSERENTIS-M: Advertiser INSERENTCHAR10JJVDB_MK_FKALPHAGPNRJGPMJG0M
XINSBLANKIS-M: Agency Order Without Advertiser Indicator XINSBLANKCHAR1XFELD
INSZ_NRIS-M: Advertiser assignment number INSZ_NRNUMC4NUMC4
INS_PROZIS-M: Percentage Figure for Cost Distribution PAM_PROZDEC6(3) JHPROZ33
AZGR_INSColumn MM of the Ad Which the Advertiser is Involved In AZGR_INSNUMC4NUMC4
ALTINSGPNRIS-M: Alternative Customer Number for Advertiser ALTINSGPNRCHAR15CHAR15
REGULIERERIS-M: Payer REGULIERERCHAR10JGTGPNRALPHAGPNRMJG0
TAXK1Tax classification 1 for customer TAXK1CHAR1Assigned to domainTAXKD
TAXK2Tax classification 2 for customer TAXK2CHAR1Assigned to domainTAXKD
TAXK3Tax classification 3 for customer TAXK3CHAR1Assigned to domainTAXKD
TAXK4Tax Classification 4 Customer TAXK4CHAR1Assigned to domainTAXKD
TAXK5Tax classification 5 for customer TAXK5CHAR1Assigned to domainTAXKD
TAXK6Tax classification 6 for customer TAXK6CHAR1Assigned to domainTAXKD
TAXK7Tax classification 7 for customer TAXK7CHAR1Assigned to domainTAXKD
TAXK8Tax classification 8 for customer TAXK8CHAR1Assigned to domainTAXKD
TAXK9Tax classification 9 for customer TAXK9CHAR1Assigned to domainTAXKD
GPNR_RECHIS-M: Business Partner - Bill-To Party GPNR_RECHCHAR10JGTGPNRALPHAGPNRKUN
RECH_ADRNRAddress ADRNRCHAR10Assigned to domainALPHAADRNR
RECH_ADVARIS-M: Address Variant ADRESSVARCHAR1ERSTADR
RECH_ADHERIS-M: Use of Address HERKCHAR1HERK
WAERGSD Document Currency WAERKCUKY5TCURCWAERSFWS
FAKSPPIS-M: Billing Block PAM_FAKSPCHAR2TVFSFAKSP
XSEPFKKOPFSeparate billing document for sales order XSEPFKKOPFCHAR1XFELD
ZTERMTerms of Payment Key DZTERMCHAR4ZTERM
VALDTFixed value date VALDTDATS8DATUM
VALTGAdditional value days VALTGNUMC2TAGE2
PERFKInvoice dates (calendar identification) PERFKCHAR2TFACDWFCID
FAKDATUMIS-M: Planned Billing/Settlement Date JHFKTERDATS8DATUM
VORAUSKNZIS-M: Indicates Whether Advance Billing Required VORAUSKNZCHAR1XFELD
VORAUSRCHIS-M: 'Advance billing required' indicator VORAUSRCHCHAR1XFELD
XRECHNIS-M: Invoice Requested Indicator XRECHNCHAR1XFELD
XKFMAENDIS-M: Business Data was Changed Manually Indicator XKFMAENDCHAR1XFELD
KONDAPrice group (customer) KONDACHAR2T188KONDAVKA
XORTSPREISIS-M/AM: Local Customer Indicator XORTSPREISCHAR1XFELD
KALKSPricing procedure assigned to this customer KALKSCHAR1TVKDKALKS
KUKARR_KIS-M: Customer Profile JKUKARRCHAR2TJJ95ALPHAJKUKARR
KARENZIS-M: Grace Period for Price Changes JKARENZNUMC4JKARENZ
KARENZ_MEBase Unit of Measure MEINSUNIT3T006CUNITMEINS
KDGRPCustomer group KDGRPCHAR2T151KDGRPVKD
KURSTExchange Rate Type KURSTCHAR4TCURVKURSTKUT
PLTYPPrice list type PLTYPCHAR2T189PLTYPVPL
ZLSCHPayment Method SCHZW_BSEGCHAR1T042ZZLSCH
AEIS-M: Agency Commission Entitlement AGEN_AECHAR1AGEN_AE
BANKSBank country key BANKSCHAR3T005LAND1BKL
BANKLBank Keys BANKKCHAR15BNKABANKKBNK
BANKNBank account number BANKNCHAR18BANKN
BKONTBank Control Key BKONTCHAR2BKONT
BVTYPPartner Bank Type BVTYPCHAR4BVTYP
XEINZUGIndicator: Is there collection authorization ? XEZERCHAR1XFELD
IBANIBAN (International Bank Account Number) IBANCHAR34IBAN
XSPERR_BONIS-M: 'Blocked for reasons of creditworthiness' indicator XSPERR_BONCHAR1XFELD
VKBUR_ZUSTSales office responsible VKBURZUSCHAR4Assigned to domainVKBUR
CCINSPayment cards: Card type CCINSCHAR4TVCINCCINS
CCNUMPayment cards: Card number CCNUMCHAR25VCNUMCCNUM
DATBIPayment Cards: Valid To DATBI_CCDATS8DATUM
CCNAMEPayment cards: Name of cardholder CCNAMECHAR40TEXT40
CVVALCard Verification Value ISM_CVVALCHAR6ISM_CVVAL
CVVCTControl Field for Card Verification Value ISM_CVVCTCHAR1ISM_CVVCT
CVVSTUsage Status of Card Verification Value ISM_CVVSTCHAR1ISM_CVVST
DATE_GEN_RULE_BIIS-M: Date Rule for Generating Billing Dataset ISM_DATE_GEN_RULE_BICHAR2TJHGENBIISM_DATE_GEN_RULE_BI
BRAN1IS-M: Industry Sector for Advertiser BRAN_PAMCHAR10TBRCBRACO
ADV_AD_SIZEShare of Ad Size Belonging to the Advertiser ISM_ADV_AD_SIZEQUAN13(3) MENGE13
CGUIDGUID of a Payment Card CARD_GUIDRAW16SYSUUID
ENCTPType of Encryption CCSECA_ENCTYPECHAR1CCSECA_ENCTYPE
MNDIDUnique Referene to Mandate per Payment Recipient SEPA_MNDIDCHAR35ID035

Key field Non-key field



How do I retrieve data from SAP table JHAISZ using ABAP code

The following ABAP code Example will allow you to do a basic selection on JHAISZ to SELECT all data from the table
DATA: WA_JHAISZ TYPE JHAISZ.

SELECT SINGLE *
FROM JHAISZ
INTO CORRESPONDING FIELDS OF WA_JHAISZ
WHERE...

How to access SAP table JHAISZ

Within an ECC or HANA version of SAP you can also view further information about JHAISZ and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!