SAP ABAP Table RJHA679 (IS-M: Sales Agt Assign.Dataset Detail Screen (Comm.Bon1/2))
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 | RJHA679 | Table Relationship Diagram |
Short Description | IS-M: Sales Agt Assign.Dataset Detail Screen (Comm.Bon1/2) |
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 | .INCLUDE | 0 | 0 | IS-M/AM: Order Sales Agent Assignment | |||||
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 | GRUPPABRNR | GRUPPABRNR | GRUPPABR | NUMC | 3 | 0 | IS-M/AM: Billing Dataset | JHAGA | |
7 | VNR | JVMVVNR | JVMVVNR | CHAR | 10 | 0 | IS-M: Media Sales Agent Contract Number | JJTVV | |
8 | BEDNR | VM_BEDNR | VM_BEDNR | NUMC | 6 | 0 | IS-M: Number of Media Sales Agent Contract Requirement | JJTVB | |
9 | PROVTYP | PROVTYP | PROVTYP | CHAR | 1 | 0 | IS-M/AM: Commission Category | ||
10 | VZUONR | JH_VZUONR | JH_VZUONR | NUMC | 2 | 0 | IS-M/AM: Sales Agent Assignment Number (Corrections) | * | |
11 | VERM | VERMK | JJMVERM | CHAR | 10 | 0 | IS-M: Sales Agent with ID Code for Screen | * | |
12 | XAUTO | JAUTOZUGPR | XFELD | CHAR | 1 | 0 | IS-M: Assigned automatically Indicator | ||
13 | XFOUND | PR_XFOUND | XFELD | CHAR | 1 | 0 | Suitable Sales Agent Contract Requirement Found Indicator | ||
14 | XMANU | PR_XMANU | XFELD | CHAR | 1 | 0 | IS-M: Sales Agent Assigned Manually Indicator | ||
15 | XKOPF_ZUO | PRKOPF_ZUO | XFELD | CHAR | 1 | 0 | IS-M: "Sales Agent Copied from Order Header" Indicator | ||
16 | XPOS_ZUO | PRPOS_ZUO | XFELD | CHAR | 1 | 0 | IS-M: Sales Agent Copied from Order Item | ||
17 | .INCLUDE | 0 | 0 | Values that can be Modified Manually for Sales Agent Assign. | |||||
18 | PR_BASIS | VPROVBAS | DECV4_3 | DEC | 7 | 3 | IS-M: Sales Agent Share of Calculation Base (in %) | ||
19 | PR_BETRAG | VPROZP | DEC4_3 | DEC | 7 | 3 | IS-M: Sales Agent Share of Commission (in %) | ||
20 | PRA_XMANU | JHPRAXMANU | XFELD | CHAR | 1 | 0 | IS-M: Sales Agent Share was Changed Manually Indicator | ||
21 | PROSL | JPROVSCHL | PRSCHL | CHAR | 5 | 0 | IS-M/AM: Commission Key for Media Sales Agent | TJH23 | |
22 | PROV_SATZ | PROV_SATZ | DECV4_3 | DEC | 7 | 3 | IS-M: Commission Rate (Percent) | ||
23 | PROVM_SATZ | PROV_SATZM | WERTV8 | CURR | 15 | 2 | IS-M: Commission Amount for mm Commission | ||
24 | PROVM_WAER | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
25 | PROV_PEIN | PAMPEIN | KPEIN | DEC | 5 | 0 | IS-M: Price Unit (Surcharge Discount, Basic Price) | ||
26 | PROV_MEIN | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | T006 | |
27 | BEZKOND | JBEZKOND | JBEZKOND | CHAR | 2 | 0 | IS-M: Condition Reference | TJJ83 | |
28 | VZMANUAEND | VZMANUAEND | XFELD | CHAR | 1 | 0 | IS-M: Sales Agent Assignment was Changed Indicator | ||
29 | BEDGR | BEDGR | BEDGR | CHAR | 2 | 0 | IS-M: Media Sales Agent Requirement Group | TJJ77 | |
30 | JVERMART | JVERMART | JVERMART | CHAR | 2 | 0 | IS-M: Media Sales Agent Type: General/City/Special Agent | TJJ09 | |
31 | VANR | JVANR | JVANR | CHAR | 5 | 0 | IS-M: Extra commission/exclusion | ||
32 | REF_VZUONR | JH_REF_VZUONR | JH_VZUONR | NUMC | 2 | 0 | IS-M/AM: Reference Number of the Preceding Agent Assignmt | JHAGVZ | |
33 | SUC_VZUONR | JH_SUC_VZUONR | JH_VZUONR | NUMC | 2 | 0 | IS-M: Reference No.of Successor Sales Agent Assignment | JHAGVZ | |
34 | CORRCAUSE | JHVZCC | JHVZCC | CHAR | 2 | 0 | IS-M/AM: Reason for Correction to Sales Agent Assignment | TJHVZCC | |
35 | CANCELCC | JHCANCELCC | JHVZCC | CHAR | 2 | 0 | IS-M: Reversal Correction Reason for Sales Agent Assignment | TJHVZCC | |
36 | .INCLUDE | 0 | 0 | IS-PAM: Agent assignment grouping status fields | |||||
37 | STATUSK | STATUSK | PAM_STATUS | CHAR | 2 | 0 | IS-M: Status | ||
38 | XPROV_EE | XPROV_EE | XFELD | CHAR | 1 | 0 | IS-M: Settlement Performed (Sales Agent Payment) Indicator | ||
39 | XUVVZ | XUVVZ_GVZ | XFELD | CHAR | 1 | 0 | IS-M: Sales Agent Assignment is Incomplete | ||
40 | XZUOINACT | XZUOINACT | XFELD | CHAR | 1 | 0 | IS-M: Indicator Sales Agent Assignment is Inactive | ||
41 | XDELETED | PR_XDEL | XFELD | CHAR | 1 | 0 | IS-M: Sales Agent Assignment Deleted Manually Indicator | ||
42 | .INCLUDE | 0 | 0 | IS-PAM: Characteristics for individual use (Ad.sched.line) | |||||
43 | MERKMAL0 | MERK0_VZ | XFELD | CHAR | 1 | 0 | IS-M: Characteristic 0 for Ind.Use (Sales Agent Assignment) | ||
44 | MERKMAL1 | MERK1_VZ | XFELD | CHAR | 1 | 0 | IS-M: Characteristic 1 for Ind.Use (Sales Agent Assignment) | ||
45 | MERKMAL2 | MERK2_VZ | XFELD | CHAR | 1 | 0 | IS-M: Characteristic 2 for Ind.Use (Sales Agent Assignment) | ||
46 | MERKMAL3 | MERK3_VZ | XFELD | CHAR | 1 | 0 | IS-M: Characteristic 3 for Ind.Use (Sales Agent Assignment) | ||
47 | MERKMAL4 | MERK4_VZ | XFELD | CHAR | 1 | 0 | IS-M: Characteristic 4 for Ind.Use (Sales Agent Assignment) | ||
48 | MERKMAL5 | MERK5_VZ | XFELD | CHAR | 1 | 0 | IS-M: Characteristic 5 for Ind.Use (Sales Agent Assignment) | ||
49 | MERKMAL6 | MERK6_VZ | XFELD | CHAR | 1 | 0 | IS-M: Characteristic 6 for Ind.Use (Sales Agent Assignment) | ||
50 | MERKMAL7 | MERK7_VZ | XFELD | CHAR | 1 | 0 | IS-M: Characteristic 7 for Ind.Use (Sales Agent Assignment) | ||
51 | MERKMAL8 | MERK8_VZ | XFELD | CHAR | 1 | 0 | IS-M: Characteristic 8 for Ind.Use (Sales Agent Assignment) | ||
52 | MERKMAL9 | MERK9_VZ | XFELD | CHAR | 1 | 0 | CIS-M: Characteristic 9 for Ind.Use (Sales Agent Assignment) | ||
53 | VERM_NAME | VERM_NAME | TEXT30 | CHAR | 30 | 0 | IS-M: Sales Agent Name | ||
54 | BEDART | VMBEDART | JVMBEDART | CHAR | 2 | 0 | IS-M/AM: Requirement Type in Media Sales Agent Contract | TJJ73 | |
55 | KTEXT_BA | JJBEDART_KTEXT | TEXT15 | CHAR | 15 | 0 | IS-M/AM: Requirement Type (Short Text) | ||
56 | KTEXT_VB | JJBEDNR_KTEXT | TEXT15 | CHAR | 15 | 0 | IS-M/AM: Contract Requirement (Short Text) | ||
57 | KTEXT_VV | JJVNR_KTEXT | TEXT15 | CHAR | 15 | 0 | IS-M/AM: Sales Agent Contract (Short Text) | ||
58 | KTEXT_VANR | KURZTEXT | TEXT40 | CHAR | 40 | 0 | Short text/description of the object | ||
59 | VTYP | JVERMVTYP | JVERMVTYP | CHAR | 1 | 0 | IS-M: Contract Category for Media Sales Agent Contract | ||
60 | XBERICHT | XBESBERICH | ISM_XBESBERICH | CHAR | 1 | 0 | IS-M/AM: Report Required, Reference to Partner (Role) | ||
61 | XSTDBED | JSTDBED | XFELD | CHAR | 1 | 0 | IS-M: Standard Requirement | ||
62 | STAT_AMPEL | STAT_AMPEL | SYCHAR132 | CHAR | 132 | 0 | IS-M: Status visualization | ||
63 | KRECH | JHKRECH | JHKRECH | CHAR | 1 | 0 | IS-M: Calculation Type for Commission Record (Direct Input) | ||
64 | KTEXT_STATUSK | DDTEXT | DDTEXT | CHAR | 60 | 0 | Explanatory short text | ||
65 | KTEXT_BEDART | BEZEICHN15 | TEXT15 | CHAR | 15 | 0 | IS-M: Short Text | ||
66 | KTEXT_BEDGR | BEZEICHN15 | TEXT15 | CHAR | 15 | 0 | IS-M: Short Text | ||
67 | KTEXT_VTYP | DDTEXT | DDTEXT | CHAR | 60 | 0 | Explanatory short text | ||
68 | KTEXT_PROVTYP | DDTEXT | DDTEXT | CHAR | 60 | 0 | Explanatory short text | ||
69 | KTEXT_VERMART | BEZEICHN15 | TEXT15 | CHAR | 15 | 0 | IS-M: Short Text | ||
70 | KTEXT_PROSL | BEZEICHN15 | TEXT15 | CHAR | 15 | 0 | IS-M: Short Text | ||
71 | KTEXT_BEZKOND | BEZEICHN15 | TEXT15 | CHAR | 15 | 0 | IS-M: Short Text | ||
72 | KTEXT_CC | BEZEICHN15 | TEXT15 | CHAR | 15 | 0 | IS-M: Short Text | ||
73 | KTEXT_CANCELCC | BEZEICHN15 | TEXT15 | CHAR | 15 | 0 | IS-M: Short Text |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | RJHA679 | AVM_NR | JHAK | AVM_NR | KEY | 1 | CN |
2 | RJHA679 | BEDART | TJJ73 | BEDART | KEY | 1 | CN |
3 | RJHA679 | BEDGR | TJJ77 | BEDGR | KEY | 1 | CN |
4 | RJHA679 | BEDNR | JJTVB | BEDNR | KEY | 1 | CN |
5 | RJHA679 | BEZKOND | TJJ83 | BEZKOND | REF | 1 | CN |
6 | RJHA679 | CANCELCC | TJHVZCC | CORRCAUSE | REF | 1 | CN |
7 | RJHA679 | CORRCAUSE | TJHVZCC | CORRCAUSE | REF | 1 | CN |
8 | RJHA679 | GRUPPABRNR | JHAGA | GRUPPABRNR | KEY | 1 | CN |
9 | RJHA679 | JVERMART | TJJ09 | JVERMART | KEY | 1 | CN |
10 | RJHA679 | MANDT | T000 | MANDT | KEY | 1 | CN |
11 | RJHA679 | POS_NR | JHAP | POS_NR | KEY | 1 | CN |
12 | RJHA679 | PROSL | TJH23 | PRSCHL | KEY | 1 | CN |
13 | RJHA679 | PROVM_WAER | TCURC | WAERS | REF | 1 | CN |
14 | RJHA679 | PROV_MEIN | T006 | MSEHI | REF | 1 | CN |
15 | RJHA679 | REF_VZUONR | JHAGVZ | VZUONR | REF | 1 | CN |
16 | RJHA679 | SUC_VZUONR | JHAGVZ | VZUONR | REF | 1 | C |
17 | RJHA679 | VNR | JJTVV | VNR | KEY | 1 | CN |
History
Last changed by/on | SAP | 20060208 |
SAP Release Created in |