SAP ABAP Table JVVSOP_ADR (Generated Table for View)
Basic Data
Table Category | VIEW | General view structure |
General view structure | JVVSOP_ADR | Table Relationship Diagram |
Short Description | Generated Table for View |
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 | T000 | |
2 | ORDNBR | SHIPORDNBR | SHIPORDNBR | CHAR | 10 | 0 | Address-Based Shipping Order Number | JVSOH | |
3 | POSNBR | SHIPORDPOSNBR | SHIPORDPOSNBR | NUMC | 8 | 0 | Address-Based Shipping Order Item Number | ||
4 | VALIDFROM | GUELTIGVON | DATUM | DATS | 8 | 0 | Valid-From Date | ||
5 | VALIDTO | GUELTIGBIS | DATUM | DATS | 8 | 0 | Valid-To Date | ||
6 | QUANTITY | JVQUANTITY | LIEFRMENG2 | QUAN | 9 | 0 | Quantity for Shipping Order Item | ||
7 | UNIT | MEINLIEF | MEINS | UNIT | 3 | 0 | Unit of Measure for Delivery Quantity | T006 | |
8 | ADDRESS | JADRNR | JADRNR | CHAR | 10 | 0 | IS-M: Address Number | JGTSADR | |
9 | ADDRESS_VARIANT | ADRESSVAR | ERSTADR | CHAR | 1 | 0 | IS-M: Address Variant | ||
10 | POST_CODE | PLZ_ISP | PSTLZ | CHAR | 10 | 0 | IS-M: Postal Code | ||
11 | INCOMPLETE | XUNVLIEFER | XFELD | CHAR | 1 | 0 | IS-M: Viability Data Incomplete for Item | ||
12 | COUNTRY | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | T005 | |
13 | CITY_NBR | JALORT | ALORT | CHAR | 8 | 0 | IS-M: City Number (Unique) | JSTORTPRO | |
14 | STREET_NBR | STRASSENNR | STRASSENNR | CHAR | 10 | 0 | IS-M: Street Number | JSTSTRPRO | |
15 | POBOX_NBR | ALORT2 | ALORT | CHAR | 8 | 0 | IS-M: Postal Unit of City for PO Box | JSTORTPRO | |
16 | STREET_CODED | UVADR_AD | UVADR_AD | CHAR | 1 | 0 | IS-M: Coding Status of Address | ||
17 | POBOX_CODED | UVADR_AD | UVADR_AD | CHAR | 1 | 0 | IS-M: Coding Status of Address | ||
18 | MAJCUS_CODED | UVADR_AD | UVADR_AD | CHAR | 1 | 0 | IS-M: Coding Status of Address |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | JVVSOP_ADR | ADDRESS | JGTSADR | ADRNR | KEY | 1 | CN |
2 | JVVSOP_ADR | CITY_NBR | JSTORTPRO | ALORT | REF | C | CN |
3 | JVVSOP_ADR | CLIENT | T000 | MANDT | KEY | 1 | CN |
4 | JVVSOP_ADR | COUNTRY | T005 | LAND1 | REF | C | CN |
5 | JVVSOP_ADR | ORDNBR | JVSOH | ORDNBR | KEY | 1 | CN |
6 | JVVSOP_ADR | POBOX_NBR | JSTORTPRO | ALORT | REF | C | CN |
7 | JVVSOP_ADR | STREET_NBR | JSTSTRPRO | STRASSENNR | REF | C | CN |
8 | JVVSOP_ADR | UNIT | T006 | MSEHI | KEY | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |