SAP ABAP Table MCJHAGVZ (IS-PAM: LIS communication structure for agent 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 | MCJHAGVZ | Table Relationship Diagram |
Short Description | IS-PAM: LIS communication structure for agent 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 | .INCLUDE | 0 | 0 | IS-M/AM: Order Sales Agent Assignment | |||||
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 | GRUPPABRNR | GRUPPABRNR | GRUPPABR | NUMC | 3 | 0 | IS-M/AM: Billing Dataset | JHAGA | |
6 | VNR | JVMVVNR | JVMVVNR | CHAR | 10 | 0 | IS-M: Media Sales Agent Contract Number | JJTVV | |
7 | BEDNR | VM_BEDNR | VM_BEDNR | NUMC | 6 | 0 | IS-M: Number of Media Sales Agent Contract Requirement | JJTVB | |
8 | PROVTYP | PROVTYP | PROVTYP | CHAR | 1 | 0 | IS-M/AM: Commission Category | ||
9 | VZUONR | JH_VZUONR | JH_VZUONR | NUMC | 2 | 0 | IS-M/AM: Sales Agent Assignment Number (Corrections) | * | |
10 | VERM | VERMK | JJMVERM | CHAR | 10 | 0 | IS-M: Sales Agent with ID Code for Screen | * | |
11 | XAUTO | JAUTOZUGPR | XFELD | CHAR | 1 | 0 | IS-M: Assigned automatically Indicator | ||
12 | XFOUND | PR_XFOUND | XFELD | CHAR | 1 | 0 | Suitable Sales Agent Contract Requirement Found Indicator | ||
13 | XMANU | PR_XMANU | XFELD | CHAR | 1 | 0 | IS-M: Sales Agent Assigned Manually Indicator | ||
14 | XKOPF_ZUO | PRKOPF_ZUO | XFELD | CHAR | 1 | 0 | IS-M: "Sales Agent Copied from Order Header" Indicator | ||
15 | XPOS_ZUO | PRPOS_ZUO | XFELD | CHAR | 1 | 0 | IS-M: Sales Agent Copied from Order Item | ||
16 | .INCLUDE | 0 | 0 | Values that can be Modified Manually for Sales Agent Assign. | |||||
17 | PR_BASIS | VPROVBAS | DECV4_3 | DEC | 7 | 3 | IS-M: Sales Agent Share of Calculation Base (in %) | ||
18 | PR_BETRAG | VPROZP | DEC4_3 | DEC | 7 | 3 | IS-M: Sales Agent Share of Commission (in %) | ||
19 | PRA_XMANU | JHPRAXMANU | XFELD | CHAR | 1 | 0 | IS-M: Sales Agent Share was Changed Manually Indicator | ||
20 | PROSL | JPROVSCHL | PRSCHL | CHAR | 5 | 0 | IS-M/AM: Commission Key for Media Sales Agent | TJH23 | |
21 | PROV_SATZ | PROV_SATZ | DECV4_3 | DEC | 7 | 3 | IS-M: Commission Rate (Percent) | ||
22 | PROVM_SATZ | PROV_SATZM | WERTV8 | CURR | 15 | 2 | IS-M: Commission Amount for mm Commission | ||
23 | PROVM_WAER | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
24 | PROV_PEIN | PAMPEIN | KPEIN | DEC | 5 | 0 | IS-M: Price Unit (Surcharge Discount, Basic Price) | ||
25 | PROV_MEIN | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | T006 | |
26 | BEZKOND | JBEZKOND | JBEZKOND | CHAR | 2 | 0 | IS-M: Condition Reference | TJJ83 | |
27 | VZMANUAEND | VZMANUAEND | XFELD | CHAR | 1 | 0 | IS-M: Sales Agent Assignment was Changed Indicator | ||
28 | BEDGR | BEDGR | BEDGR | CHAR | 2 | 0 | IS-M: Media Sales Agent Requirement Group | TJJ77 | |
29 | JVERMART | JVERMART | JVERMART | CHAR | 2 | 0 | IS-M: Media Sales Agent Type: General/City/Special Agent | TJJ09 | |
30 | VANR | JVANR | JVANR | CHAR | 5 | 0 | IS-M: Extra commission/exclusion | ||
31 | REF_VZUONR | JH_REF_VZUONR | JH_VZUONR | NUMC | 2 | 0 | IS-M/AM: Reference Number of the Preceding Agent Assignmt | JHAGVZ | |
32 | SUC_VZUONR | JH_SUC_VZUONR | JH_VZUONR | NUMC | 2 | 0 | IS-M: Reference No.of Successor Sales Agent Assignment | JHAGVZ | |
33 | CORRCAUSE | JHVZCC | JHVZCC | CHAR | 2 | 0 | IS-M/AM: Reason for Correction to Sales Agent Assignment | TJHVZCC | |
34 | CANCELCC | JHCANCELCC | JHVZCC | CHAR | 2 | 0 | IS-M: Reversal Correction Reason for Sales Agent Assignment | TJHVZCC | |
35 | .INCLUDE | 0 | 0 | IS-PAM: Agent assignment grouping status fields | |||||
36 | STATUSK | STATUSK | PAM_STATUS | CHAR | 2 | 0 | IS-M: Status | ||
37 | XPROV_EE | XPROV_EE | XFELD | CHAR | 1 | 0 | IS-M: Settlement Performed (Sales Agent Payment) Indicator | ||
38 | XUVVZ | XUVVZ_GVZ | XFELD | CHAR | 1 | 0 | IS-M: Sales Agent Assignment is Incomplete | ||
39 | XZUOINACT | XZUOINACT | XFELD | CHAR | 1 | 0 | IS-M: Indicator Sales Agent Assignment is Inactive | ||
40 | XDELETED | PR_XDEL | XFELD | CHAR | 1 | 0 | IS-M: Sales Agent Assignment Deleted Manually Indicator | ||
41 | .INCLUDE | 0 | 0 | IS-PAM: Characteristics for individual use (Ad.sched.line) | |||||
42 | MERKMAL0 | MERK0_VZ | XFELD | CHAR | 1 | 0 | IS-M: Characteristic 0 for Ind.Use (Sales Agent Assignment) | ||
43 | MERKMAL1 | MERK1_VZ | XFELD | CHAR | 1 | 0 | IS-M: Characteristic 1 for Ind.Use (Sales Agent Assignment) | ||
44 | MERKMAL2 | MERK2_VZ | XFELD | CHAR | 1 | 0 | IS-M: Characteristic 2 for Ind.Use (Sales Agent Assignment) | ||
45 | MERKMAL3 | MERK3_VZ | XFELD | CHAR | 1 | 0 | IS-M: Characteristic 3 for Ind.Use (Sales Agent Assignment) | ||
46 | MERKMAL4 | MERK4_VZ | XFELD | CHAR | 1 | 0 | IS-M: Characteristic 4 for Ind.Use (Sales Agent Assignment) | ||
47 | MERKMAL5 | MERK5_VZ | XFELD | CHAR | 1 | 0 | IS-M: Characteristic 5 for Ind.Use (Sales Agent Assignment) | ||
48 | MERKMAL6 | MERK6_VZ | XFELD | CHAR | 1 | 0 | IS-M: Characteristic 6 for Ind.Use (Sales Agent Assignment) | ||
49 | MERKMAL7 | MERK7_VZ | XFELD | CHAR | 1 | 0 | IS-M: Characteristic 7 for Ind.Use (Sales Agent Assignment) | ||
50 | MERKMAL8 | MERK8_VZ | XFELD | CHAR | 1 | 0 | IS-M: Characteristic 8 for Ind.Use (Sales Agent Assignment) | ||
51 | MERKMAL9 | MERK9_VZ | XFELD | CHAR | 1 | 0 | CIS-M: Characteristic 9 for Ind.Use (Sales Agent Assignment) | ||
52 | .INCLUDE | 0 | 0 | IS-M: LIS communication structure, agent data item extra | |||||
53 | VZ_UMBRT | VZ_UMBRT | WERTV10 | CURR | 19 | 2 | IS-M/AM: LIS order SA total gross sales volume | ||
54 | VZ_UMNET | VZ_UMNET | WERTV10 | CURR | 19 | 2 | IS-M/AM: LIS order SA total net sales volume | ||
55 | VZ_KZWI1 | VZ_KZWI1 | WERTV9 | CURR | 17 | 2 | IS-M/AM: LIS Order SA SVOL ST1 Total | ||
56 | VZ_KZWI2 | VZ_KZWI2 | WERTV9 | CURR | 17 | 2 | IS-M/AM: LIS Order SA SVol ST2 Total | ||
57 | VZ_KZWI3 | VZ_KZWI3 | WERTV9 | CURR | 17 | 2 | IS-M/AM: LIS Order SA SVol. ST3 Total | ||
58 | VZ_KZWI4 | VZ_KZWI4 | WERTV9 | CURR | 17 | 2 | IS-M/AM: LIS Order SA SVol ST4 Total | ||
59 | VZ_KZWI5 | VZ_KZWI5 | WERTV9 | CURR | 17 | 2 | IS-M/AM: LIS Order SA SVol ST5 Total | ||
60 | VZ_KZWI6 | VZ_KZWI6 | WERTV9 | CURR | 17 | 2 | IS-M/AM: LIS Order SA SVol. ST6 Total | ||
61 | VZ_GUBRT | VZ_GUBRT | WERTV10 | CURR | 19 | 2 | IS-M/AM: LIS Order SA SVol Gross Total Credit Memo | ||
62 | VZ_GUNET | VZ_GUNET | WERTV10 | CURR | 19 | 2 | IS-M/AM: LIS Order SA SVol Net Total Credit Memo | ||
63 | VZ_KZWI1G | VZ_KZWI1G | WERTV9 | CURR | 17 | 2 | IS-M/AM: LIS Order SA SVol ST1 Total Credit Memo | ||
64 | VZ_KZWI2G | VZ_KZWI2G | WERTV9 | CURR | 17 | 2 | IS-M/AM: LIS Order SA SVol. ST2 Total Credit Memo | ||
65 | VZ_KZWI3G | VZ_KZWI3G | WERTV9 | CURR | 17 | 2 | IS-M/AM: LIS Order SA SVol ST3.Total Credit Memo | ||
66 | VZ_KZWI4G | VZ_KZWI4G | WERTV9 | CURR | 17 | 2 | IS-M/AM: LIS Order SA SVol ST4 Total Credit Memo | ||
67 | VZ_KZWI5G | VZ_KZWI5G | WERTV9 | CURR | 17 | 2 | IS-M/AM: LIS Order SA SVol. ST5 Total Credit Memo | ||
68 | VZ_KZWI6G | VZ_KZWI6G | WERTV9 | CURR | 17 | 2 | IS-M/AM: LIS Order SA SVol. ST6 Total Credit Memo | ||
69 | VZA_UMBRT | VZA_UMBRT | WERTV10 | CURR | 19 | 2 | IS-M/AM: LIS Order SAShare SVol Gross Total | ||
70 | VZA_UMNET | VZA_UMNET | WERTV10 | CURR | 19 | 2 | IS-M/AM: LIS Order SA Share SVol Net Total | ||
71 | VZA_KZWI1 | VZA_KZWI1 | WERTV9 | CURR | 17 | 2 | IS-M: LIS order SAShare SVol ST1 Total | ||
72 | VZA_KZWI2 | VZA_KZWI2 | WERTV9 | CURR | 17 | 2 | IS-M: LIS order SAShare SVOl. ST2 Total | ||
73 | VZA_KZWI3 | VZA_KZWI3 | WERTV9 | CURR | 17 | 2 | IS-M: LIS order SAShare SVol ST3 Total | ||
74 | VZA_KZWI4 | VZA_KZWI4 | WERTV9 | CURR | 17 | 2 | IS-M: LIS order SAShare SVol ST4 Total | ||
75 | VZA_KZWI5 | VZA_KZWI5 | WERTV9 | CURR | 17 | 2 | IS-M: LIS order SAShare SVolume ST5 Total | ||
76 | VZA_KZWI6 | VZA_KZWI6 | WERTV9 | CURR | 17 | 2 | IS-M: LIS order SAShare SVolume ST6 Total | ||
77 | VZA_GUBRT | VZA_GUBRT | WERTV10 | CURR | 19 | 2 | IS-M/AM: LIS Order SAShare SVol Gross Total Credit Memo | ||
78 | VZA_GUNET | VZA_GUNET | WERTV10 | CURR | 19 | 2 | IS-M/AM: LIS Order SAShare SVol Net Total Credit Memo | ||
79 | VZA_KZWI1G | VZA_KZWI1G | WERTV9 | CURR | 17 | 2 | IS-M: LIS order SAShare SVol ST1 Tital Credit Memo | ||
80 | VZA_KZWI2G | VZA_KZWI2G | WERTV9 | CURR | 17 | 2 | IS-M: LIS order SAShare SVol. ST2 Total Credit Memo | ||
81 | VZA_KZWI3G | VZA_KZWI3G | WERTV9 | CURR | 17 | 2 | IS-M: LIS order SAShare SVol ST3 Total Credit Memo | ||
82 | VZA_KZWI4G | VZA_KZWI4G | WERTV9 | CURR | 17 | 2 | IS-M: LIS order SAgtAssShare SVol ST4 Total credit memo | ||
83 | VZA_KZWI5G | VZA_KZWI5G | WERTV9 | CURR | 17 | 2 | IS-M: LIS order SAShare SVol ST5 Total Credit Memo | ||
84 | VZA_KZWI6G | VZA_KZWI6G | WERTV9 | CURR | 17 | 2 | IS-M: LIS order SAShare SVol ST6 Total Credit Memo | ||
85 | J_FAKDAT | J_FAKDAT | DATUM | DATS | 8 | 0 | IS-M: LIS auxiliary field for billing date in the order | ||
86 | J_KUNAG | GPAG | GPNR | CHAR | 10 | 0 | Business Partner: Sold-to Party | * | |
87 | J_KUNRG | REGULIERER | GPNR | CHAR | 10 | 0 | IS-M: Payer | * | |
88 | J_INSERENT | INSERENT | GPNR | CHAR | 10 | 0 | IS-M: Advertiser | * | |
89 | J_VKORG | VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | * | |
90 | J_VTWEG | VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | * | |
91 | J_SPART | SPART | SPART | CHAR | 2 | 0 | Division | * | |
92 | J_BEINH | BELEGEINH | BELEINH | CHAR | 10 | 0 | IS-M/AM: Booking Unit | * | |
93 | J_BEINH_BA | BE_BASIS | BELEINH | CHAR | 10 | 0 | IS-M: Basic Booking Unit | * | |
94 | .INCLUDE | 0 | 0 | IS-M: LIS communication structure, billing agent data | |||||
95 | VF_UMBRT | VF_UMBRT | WERTV10 | CURR | 19 | 2 | IS-M/AM: LIS billing SA total gross sales volume | ||
96 | VF_UMNET | VF_UMNET | WERTV10 | CURR | 19 | 2 | IS-M/AM: LIS billing SA total net sales volume | ||
97 | VF_KZWI1 | VF_KZWI1 | WERTV9 | CURR | 17 | 2 | IS-M: LIS billing SA SVol ST1 total | ||
98 | VF_KZWI2 | VF_KZWI2 | WERTV9 | CURR | 17 | 2 | IS-M: LIS billing SA SVol ST2 total | ||
99 | VF_KZWI3 | VF_KZWI3 | WERTV9 | CURR | 17 | 2 | IS-M: LIS billing SA SVol ST3 total | ||
100 | VF_KZWI4 | VF_KZWI4 | WERTV9 | CURR | 17 | 2 | IS-M: LIS billing SA SVol ST4 total | ||
101 | VF_KZWI5 | VF_KZWI5 | WERTV9 | CURR | 17 | 2 | IS-M: LIS billing SA SVol ST5 total | ||
102 | VF_KZWI6 | VF_KZWI6 | WERTV9 | CURR | 17 | 2 | IS-M: LIS billing SA SVol.ST6 total | ||
103 | VF_GUBRT | VF_GUBRT | WERTV10 | CURR | 19 | 2 | IS-M/AM: LIS billing AA gross sales volume total credit memo | ||
104 | VF_GUNET | VF_GUNET | WERTV10 | CURR | 19 | 2 | IS-M/AM: LIS billing SA SVol net total credit memo | ||
105 | VF_KZWI1G | VF_KZWI1G | WERTV9 | CURR | 17 | 2 | IS-M: LIS billing SA SVol ST1 total credit memo | ||
106 | VF_KZWI2G | VF_KZWI2G | WERTV9 | CURR | 17 | 2 | IS-M: LIS billing SA SVol ST2 total credit memo | ||
107 | VF_KZWI3G | VF_KZWI3G | WERTV9 | CURR | 17 | 2 | IS-M: LIS billing SA SVol ST3 total credit memo | ||
108 | VF_KZWI4G | VF_KZWI4G | WERTV9 | CURR | 17 | 2 | IS-M: LIS billing SA SVol ST4 total credit memo | ||
109 | VF_KZWI5G | VF_KZWI5G | WERTV9 | CURR | 17 | 2 | IS-M: LIS billing SA SVol ST5 total credit memo | ||
110 | VF_KZWI6G | VF_KZWI6G | WERTV9 | CURR | 17 | 2 | IS-M: LIS billing SA SVol ST6 total credit memo | ||
111 | VFA_UMBRT | VFA_UMBRT | WERTV10 | CURR | 19 | 2 | IS-M/AM: LIS billing SAShare total gross sales volume | ||
112 | VFA_UMNET | VFA_UMNET | WERTV10 | CURR | 19 | 2 | IS-M/AM: LIS billing SA share total net sales volume | ||
113 | VFA_KZWI1 | VFA_KZWI1 | WERTV9 | CURR | 17 | 2 | IS-M: LIS billing SAShare SVol ST1 total | ||
114 | VFA_KZWI2 | VFA_KZWI2 | WERTV9 | CURR | 17 | 2 | IS-M: LIS billing SAShare SVol ST2 total | ||
115 | VFA_KZWI3 | VFA_KZWI3 | WERTV9 | CURR | 17 | 2 | IS-M: LIS billing SAShare SVol ST3 total | ||
116 | VFA_KZWI4 | VFA_KZWI4 | WERTV9 | CURR | 17 | 2 | IS-M: LIS billing SAShare SVol ST4 total | ||
117 | VFA_KZWI5 | VFA_KZWI5 | WERTV9 | CURR | 17 | 2 | IS-M: LIS billing SAShare SVol ST5 total | ||
118 | VFA_KZWI6 | VFA_KZWI6 | WERTV9 | CURR | 17 | 2 | IS-M: LIS billing SAShare Sales vol.ST6 total | ||
119 | VFA_GUBRT | VFA_GUBRT | WERTV10 | CURR | 19 | 2 | IS-M/AM: LIS billing SAAShare gross SVol.total credit memo | ||
120 | VFA_GUNET | VFA_GUNET | WERTV10 | CURR | 19 | 2 | IS-M/AM: LIS billing SAAShare net SVol total credit memo | ||
121 | VFA_KZWI1G | VFA_KZWI1G | WERTV9 | CURR | 17 | 2 | IS-M: LIS billing SAShare SVol ST1 total credit memo | ||
122 | VFA_KZWI2G | VFA_KZWI2G | WERTV9 | CURR | 17 | 2 | IS-M: LIS billing SAShare SVol ST2 total credit memo | ||
123 | VFA_KZWI3G | VFA_KZWI3G | WERTV9 | CURR | 17 | 2 | IS-M: LIS billing SAShare SVol ST3 total credit memo | ||
124 | VFA_KZWI4G | VFA_KZWI4G | WERTV9 | CURR | 17 | 2 | IS-M: LIS billing SAShare SVol ST4 total credit memo | ||
125 | VFA_KZWI5G | VFA_KZWI5G | WERTV9 | CURR | 17 | 2 | IS-M: LIS billing SAShare SVol. ST5 total credit memo | ||
126 | VFA_KZWI6G | VFA_KZWI6G | WERTV9 | CURR | 17 | 2 | IS-M: LIS billing SAShare SVol ST6 total credit memo |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | MCJHAGVZ | AVM_NR | JHAK | AVM_NR | KEY | 1 | CN |
2 | MCJHAGVZ | BEDGR | TJJ77 | BEDGR | KEY | 1 | CN |
3 | MCJHAGVZ | BEDNR | JJTVB | BEDNR | KEY | 1 | CN |
4 | MCJHAGVZ | BEZKOND | TJJ83 | BEZKOND | 1 | CN | |
5 | MCJHAGVZ | CANCELCC | TJHVZCC | CORRCAUSE | REF | 1 | CN |
6 | MCJHAGVZ | CORRCAUSE | TJHVZCC | CORRCAUSE | REF | 1 | CN |
7 | MCJHAGVZ | GRUPPABRNR | JHAGA | GRUPPABRNR | KEY | 1 | CN |
8 | MCJHAGVZ | JVERMART | TJJ09 | JVERMART | KEY | 1 | CN |
9 | MCJHAGVZ | MANDT | T000 | MANDT | KEY | 1 | CN |
10 | MCJHAGVZ | POS_NR | JHAP | POS_NR | KEY | 1 | CN |
11 | MCJHAGVZ | PROSL | TJH23 | PRSCHL | 1 | CN | |
12 | MCJHAGVZ | PROVM_WAER | TCURC | WAERS | 1 | CN | |
13 | MCJHAGVZ | PROV_MEIN | T006 | MSEHI | 1 | CN | |
14 | MCJHAGVZ | REF_VZUONR | JHAGVZ | VZUONR | 1 | CN | |
15 | MCJHAGVZ | SUC_VZUONR | JHAGVZ | VZUONR | 1 | C | |
16 | MCJHAGVZ | VNR | JJTVV | VNR | KEY | 1 | CN |
History
Last changed by/on | SAP | 20060208 |
SAP Release Created in |