SAP ABAP Table J_1SLFGADR (Generated Table for View)
Basic Data
Table Category | VIEW | General view structure |
General view structure | J_1SLFGADR | 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 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | LFNGNR | LFNGNR | LFNGNR | NUMC | 12 | 0 | IS-M: Sequence Number for Delivery | JVTLFNG | |
3 | NACHLFNGNR | NACHLFNGNR | NUM2 | NUMC | 2 | 0 | Sequence number of subsequent delivery | ||
4 | VBELN | AVNR | AVNR | CHAR | 10 | 0 | IS-M/SD: Publishing Sales Order | JKAK | |
5 | POSNR | APNR | APNR | NUMC | 6 | 0 | Sales Order Item | JKAP | |
6 | ETENR | JAENR | AENR | NUMC | 4 | 0 | Sales Order Schedule Line | JKEP | |
7 | JPARVW | JPARVW | JPARVW | CHAR | 2 | 0 | IS-M: Business Partner Role | TJG39 | |
8 | PARZA | JPARZA | JPARZA | NUMC | 3 | 0 | IS-M: Partner Role Counter | ||
9 | GUELTIGVON | JKPAVON | DATUM | DATS | 8 | 0 | Date from Which Partner Data in Sales Order is Valid | ||
10 | GUELTIGBIS | JKPABIS | DATUM | DATS | 8 | 0 | Date to Which Partner Data in Sales Order is Valid | ||
11 | ADRNR | JADRNR | JADRNR | CHAR | 10 | 0 | IS-M: Address Number | JGTSADR | |
12 | PLZ_ORDER | PLZ_ISP | PSTLZ | CHAR | 10 | 0 | IS-M: Postal Code | ||
13 | MENGEINZUO | MENGEINZUO | STMENGE | DEC | 9 | 0 | Sch.line qty in order-delivery assignment for partial susp. | ||
14 | ETART | ETART_ISP | ETART_ISP | CHAR | 2 | 0 | Schedule Line Type for Internal Sales Order Schedule Line | TJEP | |
15 | ETMENGE | ETMENGE | MENGGPOS | QUAN | 10 | 0 | IS-M: Sales Order Schedule Line Quantity | ||
16 | ETMEINS | ETMEINS | MEINS | UNIT | 3 | 0 | IS-M: Sales Unit for Sales Order | T006 | |
17 | ADRESSVAR | ADRESSVAR | ERSTADR | CHAR | 1 | 0 | IS-M: Address Variant | ||
18 | LAND1 | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | T005 | |
19 | POSTEINORT | JALORT | ALORT | CHAR | 8 | 0 | IS-M: City Number (Unique) | JSTORTPRO | |
20 | POSTEINSTR | STRASSENNR | STRASSENNR | CHAR | 10 | 0 | IS-M: Street Number | JSTSTRPRO | |
21 | STRAS | STRAS_ISP | TEXT35 | CHAR | 35 | 0 | IS-M: Street Name | ||
22 | HAUSN | HSNMR1 | HAUSNUMMER | CHAR | 10 | 0 | IS-M: House Number | ||
23 | HSNMR2 | HSNMR2 | CHAR8 | CHAR | 8 | 0 | IS-M: House Number Affix |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | J_1SLFGADR | ADRNR | JGTSADR | ADRNR | REF | C | CN |
2 | J_1SLFGADR | ETART | TJEP | ETART | REF | C | CN |
3 | J_1SLFGADR | ETENR | JKEP | ETENR | KEY | 1 | CN |
4 | J_1SLFGADR | ETMEINS | T006 | MSEHI | REF | C | CN |
5 | J_1SLFGADR | JPARVW | TJG39 | JPARVW | KEY | 1 | CN |
6 | J_1SLFGADR | LAND1 | T005 | LAND1 | REF | C | CN |
7 | J_1SLFGADR | LFNGNR | JVTLFNG | LFNGNR | KEY | 1 | CN |
8 | J_1SLFGADR | MANDT | T000 | MANDT | KEY | 1 | CN |
9 | J_1SLFGADR | POSNR | JKAP | POSNR | KEY | 1 | CN |
10 | J_1SLFGADR | POSTEINORT | JSTORTPRO | ALORT | REF | C | CN |
11 | J_1SLFGADR | POSTEINSTR | JSTSTRPRO | STRASSENNR | REF | C | CN |
12 | J_1SLFGADR | VBELN | JKAK | VBELN | KEY | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |