SAP ABAP View JHVGPZADR (IS-M/AM: View for Report RJH_CPD_ADDRESS_TO_CAM_462)
Hierarchy
☛
IS-M (Software Component) SAP MEDIA
⤷
IS-M (Application Component) SAP Media
⤷
JAS (Package) Application development R/3 Publishing Advertising System***

⤷

⤷

Basic Data
View Type | D | Database View |
Database View | JHVGPZADR | |
Short Description | IS-M/AM: View for Report RJH_CPD_ADDRESS_TO_CAM_462 | |
Root table | JHAGPZ | IS-M/AM: Assign Business Partner to Order and Item |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | ![]() |
JHAGPZ | ||
2 | ![]() |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
MANDT | JL | EQ | 0 | 0 | ||||
2 | ![]() |
MANDT | JR | EQ | AND | 0 | 0 | |||
3 | ![]() |
ADRNR | JL | EQ | 0 | 0 | ||||
4 | ![]() |
ADRNR | JR | EQ | AND | 0 | 0 | |||
5 | ![]() |
GPROLLE | EQ | 'AG' | AND | 0 | 0 | |||
6 | ![]() |
XCPDK | EQ | 'X' | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | ![]() |
![]() |
MANDT | MANDT | Client | |||
2 | ![]() |
![]() |
AVM_NR | AVM_NR | IS-M/AM: Sales Document Number | |||
3 | ![]() |
![]() |
POS_NR | POS_NR | IS-M: Order Item Number | |||
4 | ![]() |
![]() |
GPROLLE | JPARVW | IS-M: Business Partner Role | |||
5 | ![]() |
![]() |
GPNR | GPNR | IS-M: Business Partner Key | |||
6 | ![]() |
![]() |
PARZA | JPARZA | IS-M: Partner Role Counter | |||
7 | ![]() |
![]() |
GRUPPABRNR | GRUPPABRNR | IS-M/AM: Billing Dataset | |||
8 | ![]() |
![]() |
UPOS_NR | UPOS_NR | IS-M: Order Sub-Item Number | |||
9 | ![]() |
![]() |
EIN_NR | EIN_NR | IS-M: Schedule Line | |||
10 | ![]() |
![]() |
MOTIV | MOTIV_NR | IS-M: Ad Spec Number (Ad) | |||
11 | ![]() |
![]() |
ADRNR | JADRNR | IS-M: Address Number | |||
12 | ![]() |
![]() |
LOGADR | JLOGADR | IS-M: Logical Address Number | |||
13 | ![]() |
![]() |
SADR_ADRNR | CADNR | Addresses: Address Number | |||
14 | ![]() |
![]() |
ADRC_ADDRNUMBER | AD_ADDRNUM | Address number | |||
15 | ![]() |
![]() |
ANRED | JANRED | IS-M: Form-of-Address Key | |||
16 | ![]() |
![]() |
NAME1 | NAME1_ISP | IS-M: Business Partner Name | |||
17 | ![]() |
![]() |
NAME2 | NAME2_ISP | IS-M: First Name of Business Partner | |||
18 | ![]() |
![]() |
NAME3 | NAME3_ISP | IS-M: Further Name Field for Business Partner | |||
19 | ![]() |
![]() |
NAME4 | NAME4_ISP | IS-M: Further Name Field for Business Partner | |||
20 | ![]() |
![]() |
TITEL | TITEL_ISP | IS-M: Title | |||
21 | ![]() |
![]() |
NAMZU | NAMZU_ISP | IS-M: Name Affix | |||
22 | ![]() |
![]() |
VORSW | VORSW_ISP | IS-M: Name Prefix | |||
23 | ![]() |
![]() |
PSTLZ | PLZ_ISP | IS-M: Postal Code | |||
24 | ![]() |
![]() |
PSTLZ_ADDON | PSTLZ_ADDON | IS-M: Extension to 5-Character ZIP Code | |||
25 | ![]() |
![]() |
ORT01 | ORT01_ISP | IS-M: City | |||
26 | ![]() |
![]() |
ORT02 | ORT02_ISP | IS-M: City District | |||
27 | ![]() |
![]() |
PSTL2 | PLZPF | IS-M: Postal Code for PO Box | |||
28 | ![]() |
![]() |
PSTL2_ADDON | PSTL2_ADDON | IS-M: Extension to 5-Character ZIP Code (PO Box) | |||
29 | ![]() |
![]() |
PSTL3 | PSTL3 | IS-M: Company Postal Code | |||
30 | ![]() |
![]() |
PSTL3_ADDON | PSTL3_ADDON | IS-M: Extension to 5-Character ZIP Code (Company) | |||
31 | ![]() |
![]() |
PFACH | PFACH_ISP | IS-M: Post Office Box | |||
32 | ![]() |
![]() |
ORTPF | ORTPF | IS-M: City for PO Box | |||
33 | ![]() |
![]() |
STRAS | STRAS_ISP | IS-M: Street Name | |||
34 | ![]() |
![]() |
HAUSN | HSNMR1 | IS-M: House Number | |||
35 | ![]() |
![]() |
HSNMR2 | HSNMR2 | IS-M: House Number Affix | |||
36 | ![]() |
![]() |
ADRZUS2 | ADRZUS2 | Classification Using a Further Address Affix | |||
37 | ![]() |
![]() |
STOCK | STOCK | Floor | |||
38 | ![]() |
![]() |
LAND1 | LAND1 | Country Key | |||
39 | ![]() |
![]() |
PREDIRECTIONAL | DIRECTIONAL | IS-M: Direction for Street | |||
40 | ![]() |
![]() |
POSTDIRECTIONAL | DIRECTIONAL | IS-M: Direction for Street | |||
41 | ![]() |
![]() |
ADDRSECABBREV | ADDRSECABBREV | IS-M: Secondary Address Text | |||
42 | ![]() |
![]() |
ADDRSECNUMBER | ADDRSECNUMBER | IS-M: Secondary Address Number | |||
43 | ![]() |
![]() |
STREET2 | STREET2_ISM | IS-M: Second street line | |||
44 | ![]() |
![]() |
POSTEINORT | JALORT | IS-M: City Number (Unique) | |||
45 | ![]() |
![]() |
ERSTADR | ERSTADR | IS-M: Address Proposal for Alternatives | |||
46 | ![]() |
![]() |
POSTEINSTR | STRASSENNR | IS-M: Street Number | |||
47 | ![]() |
![]() |
PEINORTPF | ALORT2 | IS-M: Postal Unit of City for PO Box | |||
48 | ![]() |
![]() |
LOCCO | LOCCO | City Coordinates | |||
49 | ![]() |
![]() |
NIELS | NIELS | Nielsen ID | |||
50 | ![]() |
![]() |
COUNC | COUNC | County Code | |||
51 | ![]() |
![]() |
CITYC | CITYC | City Code | |||
52 | ![]() |
![]() |
RPMKR | RPMKR | Regional market | |||
53 | ![]() |
![]() |
SORTL | SORTL | Sort field | |||
54 | ![]() |
![]() |
SORT2 | SORTL2 | IS-M: Sort Field 2 (for Internal Use) | |||
55 | ![]() |
![]() |
SORT3 | SORTL3 | IS-M: Sort field 3 (internal) | |||
56 | ![]() |
![]() |
SPRAS | SPRAS | Language Key | |||
57 | ![]() |
![]() |
REGIO | REGIO | Region (State, Province, County) | |||
58 | ![]() |
![]() |
TELFP | TELFP | IS-M: Home Phone Number | |||
59 | ![]() |
![]() |
TELFD | TELFD | IS-M: Telephone Number at Work | |||
60 | ![]() |
![]() |
TELW1 | TELWT | IS-M: Additional Telephone Number | |||
61 | ![]() |
![]() |
TELW2 | TELWT | IS-M: Additional Telephone Number | |||
62 | ![]() |
![]() |
TELW3 | TELWT | IS-M: Additional Telephone Number | |||
63 | ![]() |
![]() |
TELW4 | TELWF | IS-M: Mobile Phone Number | |||
64 | ![]() |
![]() |
TELW5 | TELWF | IS-M: Mobile Phone Number | |||
65 | ![]() |
![]() |
TELFX | TELFX | Fax Number | |||
66 | ![]() |
![]() |
TELF1 | TELFT | IS-M: Additional Fax Number | |||
67 | ![]() |
![]() |
TELF2 | TELFT | IS-M: Additional Fax Number | |||
68 | ![]() |
![]() |
TELF3 | TELFT | IS-M: Additional Fax Number | |||
69 | ![]() |
![]() |
TELTX | TELTX | Teletex number | |||
70 | ![]() |
![]() |
TELX1 | TELX1 | Telex number | |||
71 | ![]() |
![]() |
TELBX | TELBX | Telebox number | |||
72 | ![]() |
![]() |
DATLT | DATLT | Data communication line no. | |||
73 | ![]() |
![]() |
STDKO | STDKO_D | Default communications service | |||
74 | ![]() |
![]() |
BEABLS_REF | BEABLST | IS-M: Unloading Point | |||
75 | ![]() |
![]() |
TELFP_COD | TELFP | IS-M: Home Phone Number | |||
76 | ![]() |
![]() |
TELFD_COD | TELFD | IS-M: Telephone Number at Work | |||
77 | ![]() |
![]() |
NAME1_MACO | NAME1_ISPM | IS-M: Business Partner Name (Upper Case for Matchcode) | |||
78 | ![]() |
![]() |
NAME2_MACO | NAME2_ISPM | IS-M: Bus.Partner's First Name (Upper Case for Matchcode) | |||
79 | ![]() |
![]() |
STRAS_MACO | STRAS_ISPM | IS-M: Street Name | |||
80 | ![]() |
![]() |
ORT01_MACO | ORT01_ISPM | IS-M/SD: City Name (Upper Case for Matchcode) | |||
81 | ![]() |
![]() |
ISPTELVWP | ISPTELVWP | IS-M: Area Code (Home) | |||
82 | ![]() |
![]() |
ISPTELP | ISPTELP | IS-M: Telephone Number | |||
83 | ![]() |
![]() |
ISPTELVWD | ISPTELVWD | IS-M: Area Code - Work | |||
84 | ![]() |
![]() |
ISPTELD | ISPTELD | IS-M: Telephone Number | |||
85 | ![]() |
![]() |
ISPHANDY | ISPHANDY | IS-M: Mobile Phone Number | |||
86 | ![]() |
![]() |
ISPEMAIL | ISPEMAIL | IS-M: E-Mail Address | |||
87 | ![]() |
![]() |
ISPADRBSND | ISPADRBSND | IS-M/SD: Note for Home Delivery to Ship-to Party | |||
88 | ![]() |
![]() |
TECHNUMZUG | TECHNUMZUG | IS-M: Technical Relocation Due to Postal Data Change | |||
89 | ![]() |
![]() |
TXJCD | TXJCD | Tax Jurisdiction | |||
90 | ![]() |
![]() |
ANI_TELNRP | AD_TELNRCL | Telephone number for determining caller | |||
91 | ![]() |
![]() |
ANI_TELNRD | AD_TELNRCL | Telephone number for determining caller | |||
Maintenance Status
read only |
read and change |
Time-dependent views: like U, validity data like ' ' |
read, change, delete and insert |
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 462 |