SAP ABAP Table RJK_JVSO (IS-M/SD: Struc.for Address-Based Shipping in Central Access)
Hierarchy
☛
IS-M (Software Component) SAP MEDIA
⤷ IS-M (Application Component) SAP Media
⤷ JSD (Package) Appl. dev. R/3 Publishing Sales and Distribution System
⤷ IS-M (Application Component) SAP Media
⤷ JSD (Package) Appl. dev. R/3 Publishing Sales and Distribution System
Basic Data
Table Category | INTTAB | Structure |
Structure | RJK_JVSO | Table Relationship Diagram |
Short Description | IS-M/SD: Struc.for Address-Based Shipping in Central Access |
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 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
2 | ORDNBR | SHIPORDNBR | SHIPORDNBR | CHAR | 10 | 0 | Address-Based Shipping Order Number | * | |
3 | POSNBR | SHIPORDPOSNBR | SHIPORDPOSNBR | NUMC | 8 | 0 | Address-Based Shipping Order Item Number | * | |
4 | TEXT | TEXT50 | TEXT50 | CHAR | 50 | 0 | Text Field | ||
5 | SOLDTOPARTY | GPNR | GPNR | CHAR | 10 | 0 | IS-M: Business Partner Key | * | |
6 | PUBLICATION | DRERZ | DRERZ | CHAR | 8 | 0 | Publication | * | |
7 | EDITION | PVA | PVA | CHAR | 8 | 0 | Edition | * | |
8 | MEDIAPRODUCT | ISMMATNR_PRODUCT | MATNR | CHAR | 18 | 0 | Media Product | * | |
9 | MEDIAISSUE | MATNR | MATNR | CHAR | 18 | 0 | Material Number | * | |
10 | VALIDFROM | GUELTIGVON | DATUM | DATS | 8 | 0 | Valid-From Date | ||
11 | VALIDTO | GUELTIGBIS | DATUM | DATS | 8 | 0 | Valid-To Date | ||
12 | QUANTITY | JVQUANTITY | LIEFRMENG2 | QUAN | 9 | 0 | Quantity for Shipping Order Item | ||
13 | UNIT | MEINLIEF | MEINS | UNIT | 3 | 0 | Unit of Measure for Delivery Quantity | * | |
14 | ADDRESS | JADRNR | JADRNR | CHAR | 10 | 0 | IS-M: Address Number | * | |
15 | ADDRESS_VARIANT | ADRESSVAR | ERSTADR | CHAR | 1 | 0 | IS-M: Address Variant | ||
16 | POST_CODE | PLZ_ISP | PSTLZ | CHAR | 10 | 0 | IS-M: Postal Code | ||
17 | UNL_POINT | BEABLST | BEABLST | CHAR | 10 | 0 | IS-M: Unloading Point | * | |
18 | INCOMPLETE | XUNVLIEFER | XFELD | CHAR | 1 | 0 | IS-M: Viability Data Incomplete for Item | ||
19 | DOCNBR_CUST | JV_DOCNBR_CUST | VBELN | CHAR | 10 | 0 | IS-M/SD: Customer Document Number | * | |
20 | DOCPOSNBR_CUST | JV_DOCPOSNBR_CUST | POSNR | NUMC | 6 | 0 | IS-M/SD: Customer Document Item Number | * | |
21 | REFDOC | REMELD_ISP | CHAR20 | CHAR | 20 | 0 | IS-M/SD: Reference Document in Legacy System | ||
22 | ADDRESS_CHANGED | JVADDRESS_CHANGED | XFELD | CHAR | 1 | 0 | IS-M/SD: Address changed | ||
23 | .INCLUDE | 0 | 0 | Created-By Data (Medium Scope) | |||||
24 | ERFUSER | ERFUSER | USNAM | CHAR | 12 | 0 | Created By | ||
25 | ERFDATE | ERFDATE | DATUM | DATS | 8 | 0 | Created On | ||
26 | ERFTIME | ERFTIME | UZEIT | TIMS | 6 | 0 | Time Created | ||
27 | AENUSER | AENUSER | USNAM | CHAR | 12 | 0 | Last Changed By | ||
28 | AENDATE | AENDATE | DATUM | DATS | 8 | 0 | Date of Last Change | ||
29 | AENTIME | AENTIME | UZEIT | TIMS | 6 | 0 | Time of Last Change | ||
30 | .INCLUDE | 0 | 0 | Generated Table for View | |||||
31 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
32 | ADRNR | JADRNR | JADRNR | CHAR | 10 | 0 | IS-M: Address Number | * | |
33 | HERK | HERK | HERK | CHAR | 1 | 0 | IS-M: Use of Address | ||
34 | XADRLOE | XLOES | XFELD | CHAR | 1 | 0 | IS-M: Deletion Flag for Address | ||
35 | NAME1 | NAME1_ISP | NAME | CHAR | 35 | 0 | IS-M: Business Partner Name | ||
36 | NAME2 | NAME2_ISP | NAME | CHAR | 35 | 0 | IS-M: First Name of Business Partner | ||
37 | NAME3 | NAME3_ISP | NAME | CHAR | 35 | 0 | IS-M: Further Name Field for Business Partner | ||
38 | NAME4 | NAME4_ISP | NAME | CHAR | 35 | 0 | IS-M: Further Name Field for Business Partner | ||
39 | PSTLZ | PLZ_ISP | PSTLZ | CHAR | 10 | 0 | IS-M: Postal Code | ||
40 | ORT01 | ORT01_ISP | TEXT35 | CHAR | 35 | 0 | IS-M: City | ||
41 | ORT02 | ORT02_ISP | TEXT35 | CHAR | 35 | 0 | IS-M: City District | ||
42 | PSTL2 | PLZPF | PSTLZ | CHAR | 10 | 0 | IS-M: Postal Code for PO Box | ||
43 | PSTL3 | PSTL3 | PSTLZ | CHAR | 10 | 0 | IS-M: Company Postal Code | ||
44 | PFACH | PFACH_ISP | PFACH_ISP | CHAR | 10 | 0 | IS-M: Post Office Box | ||
45 | ORTPF | ORTPF | TEXT35 | CHAR | 35 | 0 | IS-M: City for PO Box | ||
46 | STRAS | STRAS_ISP | TEXT35 | CHAR | 35 | 0 | IS-M: Street Name | ||
47 | HAUSN | HSNMR1 | HAUSNUMMER | CHAR | 10 | 0 | IS-M: House Number | ||
48 | HSNMR2 | HSNMR2 | CHAR8 | CHAR | 8 | 0 | IS-M: House Number Affix | ||
49 | ADRZUS2 | ADRZUS2 | ADRZUS | CHAR | 6 | 0 | Classification Using a Further Address Affix | ||
50 | STOCK | STOCK | STOCK | CHAR | 6 | 0 | Floor | ||
51 | LAND1 | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | T005 | |
52 | PREDIRECTIONAL | DIRECTIONAL | DIRECTIONAL | CHAR | 10 | 0 | IS-M: Direction for Street | TJS41 | |
53 | POSTDIRECTIONAL | DIRECTIONAL | DIRECTIONAL | CHAR | 10 | 0 | IS-M: Direction for Street | TJS41 | |
54 | ADDRSECABBREV | ADDRSECABBREV | ADDRSECABBREV | CHAR | 4 | 0 | IS-M: Secondary Address Text | TJS43 | |
55 | ADDRSECNUMBER | ADDRSECNUMBER | ADDRSECNUMBER | CHAR | 8 | 0 | IS-M: Secondary Address Number | ||
56 | STREET2 | STREET2_ISM | TEXT35 | CHAR | 35 | 0 | IS-M: Second street line | ||
57 | ALIASNAME | ALIASNAME | TEXT50 | CHAR | 50 | 0 | IS-M: Alias Text (Street Name + Suffix) | ||
58 | ERSTADR | ERSTADR | ERSTADR | CHAR | 1 | 0 | IS-M: Address Proposal for Alternatives | ||
59 | POSTEINSTR | STRASSENNR | STRASSENNR | CHAR | 10 | 0 | IS-M: Street Number | * | |
60 | SORTL | SORTL | CHAR10 | CHAR | 10 | 0 | Sort field | ||
61 | SPRAS | SPRAS | SPRAS | LANG | 1 | 0 | Language Key | T002 | |
62 | REGIO | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | T005S | |
63 | GP_REF | GPNR | GPNR | CHAR | 10 | 0 | IS-M: Business Partner Key | JGTGPNR | |
64 | NAME1_MACO | NAME1_ISPM | NAME_MACO | CHAR | 35 | 0 | IS-M: Business Partner Name (Upper Case for Matchcode) | ||
65 | NAME2_MACO | NAME2_ISPM | NAME_MACO | CHAR | 35 | 0 | IS-M: Bus.Partner's First Name (Upper Case for Matchcode) | ||
66 | STRAS_MACO | STRAS_ISPM | STRAS_MACO | CHAR | 35 | 0 | IS-M: Street Name | ||
67 | ORT01_MACO | ORT01_ISPM | ORT01_MACO | CHAR | 35 | 0 | IS-M/SD: City Name (Upper Case for Matchcode) | ||
68 | ISPTELVWP | ISPTELVWP | ISPTELVW | CHAR | 10 | 0 | IS-M: Area Code (Home) | ||
69 | ISPTELP | ISPTELP | ISPTEL | CHAR | 20 | 0 | IS-M: Telephone Number | ||
70 | ISPTELVWD | ISPTELVWD | ISPTELVW | CHAR | 10 | 0 | IS-M: Area Code - Work | ||
71 | ISPTELD | ISPTELD | ISPTEL | CHAR | 20 | 0 | IS-M: Telephone Number | ||
72 | ISPHANDY | ISPHANDY | CHAR30 | CHAR | 30 | 0 | IS-M: Mobile Phone Number | ||
73 | DISTRICT | BEZIRK | BEZIRK | CHAR | 10 | 0 | Carrier Route | * | |
74 | GEO_UNIT | GEOEIN | GEOEIN | CHAR | 10 | 0 | Number of Geographical Unit | * | |
75 | DELIV_TYPE | LIEFERART | LIEFERART | CHAR | 2 | 0 | Delivery Type | * | |
76 | VIABILITY | LIEFBARNR | LIEFBARNR | CHAR | 9 | 0 | Sequence number for delivery/home delivery viability set | * | |
77 | ICON_STATE | ICON_L4 | ICON | CHAR | 4 | 0 | Icon with output length 4 | * | |
78 | ADR_LINE1 | J_TEXT40 | CHAR40 | CHAR | 40 | 0 | IS-M/SD: Text field without description | ||
79 | ADR_LINE2 | J_TEXT40 | CHAR40 | CHAR | 40 | 0 | IS-M/SD: Text field without description | ||
80 | ADR_LINE3 | J_TEXT40 | CHAR40 | CHAR | 40 | 0 | IS-M/SD: Text field without description | ||
81 | EMPTY1 | JEMPTY | CHAR40 | CHAR | 40 | 0 | IS-M/SD: Blank field for aligning ALV lists | ||
82 | EMPTY2 | JEMPTY | CHAR40 | CHAR | 40 | 0 | IS-M/SD: Blank field for aligning ALV lists | ||
83 | ORDNBR_OUT | SHIPORDNBR | SHIPORDNBR | CHAR | 10 | 0 | Address-Based Shipping Order Number | * | |
84 | ICON_RS | ICON_RS | ICON_L2 | CHAR | 4 | 0 | IS-M/SD: Icon - Complaint Exists for Selection Period | ||
85 | ICON_RG | ICON_RG | ICON_L2 | CHAR | 4 | 0 | IS-M/SD: Icon - General Complaint Exists |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | RJK_JVSO | ADDRSECABBREV | TJS43 | ADDRSECABBREV | KEY | 1 | CN |
2 | RJK_JVSO | GP_REF | JGTGPNR | GPNR | REF | C | CN |
3 | RJK_JVSO | LAND1 | T005 | LAND1 | REF | C | CN |
4 | RJK_JVSO | MANDT | T000 | MANDT | KEY | 1 | CN |
5 | RJK_JVSO | POSTDIRECTIONAL | TJS41 | DIRECTIONAL | KEY | 1 | CN |
6 | RJK_JVSO | PREDIRECTIONAL | TJS41 | DIRECTIONAL | KEY | 1 | CN |
7 | RJK_JVSO | REGIO | T005S | BLAND | REF | C | CN |
8 | RJK_JVSO | SPRAS | T002 | SPRAS | REF | C | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 462 |