SAP ABAP Table JHAISZ (IS-M/AM: Assignment Table of Advertisers for OPM Order)
Hierarchy
☛
IS-M (Software Component) SAP MEDIA
⤷ IS-M (Application Component) SAP Media
⤷ JAS (Package) Application development R/3 Publishing Advertising System***
⤷ IS-M (Application Component) SAP Media
⤷ JAS (Package) Application development R/3 Publishing Advertising System***
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | JHAISZ | Table Relationship Diagram |
Short Description | IS-M/AM: Assignment Table of Advertisers for OPM Order |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
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 | AVM_NR | AVM_NR | AVM_NR | CHAR | 10 | 0 | IS-M/AM: Sales Document Number | JHAK | |
3 | POS_NR | POS_NR | AVM_PNR | NUMC | 3 | 0 | IS-M: Order Item Number | JHAP | |
4 | INSERENT | INSERENT | GPNR | CHAR | 10 | 0 | IS-M: Advertiser | JJVDB_MK_FK | |
5 | XINSBLANK | XINSBLANK | XFELD | CHAR | 1 | 0 | IS-M: Agency Order Without Advertiser Indicator | ||
6 | INSZ_NR | INSZ_NR | NUMC4 | NUMC | 4 | 0 | IS-M: Advertiser assignment number | ||
7 | INS_PROZ | PAM_PROZ | JHPROZ33 | DEC | 6 | 3 | IS-M: Percentage Figure for Cost Distribution | ||
8 | AZGR_INS | AZGR_INS | NUMC4 | NUMC | 4 | 0 | Column MM of the Ad Which the Advertiser is Involved In | ||
9 | ALTINSGPNR | ALTINSGPNR | CHAR15 | CHAR | 15 | 0 | IS-M: Alternative Customer Number for Advertiser | ||
10 | REGULIERER | REGULIERER | GPNR | CHAR | 10 | 0 | IS-M: Payer | JGTGPNR | |
11 | .INCLUDE | 0 | 0 | IS-PAM: Include for Customer Tax Classification | |||||
12 | TAXK1 | TAXK1 | TAXKD | CHAR | 1 | 0 | Tax classification 1 for customer | * | |
13 | TAXK2 | TAXK2 | TAXKD | CHAR | 1 | 0 | Tax classification 2 for customer | * | |
14 | TAXK3 | TAXK3 | TAXKD | CHAR | 1 | 0 | Tax classification 3 for customer | * | |
15 | TAXK4 | TAXK4 | TAXKD | CHAR | 1 | 0 | Tax classification 4 for customer | * | |
16 | TAXK5 | TAXK5 | TAXKD | CHAR | 1 | 0 | Tax classification 5 for customer | * | |
17 | TAXK6 | TAXK6 | TAXKD | CHAR | 1 | 0 | Tax classification 6 for customer | * | |
18 | TAXK7 | TAXK7 | TAXKD | CHAR | 1 | 0 | Tax classification 7 for customer | * | |
19 | TAXK8 | TAXK8 | TAXKD | CHAR | 1 | 0 | Tax classification 8 for customer | * | |
20 | TAXK9 | TAXK9 | TAXKD | CHAR | 1 | 0 | Tax classification 9 for customer | * | |
21 | GPNR_RECH | GPNR_RECH | GPNR | CHAR | 10 | 0 | IS-M: Business Partner - Bill-To Party | JGTGPNR | |
22 | RECH_ADRNR | ADRNR | ADRNR | CHAR | 10 | 0 | Address | * | |
23 | RECH_ADVAR | ADRESSVAR | ERSTADR | CHAR | 1 | 0 | IS-M: Address Variant | ||
24 | RECH_ADHER | HERK | HERK | CHAR | 1 | 0 | IS-M: Use of Address | ||
25 | .INCLUDE | 0 | 0 | IS-PAM: Include for Business Data | |||||
26 | WAERG | WAERK | WAERS | CUKY | 5 | 0 | SD document currency | TCURC | |
27 | FAKSPP | PAM_FAKSP | FAKSP | CHAR | 2 | 0 | IS-M: Billing Block | TVFS | |
28 | XSEPFKKOPF | XSEPFKKOPF | XFELD | CHAR | 1 | 0 | Separate billing document for sales order | ||
29 | ZTERM | DZTERM | ZTERM | CHAR | 4 | 0 | Terms of payment key | ||
30 | VALDT | VALDT | DATUM | DATS | 8 | 0 | Fixed value date | ||
31 | VALTG | VALTG | TAGE2 | NUMC | 2 | 0 | Additional value days | ||
32 | PERFK | PERFK | WFCID | CHAR | 2 | 0 | Invoice dates (calendar identification) | TFACD | |
33 | FAKDATUM | JHFKTER | DATUM | DATS | 8 | 0 | IS-M: Planned Billing/Settlement Date | ||
34 | VORAUSKNZ | VORAUSKNZ | XFELD | CHAR | 1 | 0 | IS-M: Indicates Whether Advance Billing Required | ||
35 | VORAUSRCH | VORAUSRCH | XFELD | CHAR | 1 | 0 | IS-M: "Advance billing required" indicator | ||
36 | XRECHN | XRECHN | XFELD | CHAR | 1 | 0 | IS-M: Invoice Requested Indicator | ||
37 | XKFMAEND | XKFMAEND | XFELD | CHAR | 1 | 0 | IS-M: Business Data was Changed Manually Indicator | ||
38 | KONDA | KONDA | KONDA | CHAR | 2 | 0 | Price Group (Customer) | T188 | |
39 | XORTSPREIS | XORTSPREIS | XFELD | CHAR | 1 | 0 | IS-M/AM: Local Customer Indicator | ||
40 | KALKS | KALKS | KALKS | CHAR | 1 | 0 | Pricing procedure assigned to this customer | TVKD | |
41 | KUKARR_K | JKUKARR | JKUKARR | CHAR | 2 | 0 | IS-M: Customer Profile | TJJ95 | |
42 | KARENZ | JKARENZ | JKARENZ | NUMC | 4 | 0 | IS-M: Grace Period for Price Changes | ||
43 | KARENZ_ME | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | T006 | |
44 | KDGRP | KDGRP | KDGRP | CHAR | 2 | 0 | Customer group | T151 | |
45 | KURST | KURST | KURST | CHAR | 4 | 0 | Exchange Rate Type | TCURV | |
46 | PLTYP | PLTYP | PLTYP | CHAR | 2 | 0 | Price list type | T189 | |
47 | ZLSCH | SCHZW_BSEG | ZLSCH | CHAR | 1 | 0 | Payment Method | T042Z | |
48 | AE | AGEN_AE | AGEN_AE | CHAR | 1 | 0 | IS-M: Agency Commission Entitlement | ||
49 | .INCLUDE | 0 | 0 | IS-PAM: INCLUDE for bank data | |||||
50 | BANKS | BANKS | LAND1 | CHAR | 3 | 0 | Bank country key | T005 | |
51 | BANKL | BANKK | BANKK | CHAR | 15 | 0 | Bank Keys | BNKA | |
52 | BANKN | BANKN | BANKN | CHAR | 18 | 0 | Bank account number | ||
53 | BKONT | BKONT | BKONT | CHAR | 2 | 0 | Bank Control Key | ||
54 | BVTYP | BVTYP | BVTYP | CHAR | 4 | 0 | Partner bank type | ||
55 | XEINZUG | XEZER | XFELD | CHAR | 1 | 0 | Indicator: Is there collection authorization ? | ||
56 | .INCLUDE | 0 | 0 | IS-M/AM: Include for IBAN | |||||
57 | IBAN | IBAN | IBAN | CHAR | 34 | 0 | IBAN (International Bank Account Number) | ||
58 | XSPERR_BON | XSPERR_BON | XFELD | CHAR | 1 | 0 | IS-M: "Blocked for reasons of creditworthiness" indicator | ||
59 | VKBUR_ZUST | VKBURZUS | VKBUR | CHAR | 4 | 0 | Sales office responsible | * | |
60 | .INCLUDE | 0 | 0 | IS-M/AM: Payment cards: Projection of RJH_CCDATA | |||||
61 | CCINS | CCINS | CCINS | CHAR | 4 | 0 | Payment cards: Card type | TVCIN | |
62 | CCNUM | CCNUM | CCNUM | CHAR | 25 | 0 | Payment cards: Card number | VCNUM | |
63 | DATBI | DATBI_CC | DATUM | DATS | 8 | 0 | Payment Cards: Valid To | ||
64 | CCNAME | CCNAME | TEXT40 | CHAR | 40 | 0 | Payment Cards: Name of Cardholder | ||
65 | .INCLUDE | 0 | 0 | IS-M/AM: Card Verification Value | |||||
66 | CVVAL | ISM_CVVAL | ISM_CVVAL | CHAR | 6 | 0 | Card Verification Value | ||
67 | CVVCT | ISM_CVVCT | ISM_CVVCT | CHAR | 1 | 0 | Control Field for Card Verification Value | ||
68 | CVVST | ISM_CVVST | ISM_CVVST | CHAR | 1 | 0 | Usage Status of Card Verification Value | ||
69 | DATE_GEN_RULE_BI | ISM_DATE_GEN_RULE_BI | ISM_DATE_GEN_RULE_BI | CHAR | 2 | 0 | IS-M: Date Rule for Generating Billing Dataset | TJHGENBI | |
70 | BRAN1 | BRAN_PAM | BRACO | CHAR | 10 | 0 | IS-M: Industry Sector for Advertiser | TBRC | |
71 | ADV_AD_SIZE | ISM_ADV_AD_SIZE | MENGE13 | QUAN | 13 | 3 | Share of Ad Size Belonging to the Advertiser | ||
72 | .INCLUDE | 0 | 0 | Credit Card Encryption | |||||
73 | CGUID | CARD_GUID | SYSUUID | RAW | 16 | 0 | GUID of a Payment Card | ||
74 | ENCTP | CCSECA_ENCTYPE | CCSECA_ENCTYPE | CHAR | 1 | 0 | Type of Encryption | ||
75 | .INCLUDE | 0 | 0 | IS-M/AM: Include for SEPA Mandates | |||||
76 | MNDID | SEPA_MNDID | ID035 | CHAR | 35 | 0 | Unique Referene to Mandate per Payment Recipient |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | JHAISZ | AVM_NR | JHAK | AVM_NR | KEY | 1 | CN |
2 | JHAISZ | BANKL | BNKA | BANKL | |||
3 | JHAISZ | BANKS | T005 | LAND1 | REF | C | CN |
4 | JHAISZ | BRAN1 | TBRC | BRACO | |||
5 | JHAISZ | CCINS | TVCIN | CCINS | REF | 1 | CN |
6 | JHAISZ | CCNUM | VCNUM | CCNUM | REF | 1 | CN |
7 | JHAISZ | DATE_GEN_RULE_BI | TJHGENBI | DATE_GEN_RULE_BI | REF | 1 | CN |
8 | JHAISZ | FAKSPP | TVFS | FAKSP | |||
9 | JHAISZ | GPNR_RECH | JGTGPNR | GPNR | REF | 1 | CN |
10 | JHAISZ | INSERENT | JJVDB_MK_FK | GPNR | KEY | 1 | CN |
11 | JHAISZ | KALKS | TVKD | KALKS | |||
12 | JHAISZ | KARENZ_ME | T006 | MSEHI | KEY | 1 | CN |
13 | JHAISZ | KDGRP | T151 | KDGRP | REF | 1 | CN |
14 | JHAISZ | KONDA | T188 | KONDA | |||
15 | JHAISZ | KUKARR_K | TJJ95 | KUKARR | |||
16 | JHAISZ | KURST | TCURV | KURST | REF | 1 | CN |
17 | JHAISZ | MANDT | T000 | MANDT | KEY | 1 | CN |
18 | JHAISZ | PERFK | TFACD | IDENT | |||
19 | JHAISZ | PLTYP | T189 | PLTYP | REF | 1 | CN |
20 | JHAISZ | POS_NR | JHAP | POS_NR | KEY | 1 | CN |
21 | JHAISZ | REGULIERER | JGTGPNR | GPNR | REF | 1 | CN |
22 | JHAISZ | WAERG | TCURC | WAERS | 1 | CN | |
23 | JHAISZ | ZLSCH | T042Z | ZLSCH | REF | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |