SAP ABAP Table RJKJK11 (IS-M/SD: Interface for Data Transfer of Retail Stock - JK11)
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 | RJKJK11 |
|
| Short Description | IS-M/SD: Interface for Data Transfer of Retail Stock - JK11 |
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 | |
0 | 0 | IS-PSD: Data Transfer - Common Subscription + Retail Data | |||||
| 2 | |
AVNR | AVNR | CHAR | 10 | 0 | IS-M/SD: Publishing Sales Order | * | |
| 3 | |
REMELD_ISP | CHAR20 | CHAR | 20 | 0 | IS-M/SD: Reference Document in Legacy System | ||
| 4 | |
JKFUNKTION | JKFUNKTION | CHAR | 2 | 0 | Processing function for data transfer in sales order | ||
| 5 | |
GPAG | GPNR | CHAR | 10 | 0 | Business Partner: Sold-to Party | * | |
| 6 | |
AUART_ISP | AUART_ISP | CHAR | 4 | 0 | IS-M/SD: Sales Document Types | * | |
| 7 | |
VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | * | |
| 8 | |
VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | * | |
| 9 | |
SPART_AK | SPART | CHAR | 2 | 0 | Division for order header | * | |
| 10 | |
VKGRP | VKGRP | CHAR | 3 | 0 | Sales group | * | |
| 11 | |
VKBUR | VKBUR | CHAR | 4 | 0 | Sales office | * | |
| 12 | |
BSTNK | BSTNK | CHAR | 20 | 0 | Customer purchase order number | ||
| 13 | |
BSARK | BSARK | CHAR | 4 | 0 | Customer Order Type | * | |
| 14 | |
BSTDK | DATUM | DATS | 8 | 0 | Customer purchase order date | ||
| 15 | |
BSTZD | BSTZD | CHAR | 4 | 0 | Customer purchase order number supplement | ||
| 16 | |
IHREZ | TEXT12 | CHAR | 12 | 0 | Your Reference | ||
| 17 | |
BNAME_V | NAME | CHAR | 35 | 0 | Name of orderer | ||
| 18 | |
TELF1_VP | TELF1 | CHAR | 16 | 0 | Telephone Number | ||
| 19 | |
WAERK | WAERS | CUKY | 5 | 0 | SD document currency | * | |
| 20 | |
KURST | KURST | CHAR | 4 | 0 | Exchange Rate Type | * | |
| 21 | |
FAKTSPERRE | FAKSP | CHAR | 2 | 0 | Billing Block | * | |
| 22 | |
XSEPFKKOPF | XFELD | CHAR | 1 | 0 | Separate billing document for sales order | ||
| 23 | |
GPNR_WE | GPNR | CHAR | 10 | 0 | IS-M: Business Partner Ship-to Party | * | |
| 24 | |
DRERZ | DRERZ | CHAR | 8 | 0 | Publication | * | |
| 25 | |
PVA | PVA | CHAR | 8 | 0 | Edition | * | |
| 26 | |
BEZUGSTYP_JE_PVA | BEZUGSTYP_JE_PVA | CHAR | 2 | 0 | Mix Type | JDTBEZTYP | |
| 27 | |
LIEFERART | LIEFERART | CHAR | 2 | 0 | Delivery Type | * | |
| 28 | |
JKAPVON | DATUM | DATS | 8 | 0 | Valid-From Date of Sales Order Item | ||
| 29 | |
JKAPBIS | DATUM | DATS | 8 | 0 | Date to which Sales Order Item is Valid | ||
| 30 | |
BEZUGGRD | BEZUGGRD | CHAR | 3 | 0 | Purchase Reason | * | |
| 31 | |
IVWKN | IVWKN | CHAR | 8 | 0 | Circulation Audit Report Category ID | * | |
| 32 | |
LIEFXUHR | UZEIT | TIMS | 6 | 0 | Time of latest delivery | ||
| 33 | |
SBFREI | USNAM | CHAR | 12 | 0 | Administrator responsible for free copies | ||
| 34 | |
KUENDGRD | KUENDGRD | CHAR | 3 | 0 | Reason for end of delivery | * | |
| 35 | |
XLOGO | XFELD | CHAR | 1 | 0 | Print Logo | ||
| 36 | |
KONDA | KONDA | CHAR | 2 | 0 | Price Group (Customer) | * | |
| 37 | |
KDGRP | KDGRP | CHAR | 2 | 0 | Customer group | * | |
| 38 | |
PLTYP | PLTYP | CHAR | 2 | 0 | Price list type | * | |
| 39 | |
PERFK | WFCID | CHAR | 2 | 0 | Invoice dates (calendar identification) | * | |
| 40 | |
PRBAS_ISP | PRBAS_ISP | CHAR | 1 | 0 | Price Basis | ||
| 41 | |
PRBAS_VK | PRBAS_ISP | CHAR | 1 | 0 | Price Basis for Shipping Costs | ||
| 42 | |
XSEPFKPOS | XFELD | CHAR | 1 | 0 | Separate billing document for order item | ||
| 43 | |
GPNR_RG | GPNR | CHAR | 10 | 0 | IS-M: Payer Business Partner | * | |
| 44 | |
BANKS | LAND1 | CHAR | 3 | 0 | Bank country key | * | |
| 45 | |
BANKK | BANKK | CHAR | 15 | 0 | Bank Keys | ||
| 46 | |
BANKN | BANKN | CHAR | 18 | 0 | Bank account number | ||
| 47 | |
BKONT | BKONT | CHAR | 2 | 0 | Bank Control Key | ||
| 48 | |
BVTYP | BVTYP | CHAR | 4 | 0 | Partner bank type | ||
| 49 | |
XEZER | XFELD | CHAR | 1 | 0 | Indicator: Is there collection authorization ? | ||
| 50 | |
DZTERM | ZTERM | CHAR | 4 | 0 | Terms of payment key | ||
| 51 | |
GPNR_RE | GPNR | CHAR | 10 | 0 | IS-M: Business Partner - Bill-To Party | * | |
| 52 | |
BEZPER | BEZPER | CHAR | 5 | 0 | Service Type | * | |
| 53 | |
BEZPERFAKT | BEZPER | CHAR | 5 | 0 | IS-M: Service Type for Billing | * | |
| 54 | |
ETMENGE_N | ETMENGE_N | NUMC | 10 | 0 | IS-M: Numerical Schedule Line Quantity | ||
| 55 | |
PRSBINDDAT | DATUM | DATS | 8 | 0 | To-date for price fixing | ||
| 56 | |
FKDATVSYST | DATUM | DATS | 8 | 0 | 'Billed to' Date in Legacy System | ||
| 57 | |
0 | 0 | IS-PSD: Data Transfer - Specific Retail Data | |||||
| 58 | |
XREMRECHT | XFELD | CHAR | 1 | 0 | IS-M: Right of Return | ||
| 59 | |
REMART | REMART | CHAR | 1 | 0 | Return Type | ||
| 60 | |
REMWEISE | REMWEISE | CHAR | 1 | 0 | Return Method | ||
| 61 | |
REMQUOTE_N | NUMC5 | NUMC | 5 | 0 | Expected return rate - 3-figure number + 2 decimal places | ||
| 62 | |
XMAXREMMG | XFELD | CHAR | 1 | 0 | Expected return quantity is maximum return quantity | ||
| 63 | |
RECHBEGINN | DATUM | DATS | 8 | 0 | Billing From | ||
| 64 | |
0 | 0 | IS-M/SD: Address Fields from Screen Input | |||||
| 65 | |
JANRED | JANRED | CHAR | 2 | 0 | IS-M: Form-of-Address Key | TJG43 | |
| 66 | |
NAME1_ISP | NAME | CHAR | 35 | 0 | IS-M: Business Partner Name | ||
| 67 | |
NAME2_ISP | NAME | CHAR | 35 | 0 | IS-M: First Name of Business Partner | ||
| 68 | |
NAME3_ISP | NAME | CHAR | 35 | 0 | IS-M: Further Name Field for Business Partner | ||
| 69 | |
NAME4_ISP | NAME | CHAR | 35 | 0 | IS-M: Further Name Field for Business Partner | ||
| 70 | |
TITEL_ISP | TITEL | CHAR | 15 | 0 | IS-M: Title | T535N | |
| 71 | |
NAMZU_ISP | TITEL | CHAR | 15 | 0 | IS-M: Name Affix | T535N | |
| 72 | |
VORSW_ISP | TITEL | CHAR | 15 | 0 | IS-M: Name Prefix | T535N | |
| 73 | |
0 | 0 | Core address data | |||||
| 74 | |
PLZ_ISP | PSTLZ | CHAR | 10 | 0 | IS-M: Postal Code | ||
| 75 | |
PSTLZ_ADDON | CHAR4 | CHAR | 4 | 0 | IS-M: Extension to 5-Character ZIP Code | ||
| 76 | |
ORT01_ISP | TEXT35 | CHAR | 35 | 0 | IS-M: City | ||
| 77 | |
ORT02_ISP | TEXT35 | CHAR | 35 | 0 | IS-M: City District | ||
| 78 | |
PLZPF | PSTLZ | CHAR | 10 | 0 | IS-M: Postal Code for PO Box | ||
| 79 | |
PSTL2_ADDON | CHAR4 | CHAR | 4 | 0 | IS-M: Extension to 5-Character ZIP Code (PO Box) | ||
| 80 | |
PSTL3 | PSTLZ | CHAR | 10 | 0 | IS-M: Company Postal Code | ||
| 81 | |
PSTL3_ADDON | CHAR4 | CHAR | 4 | 0 | IS-M: Extension to 5-Character ZIP Code (Company) | ||
| 82 | |
PFACH_ISP | PFACH_ISP | CHAR | 10 | 0 | IS-M: Post Office Box | ||
| 83 | |
ORTPF | TEXT35 | CHAR | 35 | 0 | IS-M: City for PO Box | ||
| 84 | |
STRAS_ISP | TEXT35 | CHAR | 35 | 0 | IS-M: Street Name | ||
| 85 | |
HSNMR1 | HAUSNUMMER | CHAR | 10 | 0 | IS-M: House Number | ||
| 86 | |
HSNMR2 | CHAR8 | CHAR | 8 | 0 | IS-M: House Number Affix | ||
| 87 | |
ADRZUS2 | ADRZUS | CHAR | 6 | 0 | Classification Using a Further Address Affix | ||
| 88 | |
STOCK | STOCK | CHAR | 6 | 0 | Floor | ||
| 89 | |
LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | T005 | |
| 90 | |
DIRECTIONAL | DIRECTIONAL | CHAR | 10 | 0 | IS-M: Direction for Street | TJS41 | |
| 91 | |
DIRECTIONAL | DIRECTIONAL | CHAR | 10 | 0 | IS-M: Direction for Street | TJS41 | |
| 92 | |
ADDRSECABBREV | ADDRSECABBREV | CHAR | 4 | 0 | IS-M: Secondary Address Text | TJS43 | |
| 93 | |
ADDRSECNUMBER | ADDRSECNUMBER | CHAR | 8 | 0 | IS-M: Secondary Address Number | ||
| 94 | |
STREET2_ISM | TEXT35 | CHAR | 35 | 0 | IS-M: Second street line | ||
| 95 | |
0 | 0 | Include Structure for Alias (Alias Name) | |||||
| 96 | |
ALIASNAME | TEXT50 | CHAR | 50 | 0 | IS-M: Alias Text (Street Name + Suffix) | ||
| 97 | |
SORTL | CHAR10 | CHAR | 10 | 0 | Sort field | ||
| 98 | |
SPRAS | SPRAS | LANG | 1 | 0 | Language Key | T002 | |
| 99 | |
REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | T005S | |
| 100 | |
TELFX | TEXT31 | CHAR | 31 | 0 | Fax Number | ||
| 101 | |
TELTX | TEXT30 | CHAR | 30 | 0 | Teletex number | ||
| 102 | |
TELX1 | TEXT30 | CHAR | 30 | 0 | Telex number | ||
| 103 | |
JMAILN | SO_OBJ_NAM | CHAR | 12 | 0 | IS-M: Mail Address | ||
| 104 | |
0 | 0 | IS-P: Home/Work Telephone Data | |||||
| 105 | |
ISPTELVWP | ISPTELVW | CHAR | 10 | 0 | IS-M: Area Code (Home) | ||
| 106 | |
ISPTELP | ISPTEL | CHAR | 20 | 0 | IS-M: Telephone Number | ||
| 107 | |
ISPTELVWD | ISPTELVW | CHAR | 10 | 0 | IS-M: Area Code - Work | ||
| 108 | |
ISPTELD | ISPTEL | CHAR | 20 | 0 | IS-M: Telephone Number | ||
| 109 | |
ISPHANDY | CHAR30 | CHAR | 30 | 0 | IS-M: Mobile Phone Number | ||
| 110 | |
ISPEMAIL | CHAR50LOW | CHAR | 50 | 0 | IS-M: E-Mail Address | ||
| 111 | |
ISPADRBSND | TEXT50 | CHAR | 50 | 0 | IS-M/SD: Note for Home Delivery to Ship-to Party |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
| 1 | RJKJK11 | ADDRSECABBREV | |
|
KEY | 1 | CN |
| 2 | RJKJK11 | ANRED | |
|
|||
| 3 | RJKJK11 | BEZUGSTYP | |
|
|||
| 4 | RJKJK11 | LAND1 | |
|
|||
| 5 | RJKJK11 | NAMZU | |
|
|||
| 6 | RJKJK11 | POSTDIRECTIONAL | |
|
KEY | 1 | CN |
| 7 | RJKJK11 | PREDIRECTIONAL | |
|
KEY | 1 | CN |
| 8 | RJKJK11 | REGIO | |
|
|||
| 9 | RJKJK11 | SPRAS | |
|
|||
| 10 | RJKJK11 | TITEL | |
|
|||
| 11 | RJKJK11 | VORSW | |
|
History
| Last changed by/on | SAP | 20130529 |
| SAP Release Created in |