SAP ABAP Table RJHA452 (IS-M/AM: Screen Structure for Advertiser Assignment)
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 | INTTAB | Structure |
Structure | RJHA452 | Table Relationship Diagram |
Short Description | IS-M/AM: Screen Structure for Advertiser Assignment |
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 | MARK | XFELD | XFELD | CHAR | 1 | 0 | Checkbox | ||
2 | .INCLUDE | 0 | 0 | IS-M/AM: Assignment Table of Advertisers for OPM Order | |||||
3 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
4 | AVM_NR | AVM_NR | AVM_NR | CHAR | 10 | 0 | IS-M/AM: Sales Document Number | JHAK | |
5 | POS_NR | POS_NR | AVM_PNR | NUMC | 3 | 0 | IS-M: Order Item Number | JHAP | |
6 | INSERENT | INSERENT | GPNR | CHAR | 10 | 0 | IS-M: Advertiser | JJVDB_MK_FK | |
7 | XINSBLANK | XINSBLANK | XFELD | CHAR | 1 | 0 | IS-M: Agency Order Without Advertiser Indicator | ||
8 | INSZ_NR | INSZ_NR | NUMC4 | NUMC | 4 | 0 | IS-M: Advertiser assignment number | ||
9 | INS_PROZ | PAM_PROZ | JHPROZ33 | DEC | 6 | 3 | IS-M: Percentage Figure for Cost Distribution | ||
10 | AZGR_INS | AZGR_INS | NUMC4 | NUMC | 4 | 0 | Column MM of the Ad Which the Advertiser is Involved In | ||
11 | ALTINSGPNR | ALTINSGPNR | CHAR15 | CHAR | 15 | 0 | IS-M: Alternative Customer Number for Advertiser | ||
12 | REGULIERER | REGULIERER | GPNR | CHAR | 10 | 0 | IS-M: Payer | JGTGPNR | |
13 | .INCLUDE | 0 | 0 | IS-PAM: Include for Customer Tax Classification | |||||
14 | TAXK1 | TAXK1 | TAXKD | CHAR | 1 | 0 | Tax classification 1 for customer | * | |
15 | TAXK2 | TAXK2 | TAXKD | CHAR | 1 | 0 | Tax classification 2 for customer | * | |
16 | TAXK3 | TAXK3 | TAXKD | CHAR | 1 | 0 | Tax classification 3 for customer | * | |
17 | TAXK4 | TAXK4 | TAXKD | CHAR | 1 | 0 | Tax classification 4 for customer | * | |
18 | TAXK5 | TAXK5 | TAXKD | CHAR | 1 | 0 | Tax classification 5 for customer | * | |
19 | TAXK6 | TAXK6 | TAXKD | CHAR | 1 | 0 | Tax classification 6 for customer | * | |
20 | TAXK7 | TAXK7 | TAXKD | CHAR | 1 | 0 | Tax classification 7 for customer | * | |
21 | TAXK8 | TAXK8 | TAXKD | CHAR | 1 | 0 | Tax classification 8 for customer | * | |
22 | TAXK9 | TAXK9 | TAXKD | CHAR | 1 | 0 | Tax classification 9 for customer | * | |
23 | GPNR_RECH | GPNR_RECH | GPNR | CHAR | 10 | 0 | IS-M: Business Partner - Bill-To Party | JGTGPNR | |
24 | RECH_ADRNR | ADRNR | ADRNR | CHAR | 10 | 0 | Address | * | |
25 | RECH_ADVAR | ADRESSVAR | ERSTADR | CHAR | 1 | 0 | IS-M: Address Variant | ||
26 | RECH_ADHER | HERK | HERK | CHAR | 1 | 0 | IS-M: Use of Address | ||
27 | .INCLUDE | 0 | 0 | IS-PAM: Include for Business Data | |||||
28 | WAERG | WAERK | WAERS | CUKY | 5 | 0 | SD document currency | TCURC | |
29 | FAKSPP | PAM_FAKSP | FAKSP | CHAR | 2 | 0 | IS-M: Billing Block | TVFS | |
30 | XSEPFKKOPF | XSEPFKKOPF | XFELD | CHAR | 1 | 0 | Separate billing document for sales order | ||
31 | ZTERM | DZTERM | ZTERM | CHAR | 4 | 0 | Terms of payment key | ||
32 | VALDT | VALDT | DATUM | DATS | 8 | 0 | Fixed value date | ||
33 | VALTG | VALTG | TAGE2 | NUMC | 2 | 0 | Additional value days | ||
34 | PERFK | PERFK | WFCID | CHAR | 2 | 0 | Invoice dates (calendar identification) | TFACD | |
35 | FAKDATUM | JHFKTER | DATUM | DATS | 8 | 0 | IS-M: Planned Billing/Settlement Date | ||
36 | VORAUSKNZ | VORAUSKNZ | XFELD | CHAR | 1 | 0 | IS-M: Indicates Whether Advance Billing Required | ||
37 | VORAUSRCH | VORAUSRCH | XFELD | CHAR | 1 | 0 | IS-M: "Advance billing required" indicator | ||
38 | XRECHN | XRECHN | XFELD | CHAR | 1 | 0 | IS-M: Invoice Requested Indicator | ||
39 | XKFMAEND | XKFMAEND | XFELD | CHAR | 1 | 0 | IS-M: Business Data was Changed Manually Indicator | ||
40 | KONDA | KONDA | KONDA | CHAR | 2 | 0 | Price Group (Customer) | T188 | |
41 | XORTSPREIS | XORTSPREIS | XFELD | CHAR | 1 | 0 | IS-M/AM: Local Customer Indicator | ||
42 | KALKS | KALKS | KALKS | CHAR | 1 | 0 | Pricing procedure assigned to this customer | TVKD | |
43 | KUKARR_K | JKUKARR | JKUKARR | CHAR | 2 | 0 | IS-M: Customer Profile | TJJ95 | |
44 | KARENZ | JKARENZ | JKARENZ | NUMC | 4 | 0 | IS-M: Grace Period for Price Changes | ||
45 | KARENZ_ME | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | T006 | |
46 | KDGRP | KDGRP | KDGRP | CHAR | 2 | 0 | Customer group | T151 | |
47 | KURST | KURST | KURST | CHAR | 4 | 0 | Exchange Rate Type | TCURV | |
48 | PLTYP | PLTYP | PLTYP | CHAR | 2 | 0 | Price list type | T189 | |
49 | ZLSCH | SCHZW_BSEG | ZLSCH | CHAR | 1 | 0 | Payment Method | T042Z | |
50 | AE | AGEN_AE | AGEN_AE | CHAR | 1 | 0 | IS-M: Agency Commission Entitlement | ||
51 | .INCLUDE | 0 | 0 | IS-PAM: INCLUDE for bank data | |||||
52 | BANKS | BANKS | LAND1 | CHAR | 3 | 0 | Bank country key | T005 | |
53 | BANKL | BANKK | BANKK | CHAR | 15 | 0 | Bank Keys | BNKA | |
54 | BANKN | BANKN | BANKN | CHAR | 18 | 0 | Bank account number | ||
55 | BKONT | BKONT | BKONT | CHAR | 2 | 0 | Bank Control Key | ||
56 | BVTYP | BVTYP | BVTYP | CHAR | 4 | 0 | Partner bank type | ||
57 | XEINZUG | XEZER | XFELD | CHAR | 1 | 0 | Indicator: Is there collection authorization ? | ||
58 | .INCLUDE | 0 | 0 | IS-M/AM: Include for IBAN | |||||
59 | IBAN | IBAN | IBAN | CHAR | 34 | 0 | IBAN (International Bank Account Number) | ||
60 | XSPERR_BON | XSPERR_BON | XFELD | CHAR | 1 | 0 | IS-M: "Blocked for reasons of creditworthiness" indicator | ||
61 | VKBUR_ZUST | VKBURZUS | VKBUR | CHAR | 4 | 0 | Sales office responsible | * | |
62 | .INCLUDE | 0 | 0 | IS-M/AM: Payment cards: Projection of RJH_CCDATA | |||||
63 | CCINS | CCINS | CCINS | CHAR | 4 | 0 | Payment cards: Card type | TVCIN | |
64 | CCNUM | CCNUM | CCNUM | CHAR | 25 | 0 | Payment cards: Card number | VCNUM | |
65 | DATBI | DATBI_CC | DATUM | DATS | 8 | 0 | Payment Cards: Valid To | ||
66 | CCNAME | CCNAME | TEXT40 | CHAR | 40 | 0 | Payment Cards: Name of Cardholder | ||
67 | .INCLUDE | 0 | 0 | IS-M/AM: Card Verification Value | |||||
68 | CVVAL | ISM_CVVAL | ISM_CVVAL | CHAR | 6 | 0 | Card Verification Value | ||
69 | CVVCT | ISM_CVVCT | ISM_CVVCT | CHAR | 1 | 0 | Control Field for Card Verification Value | ||
70 | CVVST | ISM_CVVST | ISM_CVVST | CHAR | 1 | 0 | Usage Status of Card Verification Value | ||
71 | 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 | |
72 | BRAN1 | BRAN_PAM | BRACO | CHAR | 10 | 0 | IS-M: Industry Sector for Advertiser | TBRC | |
73 | ADV_AD_SIZE | ISM_ADV_AD_SIZE | MENGE13 | QUAN | 13 | 3 | Share of Ad Size Belonging to the Advertiser | ||
74 | .INCLUDE | 0 | 0 | Credit Card Encryption | |||||
75 | CGUID | CARD_GUID | SYSUUID | RAW | 16 | 0 | GUID of a Payment Card | ||
76 | ENCTP | CCSECA_ENCTYPE | CCSECA_ENCTYPE | CHAR | 1 | 0 | Type of Encryption | ||
77 | .INCLUDE | 0 | 0 | IS-M/AM: Include for SEPA Mandates | |||||
78 | MNDID | SEPA_MNDID | ID035 | CHAR | 35 | 0 | Unique Referene to Mandate per Payment Recipient | ||
79 | LAND1 | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | * | |
80 | INS_NAME | TEXT30 | TEXT30 | CHAR | 30 | 0 | Text (30 Characters) | ||
81 | REG_NAME | TEXT30 | TEXT30 | CHAR | 30 | 0 | Text (30 Characters) | ||
82 | ZLSCH_TEXT | TEXT1_042Z | TEXT30 | CHAR | 30 | 0 | Name of Payment Method in Language of the Country | ||
83 | KONDA_TEXT | BEZEI20 | TEXT20 | CHAR | 20 | 0 | Description | ||
84 | RECH_NAME | TEXT30 | TEXT30 | CHAR | 30 | 0 | Text (30 Characters) | ||
85 | PARNR | ISM_CNTCT_PRSN | BU_PARTNER | CHAR | 10 | 0 | IS-M: Contact Person | * | |
86 | PARNR_NAME | TEXT30 | TEXT30 | CHAR | 30 | 0 | Text (30 Characters) | ||
87 | X_ADRND | X_ADRND | XFELD | CHAR | 1 | 0 | IS-M: Business Address For Contact Person Indicator | ||
88 | X_ADRNP | X_ADRNP | XFELD | CHAR | 1 | 0 | IS-M: Home Address For Contact Person Indicator | ||
89 | RECH_STREET_POBOX | TEXT60 | TEXT60 | CHAR | 60 | 0 | Text Field of Length 60 | ||
90 | RECH_SITE | TEXT60 | TEXT60 | CHAR | 60 | 0 | Text Field of Length 60 | ||
91 | ADV_DESCRIPTION | BU_DESCRIP_LONG | CHAR80 | CHAR | 80 | 0 | Description of a Business Partner | ||
92 | PAYER_DESCRIPTION | BU_DESCRIP_LONG | CHAR80 | CHAR | 80 | 0 | Description of a Business Partner | ||
93 | BTP_DESCRIPTION | BU_DESCRIP_LONG | CHAR80 | CHAR | 80 | 0 | Description of a Business Partner | ||
94 | BRAN1_TEXT | VTEXT | TEXT20 | CHAR | 20 | 0 | Description | ||
95 | ADV_KONDA | KONDA | KONDA | CHAR | 2 | 0 | Price Group (Customer) | T188 | |
96 | ADV_KONDA_TEXT | BEZEI20 | TEXT20 | CHAR | 20 | 0 | Description | ||
97 | ADV_AD_SIZE_LAGME | LAGME | MEINS | UNIT | 3 | 0 | Base Unit of Measure | * | |
98 | .INCLUDE | 0 | 0 | IS-M/AM: SEPA Mandate Display Attributes | |||||
99 | MND_STATUS | SEPA_STATUS | SEPA_STATUS | CHAR | 1 | 0 | SEPA: Mandate Status | ||
100 | MND_ICON | JSEPA_STATUS_ICON | JSEPA_STATUS_ICON | CHAR | 255 | 0 | IS-M/AM: SEPA Mandate Status Icon | ||
101 | MND_TEXT | JSEPA_STATUS_TEXT | JSEPA_STATUS_TEXT | CHAR | 255 | 0 | IS-M: SEPA Mandate Status Quick Info |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | RJHA452 | ADV_KONDA | T188 | KONDA | |||
2 | RJHA452 | AVM_NR | JHAK | AVM_NR | KEY | 1 | CN |
3 | RJHA452 | BANKL | BNKA | BANKL | |||
4 | RJHA452 | BANKS | T005 | LAND1 | REF | C | CN |
5 | RJHA452 | BRAN1 | TBRC | BRACO | |||
6 | RJHA452 | CCINS | TVCIN | CCINS | REF | 1 | CN |
7 | RJHA452 | CCNUM | VCNUM | CCNUM | REF | 1 | CN |
8 | RJHA452 | DATE_GEN_RULE_BI | TJHGENBI | DATE_GEN_RULE_BI | REF | 1 | CN |
9 | RJHA452 | FAKSPP | TVFS | FAKSP | |||
10 | RJHA452 | GPNR_RECH | JGTGPNR | GPNR | REF | 1 | CN |
11 | RJHA452 | INSERENT | JJVDB_MK_FK | GPNR | KEY | 1 | CN |
12 | RJHA452 | KALKS | TVKD | KALKS | |||
13 | RJHA452 | KARENZ_ME | T006 | MSEHI | KEY | 1 | CN |
14 | RJHA452 | KDGRP | T151 | KDGRP | REF | 1 | CN |
15 | RJHA452 | KONDA | T188 | KONDA | |||
16 | RJHA452 | KUKARR_K | TJJ95 | KUKARR | |||
17 | RJHA452 | KURST | TCURV | KURST | REF | 1 | CN |
18 | RJHA452 | MANDT | T000 | MANDT | KEY | 1 | CN |
19 | RJHA452 | PERFK | TFACD | IDENT | |||
20 | RJHA452 | PLTYP | T189 | PLTYP | REF | 1 | CN |
21 | RJHA452 | POS_NR | JHAP | POS_NR | KEY | 1 | CN |
22 | RJHA452 | REGULIERER | JGTGPNR | GPNR | REF | 1 | CN |
23 | RJHA452 | WAERG | TCURC | WAERS | 1 | CN | |
24 | RJHA452 | ZLSCH | T042Z | ZLSCH | REF | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |