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