SAP ABAP Table RJHAPVB (IS-PAM: Update structure for JHAP)
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 | RJHAPVB | Table Relationship Diagram |
Short Description | IS-PAM: Update structure for JHAP |
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-Publishing-Media Item | |||||
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 | * | |
5 | .INCLUDE | 0 | 0 | IS-M/AM: Include for Pure Item Attributes | |||||
6 | POS_ART | AVMPOS_ART | AVMPOS_ART | CHAR | 2 | 0 | IS-M: Order-Publishing-Media - Item Type | TJH17 | |
7 | PSTYV | PSTYV_PAM | PSTYV_PAM | CHAR | 4 | 0 | IS-M: Item Category for Sales Document | TJHAP | |
8 | VBTYP | ISPVBTYP | ISPVBTYP | CHAR | 1 | 0 | IS-M/AM: Sales Document Category | ||
9 | WERBK_TYP | WKOMBI_TYP | WKOMBI_TYP | CHAR | 2 | 0 | IS-M: Combination Sale Type | TJH91 | |
10 | WERBK_KNZ | WERBK_KNZ | WERBEKKNZ | NUMC | 4 | 0 | IS-M: Combination Sale Indicator | ||
11 | XAGENAUFTR | XAGENAUFTR | XFELD | CHAR | 1 | 0 | IS-M: Agency order indicator | ||
12 | XEINTEILG | XEINTEILG | XFELD | CHAR | 1 | 0 | IS-M: Indicator for modification at subordinate ord. level | ||
13 | BRAN_PAM | BRAN_POS | BRACO | CHAR | 10 | 0 | IS-M/AM: Current Industry Sector Associated With Order Item | TBRC | |
14 | STATUSK | STATUSK | PAM_STATUS | CHAR | 2 | 0 | IS-M: Status | ||
15 | .INCLUDE | 0 | 0 | IS-PAM: Agent attributes outside agent assignment | |||||
16 | VERMITTLER | VERMK | JJMVERM | CHAR | 10 | 0 | IS-M: Sales Agent with ID Code for Screen | * | |
17 | VNR | JVMVVNR | JVMVVNR | CHAR | 10 | 0 | IS-M: Media Sales Agent Contract Number | JJTVV | |
18 | BEDNR | VM_BEDNR | VM_BEDNR | NUMC | 6 | 0 | IS-M: Number of Media Sales Agent Contract Requirement | JJTVB | |
19 | PROSL | JPROVSCHL | PRSCHL | CHAR | 5 | 0 | IS-M/AM: Commission Key for Media Sales Agent | TJH23 | |
20 | KAMPAGNE | KAMPAGNE | KAMPAGNE | CHAR | 6 | 0 | IS-M: Campaign (customer) | TJJKAMP | |
21 | WERBK_POS | WERBK_POS | AVM_PNR | NUMC | 3 | 0 | IS-M: Combination Sale Grouping Item Number | JHAP | |
22 | WERBK_UPOS | WERBK_UPOS | AVM_UPNR | NUMC | 4 | 0 | IS-M: Combination Sale Grouping Sub-Item | ||
23 | WERBK_EINT | WERBK_EINT | AVMENR | NUMC | 6 | 0 | IS-M: Combination Sale Grouping for Schedule Line Number | JHAE | |
24 | REF_AVM_NR | REF_AVM_NR | AVM_NR | CHAR | 10 | 0 | IS-M: Reference Order Number of Preceding Order | JHAK | |
25 | REF_POS_NR | REF_POS_NR | AVM_PNR | NUMC | 3 | 0 | IS-M: Reference Item Number of Preceding Item | JHAP | |
26 | SUC_AVM_NR | SUC_AVM_NR | AVM_NR | CHAR | 10 | 0 | IS-M: Order Number of Subsequent Document | JHAK | |
27 | SUC_POS_NR | SUC_POS_NR | AVM_PNR | NUMC | 3 | 0 | IS-M: Item Number of Subsequent Item | JHAP | |
28 | VORL_AVMNR | VORL_AVMNR | AVM_NR | CHAR | 10 | 0 | IS-M: Order Number of the Preceding Document | JHAK | |
29 | VORL_POSNR | VORL_POSNR | AVM_PNR | NUMC | 3 | 0 | IS-M: Item number of the Preceding Item | JHAP | |
30 | CAMPAIGN | ISM_MARKETING_CAMPAIGN | ISM_MARKETING_CAMPAIGN | RAW | 16 | 0 | IS-M: Marketing Campaign | ||
31 | NOTIZKNZ | NOTIZKNZ | XFELD | CHAR | 1 | 0 | IS-M: Indicates Whether Notes are Available for an OPM Objct | ||
32 | .INCLUDE | 0 | 0 | IS-PAM: Include Customer Outline Agreement Indicator | |||||
33 | XRABATT | XRABATT | XFELD | CHAR | 1 | 0 | IS-M: Assignment Qualifies for Discount | ||
34 | XMITZRAB | XMITZRAB | XFELD | CHAR | 1 | 0 | IS-M: Assignment Counts Towards Discount Fulfillment | ||
35 | XBONUS | XBONUS | XFELD | CHAR | 1 | 0 | IS-M: Assignment Qualifies for Bonus | ||
36 | XMITZBON | XMITZBON | XFELD | CHAR | 1 | 0 | IS-M: Assignment Counts Towards Bonus Fulfillment | ||
37 | .INCLUDE | 0 | 0 | IS-M/AM: Surcharges And Discounts (Update) | |||||
38 | RAB1_BETR | JRABPROZ | DEC4_3 | DEC | 7 | 3 | IS-M/AM: Percentage discount | ||
39 | RAB1_GRUND | JGRKOND | JGRUND | CHAR | 2 | 0 | IS-M: Reason for Entering Conditions | ||
40 | RAB1_BKTYP | BKTYP | BKTYP | CHAR | 2 | 0 | IS-M: Condition Input Type in the Order | ||
41 | RAB2_BETR | JRABPROZ | DEC4_3 | DEC | 7 | 3 | IS-M/AM: Percentage discount | ||
42 | RAB2_GRUND | JGRKOND | JGRUND | CHAR | 2 | 0 | IS-M: Reason for Entering Conditions | ||
43 | RAB2_BKTYP | BKTYP | BKTYP | CHAR | 2 | 0 | IS-M: Condition Input Type in the Order | ||
44 | RAB3_BETR | JRABPROZ | DEC4_3 | DEC | 7 | 3 | IS-M/AM: Percentage discount | ||
45 | RAB3_GRUND | JGRKOND | JGRUND | CHAR | 2 | 0 | IS-M: Reason for Entering Conditions | ||
46 | RAB3_BKTYP | BKTYP | BKTYP | CHAR | 2 | 0 | IS-M: Condition Input Type in the Order | ||
47 | RAB4_BETR | JRABMEIN | WERTV6 | CURR | 11 | 2 | IS-M/AM: Quantity-dependent discount | ||
48 | RAB4_PEIN | PAMPEIN | KPEIN | DEC | 5 | 0 | IS-M: Price Unit (Surcharge Discount, Basic Price) | ||
49 | RAB4_MEIN | PAMMEIN | ISPEINH_PR | UNIT | 3 | 0 | IS-M: Unit of Measure (Discount, Surcharge, Basic Price) | * | |
50 | RAB4_GRUND | JGRKOND | JGRUND | CHAR | 2 | 0 | IS-M: Reason for Entering Conditions | ||
51 | RAB4_BKTYP | BKTYP | BKTYP | CHAR | 2 | 0 | IS-M: Condition Input Type in the Order | ||
52 | RAB5_BETR | JRABBETR | WERTV6 | CURR | 11 | 2 | IS-M/AM: Amount discount | ||
53 | RAB5_GRUND | JGRKOND | JGRUND | CHAR | 2 | 0 | IS-M: Reason for Entering Conditions | ||
54 | RAB5_BKTYP | BKTYP | BKTYP | CHAR | 2 | 0 | IS-M: Condition Input Type in the Order | ||
55 | RABE_BETR | JRABBETR | WERTV6 | CURR | 11 | 2 | IS-M/AM: Amount discount | ||
56 | RABE_GRUND | JGRKOND | JGRUND | CHAR | 2 | 0 | IS-M: Reason for Entering Conditions | ||
57 | RABE_BKTYP | BKTYP | BKTYP | CHAR | 2 | 0 | IS-M: Condition Input Type in the Order | ||
58 | ZUS1_BETR | JZUSPROZ | DEC4_3 | DEC | 7 | 3 | IS-M/AM: Percentage Surcharge | ||
59 | ZUS1_GRUND | JGRKOND | JGRUND | CHAR | 2 | 0 | IS-M: Reason for Entering Conditions | ||
60 | ZUS1_BKTYP | BKTYP | BKTYP | CHAR | 2 | 0 | IS-M: Condition Input Type in the Order | ||
61 | ZUS2_BETR | JZUSPROZ | DEC4_3 | DEC | 7 | 3 | IS-M/AM: Percentage Surcharge | ||
62 | ZUS2_GRUND | JGRKOND | JGRUND | CHAR | 2 | 0 | IS-M: Reason for Entering Conditions | ||
63 | ZUS2_BKTYP | BKTYP | BKTYP | CHAR | 2 | 0 | IS-M: Condition Input Type in the Order | ||
64 | ZUS3_BETR | JZUSPROZ | DEC4_3 | DEC | 7 | 3 | IS-M/AM: Percentage Surcharge | ||
65 | ZUS3_GRUND | JGRKOND | JGRUND | CHAR | 2 | 0 | IS-M: Reason for Entering Conditions | ||
66 | ZUS3_BKTYP | BKTYP | BKTYP | CHAR | 2 | 0 | IS-M: Condition Input Type in the Order | ||
67 | ZUS4_BETR | JZUSMEIN | WERTV6 | CURR | 11 | 2 | IS-M/AM: Quantity-dependent surcharge | ||
68 | ZUS4_PEIN | PAMPEIN | KPEIN | DEC | 5 | 0 | IS-M: Price Unit (Surcharge Discount, Basic Price) | ||
69 | ZUS4_MEIN | PAMMEIN | ISPEINH_PR | UNIT | 3 | 0 | IS-M: Unit of Measure (Discount, Surcharge, Basic Price) | * | |
70 | ZUS4_GRUND | JGRKOND | JGRUND | CHAR | 2 | 0 | IS-M: Reason for Entering Conditions | ||
71 | ZUS4_BKTYP | BKTYP | BKTYP | CHAR | 2 | 0 | IS-M: Condition Input Type in the Order | ||
72 | ZUS5_BETR | JZUSBETR | WERTV6 | CURR | 11 | 2 | IS-M/AM: Amount Surcharge | ||
73 | ZUS5_GRUND | JGRKOND | JGRUND | CHAR | 2 | 0 | IS-M: Reason for Entering Conditions | ||
74 | ZUS5_BKTYP | BKTYP | BKTYP | CHAR | 2 | 0 | IS-M: Condition Input Type in the Order | ||
75 | ZUSE_BETR | JZUSBETR | WERTV6 | CURR | 11 | 2 | IS-M/AM: Amount Surcharge | ||
76 | ZUSE_GRUND | JGRKOND | JGRUND | CHAR | 2 | 0 | IS-M: Reason for Entering Conditions | ||
77 | ZUSE_BKTYP | BKTYP | BKTYP | CHAR | 2 | 0 | IS-M: Condition Input Type in the Order | ||
78 | FPRG_BETR | JGPRBETR | WERTV6 | CURR | 11 | 2 | IS-M/AM: Basic Price | ||
79 | FPRG_PEIN | PAMPEIN | KPEIN | DEC | 5 | 0 | IS-M: Price Unit (Surcharge Discount, Basic Price) | ||
80 | FPRG_MEIN | PAMMEIN | ISPEINH_PR | UNIT | 3 | 0 | IS-M: Unit of Measure (Discount, Surcharge, Basic Price) | * | |
81 | FPRG_GRUND | JGRKOND | JGRUND | CHAR | 2 | 0 | IS-M: Reason for Entering Conditions | ||
82 | FPRG_BKTYP | BKTYP | BKTYP | CHAR | 2 | 0 | IS-M: Condition Input Type in the Order | ||
83 | FPR1_BETR | JVPRBETR | WERTV6 | CURR | 11 | 2 | IS-M/AM: Agreed price | ||
84 | FPR1_GRUND | JGRKOND | JGRUND | CHAR | 2 | 0 | IS-M: Reason for Entering Conditions | ||
85 | FPR1_BKTYP | BKTYP | BKTYP | CHAR | 2 | 0 | IS-M: Condition Input Type in the Order | ||
86 | XRABZU | XRABZU | XFELD | CHAR | 1 | 0 | IS-M: Discount/Surcharge Exists Indicator | ||
87 | WAER_IPZA | WAERK | WAERS | CUKY | 5 | 0 | SD document currency | * | |
88 | XUZUO_LOE | XFELD | XFELD | CHAR | 1 | 0 | Checkbox | ||
89 | .INCLUDE | 0 | 0 | IS-PAM: Status attributes for order item | |||||
90 | XUVFAKT | XUVFAKT | XFELD | CHAR | 1 | 0 | IS-M: Billing is Incomplete | ||
91 | XUVGP | XUVGP | XFELD | CHAR | 1 | 0 | IS-M: Business Partner Is Incomplete | ||
92 | XUVPREIS | XUVPREIS | XFELD | CHAR | 1 | 0 | IS-M: Incomplete with regard to pricing | ||
93 | XUVABSCHL | XUVABSCHL | XFELD | CHAR | 1 | 0 | IS-M: Contract Assignment is Incomplete | ||
94 | XUVVZ | XUVVZ | XFELD | CHAR | 1 | 0 | IS-M: Sales Agent Assignment Incomplete | ||
95 | XUVKPV | XUVKPV | XFELD | CHAR | 1 | 0 | IS-M: Incomplete Manual Header/Item Sales Agent Assignment | ||
96 | XGENEINT | XGENEINT | XFELD | CHAR | 1 | 0 | IS-M: Schedule lines are not current | ||
97 | XGENGRPF | XGENGRPF | XFELD | CHAR | 1 | 0 | IS-M: Billing Dataset Is Yet To Be Generated | ||
98 | XRESERV | XRESERV | XFELD | CHAR | 1 | 0 | IS-M: Reservation indicator | ||
99 | XRESBEST | XRESBEST | XFELD | CHAR | 1 | 0 | IS-M: Reservation confirmed | ||
100 | XFAKTMIN1 | XFAKTMIN1 | XFELD | CHAR | 1 | 0 | IS-M: Partially Billed (At Least 1 Billing Dataset Billed) | ||
101 | XFAKTALL | XFAKTALL | XFELD | CHAR | 1 | 0 | IS-M: Billing Performed For All Billing Datasets | ||
102 | XSPERR_BON | XSPERR_BON | XFELD | CHAR | 1 | 0 | IS-M: "Blocked for reasons of creditworthiness" indicator | ||
103 | XKOMMFRGB | XKOMMFRGB | XFELD | CHAR | 1 | 0 | IS-M: Commercial release necessary but not performed | ||
104 | XNACHBEARB | XNACHBEARB | XFELD | CHAR | 1 | 0 | IS-M: Post-Editing Required | ||
105 | .INCLUDE | 0 | 0 | Created-By Data (Medium Scope) | |||||
106 | ERFUSER | ERFUSER | USNAM | CHAR | 12 | 0 | Created By | ||
107 | ERFDATE | ERFDATE | DATUM | DATS | 8 | 0 | Created On | ||
108 | ERFTIME | ERFTIME | UZEIT | TIMS | 6 | 0 | Time Created | ||
109 | AENUSER | AENUSER | USNAM | CHAR | 12 | 0 | Last Changed By | ||
110 | AENDATE | AENDATE | DATUM | DATS | 8 | 0 | Date of Last Change | ||
111 | AENTIME | AENTIME | UZEIT | TIMS | 6 | 0 | Time of Last Change | ||
112 | XSTORNIERT | XSTORNIERT | XFELD | CHAR | 1 | 0 | IS-M: Canceled Order Object Indicator | ||
113 | STORNOGRND | STOGRD_PAM | STOGRD_PAM | CHAR | 3 | 0 | IS-M: Cancellation Reason | TJHSTOG | |
114 | STAFO | JHSTAFO | STAFO | CHAR | 6 | 0 | IS-M: Update group for statistics update | TMCB | |
115 | SELDAT_VON | SELDAT_VON | DATUM | DATS | 8 | 0 | IS-M: Start Date for Item | ||
116 | SELDAT_BIS | SELDAT_BIS | DATUM | DATS | 8 | 0 | IS-M: End Date for Items | ||
117 | .INCLUDE | 0 | 0 | IS-PAM: Purchase Order Data Include | |||||
118 | BSTNK | BSTNK | BSTNK | CHAR | 20 | 0 | Customer purchase order number | ||
119 | BSARK | BSARK | BSARK | CHAR | 4 | 0 | Customer Order Type | T176 | |
120 | BSTDK | BSTDK | DATUM | DATS | 8 | 0 | Customer purchase order date | ||
121 | BSTZD | BSTZD | BSTZD | CHAR | 4 | 0 | Customer purchase order number supplement | ||
122 | IHREZ | IHREZ | TEXT12 | CHAR | 12 | 0 | Your Reference | ||
123 | BNAME | BNAME_V | NAME | CHAR | 35 | 0 | Name of orderer | ||
124 | TELF1 | TELF1_VP | TELF1 | CHAR | 16 | 0 | Telephone Number | ||
125 | TELFX | TELFX | TEXT31 | CHAR | 31 | 0 | Fax Number | ||
126 | PARNR | ISM_CNTCT_PRSN | BU_PARTNER | CHAR | 10 | 0 | IS-M: Contact Person | * | |
127 | ZUKOMM | JZUKOMM | TEXT50 | CHAR | 50 | 0 | IS-M: Additional Communication Data | ||
128 | .INCLUDE | 0 | 0 | IS-M/AM: Product Hierarchy (S&P): Include for JHAP | |||||
129 | PRDH_HERKUNFT | ISM_PRDH_HERKUNFT | CHAR002 | CHAR | 2 | 0 | IS-M/AM: Origin Key | ||
130 | PRDH_PRODUKT | ISM_PRDH_PROD | ISM_PRDH_PRODUKT | CHAR | 11 | 0 | IS-M/AM: Product | ||
131 | DBCODE | DBCODE | DBCODE | CHAR | 1 | 0 | DB Code for Structural Changes |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | RJHAPVB | AVM_NR | JHAK | AVM_NR | |||
2 | RJHAPVB | BEDNR | JJTVB | BEDNR | KEY | 1 | CN |
3 | RJHAPVB | BRAN_PAM | TBRC | BRACO | |||
4 | RJHAPVB | BSARK | T176 | BSARK | REF | C | CN |
5 | RJHAPVB | KAMPAGNE | TJJKAMP | KAMPAGNE | REF | 1 | CN |
6 | RJHAPVB | MANDT | T000 | MANDT | |||
7 | RJHAPVB | POS_ART | TJH17 | AVMPOS_ART | |||
8 | RJHAPVB | PROSL | TJH23 | PRSCHL | KEY | 1 | CN |
9 | RJHAPVB | PSTYV | TJHAP | PSTYV | REF | 1 | CN |
10 | RJHAPVB | REF_AVM_NR | JHAK | AVM_NR | REF | 1 | CN |
11 | RJHAPVB | REF_POS_NR | JHAP | POS_NR | REF | 1 | CN |
12 | RJHAPVB | STAFO | TMCB | STAFO | REF | 1 | CN |
13 | RJHAPVB | STORNOGRND | TJHSTOG | STORNOGRD | REF | 1 | CN |
14 | RJHAPVB | SUC_AVM_NR | JHAK | AVM_NR | REF | 1 | CN |
15 | RJHAPVB | SUC_POS_NR | JHAP | POS_NR | REF | 1 | CN |
16 | RJHAPVB | VNR | JJTVV | VNR | KEY | 1 | CN |
17 | RJHAPVB | VORL_AVMNR | JHAK | AVM_NR | REF | 1 | CN |
18 | RJHAPVB | VORL_POSNR | JHAP | POS_NR | REF | 1 | CN |
19 | RJHAPVB | WERBK_EINT | JHAE | EIN_NR | 1 | CN | |
20 | RJHAPVB | WERBK_POS | JHAP | POS_NR | 1 | CN | |
21 | RJHAPVB | WERBK_TYP | TJH91 | WKOMBI_TYP | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |