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