SAP ABAP Table RJKJK01 (IS-MSD: Interface for Data Transfer of Live Subscrips - JK01)
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 | RJKJK01 | Table Relationship Diagram |
Short Description | IS-MSD: Interface for Data Transfer of Live Subscrips - JK01 |
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 | .INCLUDE | 0 | 0 | IS-PSD: Data Transfer - Common Subscription + Retail Data | |||||
2 | VBELN | AVNR | AVNR | CHAR | 10 | 0 | IS-M/SD: Publishing Sales Order | * | |
3 | REFBELEG | REMELD_ISP | CHAR20 | CHAR | 20 | 0 | IS-M/SD: Reference Document in Legacy System | ||
4 | FUNKTION | JKFUNKTION | JKFUNKTION | CHAR | 2 | 0 | Processing function for data transfer in sales order | ||
5 | GPNR_AG | GPAG | GPNR | CHAR | 10 | 0 | Business Partner: Sold-to Party | * | |
6 | AUART | AUART_ISP | AUART_ISP | CHAR | 4 | 0 | IS-M/SD: Sales Document Types | * | |
7 | VKORG | VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | * | |
8 | VTWEG | VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | * | |
9 | SPART | SPART_AK | SPART | CHAR | 2 | 0 | Division for order header | * | |
10 | VKGRP | VKGRP | VKGRP | CHAR | 3 | 0 | Sales group | * | |
11 | VKBUR | VKBUR | VKBUR | CHAR | 4 | 0 | Sales office | * | |
12 | BSTNK | BSTNK | BSTNK | CHAR | 20 | 0 | Customer purchase order number | ||
13 | BSARK | BSARK | BSARK | CHAR | 4 | 0 | Customer Order Type | * | |
14 | BSTDK | BSTDK | DATUM | DATS | 8 | 0 | Customer purchase order date | ||
15 | BSTZD | BSTZD | BSTZD | CHAR | 4 | 0 | Customer purchase order number supplement | ||
16 | IHREZ | IHREZ | TEXT12 | CHAR | 12 | 0 | Your Reference | ||
17 | BNAME | BNAME_V | NAME | CHAR | 35 | 0 | Name of orderer | ||
18 | TELF1 | TELF1_VP | TELF1 | CHAR | 16 | 0 | Telephone Number | ||
19 | WAERK | WAERK | WAERS | CUKY | 5 | 0 | SD document currency | * | |
20 | KURST | KURST | KURST | CHAR | 4 | 0 | Exchange Rate Type | * | |
21 | FAKSP | FAKTSPERRE | FAKSP | CHAR | 2 | 0 | Billing Block | * | |
22 | XSEPFKKOPF | XSEPFKKOPF | XFELD | CHAR | 1 | 0 | Separate billing document for sales order | ||
23 | GPNR_WE | GPNR_WE | GPNR | CHAR | 10 | 0 | IS-M: Business Partner Ship-to Party | * | |
24 | DRERZ | DRERZ | DRERZ | CHAR | 8 | 0 | Publication | * | |
25 | PVA | PVA | PVA | CHAR | 8 | 0 | Edition | * | |
26 | BEZUGSTYP | BEZUGSTYP_JE_PVA | BEZUGSTYP_JE_PVA | CHAR | 2 | 0 | Mix Type | JDTBEZTYP | |
27 | LIEFERART | LIEFERART | LIEFERART | CHAR | 2 | 0 | Delivery Type | * | |
28 | GUELTIGVON | JKAPVON | DATUM | DATS | 8 | 0 | Valid-From Date of Sales Order Item | ||
29 | GUELTIGBIS | JKAPBIS | DATUM | DATS | 8 | 0 | Date to which Sales Order Item is Valid | ||
30 | BEZUGGRD | BEZUGGRD | BEZUGGRD | CHAR | 3 | 0 | Purchase Reason | * | |
31 | IVWKN | IVWKN | IVWKN | CHAR | 8 | 0 | Circulation Audit Report Category ID | * | |
32 | LIEFXUHR | LIEFXUHR | UZEIT | TIMS | 6 | 0 | Time of latest delivery | ||
33 | SBFREI | SBFREI | USNAM | CHAR | 12 | 0 | Administrator responsible for free copies | ||
34 | KUENDGRD | KUENDGRD | KUENDGRD | CHAR | 3 | 0 | Reason for end of delivery | * | |
35 | XLOGO | XLOGO | XFELD | CHAR | 1 | 0 | Print Logo | ||
36 | KONDA | KONDA | KONDA | CHAR | 2 | 0 | Price Group (Customer) | * | |
37 | KDGRP | KDGRP | KDGRP | CHAR | 2 | 0 | Customer group | * | |
38 | PLTYP | PLTYP | PLTYP | CHAR | 2 | 0 | Price list type | * | |
39 | PERFK | PERFK | WFCID | CHAR | 2 | 0 | Invoice dates (calendar identification) | * | |
40 | PRBAS | PRBAS_ISP | PRBAS_ISP | CHAR | 1 | 0 | Price Basis | ||
41 | PRBAS_VK | PRBAS_VK | PRBAS_ISP | CHAR | 1 | 0 | Price Basis for Shipping Costs | ||
42 | XSEPFKPOS | XSEPFKPOS | XFELD | CHAR | 1 | 0 | Separate billing document for order item | ||
43 | GPNR_RG | GPNR_RG | GPNR | CHAR | 10 | 0 | IS-M: Payer Business Partner | * | |
44 | BANKS | BANKS | LAND1 | CHAR | 3 | 0 | Bank country key | * | |
45 | BANKL | BANKK | BANKK | CHAR | 15 | 0 | Bank Keys | ||
46 | BANKN | BANKN | BANKN | CHAR | 18 | 0 | Bank account number | ||
47 | BKONT | BKONT | BKONT | CHAR | 2 | 0 | Bank Control Key | ||
48 | BVTYP | BVTYP | BVTYP | CHAR | 4 | 0 | Partner bank type | ||
49 | XEZER | XEZER | XFELD | CHAR | 1 | 0 | Indicator: Is there collection authorization ? | ||
50 | ZTERM | DZTERM | ZTERM | CHAR | 4 | 0 | Terms of payment key | ||
51 | GPNR_RE | GPNR_RE | GPNR | CHAR | 10 | 0 | IS-M: Business Partner - Bill-To Party | * | |
52 | BEZPER | BEZPER | BEZPER | CHAR | 5 | 0 | Service Type | * | |
53 | BZPERF | BEZPERFAKT | BEZPER | CHAR | 5 | 0 | IS-M: Service Type for Billing | * | |
54 | ETMENGE | ETMENGE_N | ETMENGE_N | NUMC | 10 | 0 | IS-M: Numerical Schedule Line Quantity | ||
55 | PRSBINDDAT | PRSBINDDAT | DATUM | DATS | 8 | 0 | To-date for price fixing | ||
56 | FKDATVSYST | FKDATVSYST | DATUM | DATS | 8 | 0 | 'Billed to' Date in Legacy System | ||
57 | .INCLUDE | 0 | 0 | IS-PSD: Data Transfer - Specific Subscription Data | |||||
58 | XIMMATRIK | XIMMATRIK | XFELD | CHAR | 1 | 0 | Indicator: Proof of matriculation provided | ||
59 | IMMATDAT | IMMATDAT | DATUM | DATS | 8 | 0 | Matriculation Certificate Valid To | ||
60 | RECHBEGINN | RECHBEGINN | DATUM | DATS | 8 | 0 | Billing From | ||
61 | RECHENDE | RECHENDE | DATUM | DATS | 8 | 0 | Billing To | ||
62 | KUENDEING | KUENDEING | DATUM | DATS | 8 | 0 | Date of Receipt of Termination | ||
63 | LIEFENDEG | LIEFENDEG | DATUM | DATS | 8 | 0 | Requested end of delivery | ||
64 | LIEFENDEI | LIEFENDEI | DATUM | DATS | 8 | 0 | Actual end of delivery | ||
65 | WERBEART | WERBEART | WERBEART | CHAR | 4 | 0 | Sales Source | * | |
66 | WERBEAKT | WERBEAKT | WERBEAKT | CHAR | 8 | 0 | Sales Promotion | * | |
67 | MINDBEZUG | MINDBEZUGN | NUM2 | NUMC | 2 | 0 | IS-M: Minimum length of subscription, numerical | ||
68 | MINDBEZEIN | MINDBEZEIN | MEINS | UNIT | 3 | 0 | Time Unit for Minimum Length of Subscription | * | |
69 | LIEFUNTMAX | LIEFUNTMXN | NUMC2 | NUMC | 2 | 0 | IS-M: Maximum suspension of delivery - numerical | ||
70 | LIEFUMXEIN | LIEFUMXEIN | MEINS | UNIT | 3 | 0 | Time unit for maximum delivery suspension | * | |
71 | GPVERM | GPVERM | GPNR | CHAR | 10 | 0 | Business Partner Sales Agent | * | |
72 | VSGVERM | VSGPROV | GPNR | CHAR | 10 | 0 | Service company for commission payee | * | |
73 | MATNRWERB | MATNR_SAPR | MATNR_ISP | CHAR | 18 | 0 | IS-M: Material number for gift | * | |
74 | WERBTRAEG | WERBTRAEG | WERBTRAEG | CHAR | 10 | 0 | Advertising Medium | * | |
75 | PROVFDAT | PROVFDAT | DATUM | DATS | 8 | 0 | Commission due date | ||
76 | FKPER | FKPER | FKPER | CHAR | 2 | 0 | Billing Frequency | * | |
77 | ZAHLW | JZAHLW | JZAHLW | CHAR | 1 | 0 | Billing method | ||
78 | ERLDATWERB | ERLDATWERB | DATUM | DATS | 8 | 0 | Date Advertising Bonus Sent | ||
79 | XPROVVSYST | XPROVVSYST | XFELD | CHAR | 1 | 0 | Commission settlement for subscription in legacy system | ||
80 | ANRED | JANRED | JANRED | CHAR | 2 | 0 | IS-M: Form-of-Address Key | * | |
81 | NAME1 | NAME1_ISP | NAME | CHAR | 35 | 0 | IS-M: Business Partner Name | ||
82 | NAME2 | NAME2_ISP | NAME | CHAR | 35 | 0 | IS-M: First Name of Business Partner | ||
83 | NAME3 | NAME3_ISP | NAME | CHAR | 35 | 0 | IS-M: Further Name Field for Business Partner | ||
84 | NAME4 | NAME4_ISP | NAME | CHAR | 35 | 0 | IS-M: Further Name Field for Business Partner | ||
85 | TITEL | TITEL_ISP | TITEL | CHAR | 15 | 0 | IS-M: Title | * | |
86 | NAMZU | NAMZU_ISP | TITEL | CHAR | 15 | 0 | IS-M: Name Affix | * | |
87 | VORSW | VORSW_ISP | TITEL | CHAR | 15 | 0 | IS-M: Name Prefix | * | |
88 | .INCLUDE | 0 | 0 | Core address data | |||||
89 | PSTLZ | PLZ_ISP | PSTLZ | CHAR | 10 | 0 | IS-M: Postal Code | ||
90 | PSTLZ_ADDON | PSTLZ_ADDON | CHAR4 | CHAR | 4 | 0 | IS-M: Extension to 5-Character ZIP Code | ||
91 | ORT01 | ORT01_ISP | TEXT35 | CHAR | 35 | 0 | IS-M: City | ||
92 | ORT02 | ORT02_ISP | TEXT35 | CHAR | 35 | 0 | IS-M: City District | ||
93 | PSTL2 | PLZPF | PSTLZ | CHAR | 10 | 0 | IS-M: Postal Code for PO Box | ||
94 | PSTL2_ADDON | PSTL2_ADDON | CHAR4 | CHAR | 4 | 0 | IS-M: Extension to 5-Character ZIP Code (PO Box) | ||
95 | PSTL3 | PSTL3 | PSTLZ | CHAR | 10 | 0 | IS-M: Company Postal Code | ||
96 | PSTL3_ADDON | PSTL3_ADDON | CHAR4 | CHAR | 4 | 0 | IS-M: Extension to 5-Character ZIP Code (Company) | ||
97 | PFACH | PFACH_ISP | PFACH_ISP | CHAR | 10 | 0 | IS-M: Post Office Box | ||
98 | ORTPF | ORTPF | TEXT35 | CHAR | 35 | 0 | IS-M: City for PO Box | ||
99 | STRAS | STRAS_ISP | TEXT35 | CHAR | 35 | 0 | IS-M: Street Name | ||
100 | HAUSN | HSNMR1 | HAUSNUMMER | CHAR | 10 | 0 | IS-M: House Number | ||
101 | HSNMR2 | HSNMR2 | CHAR8 | CHAR | 8 | 0 | IS-M: House Number Affix | ||
102 | ADRZUS2 | ADRZUS2 | ADRZUS | CHAR | 6 | 0 | Classification Using a Further Address Affix | ||
103 | STOCK | STOCK | STOCK | CHAR | 6 | 0 | Floor | ||
104 | LAND1 | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | T005 | |
105 | PREDIRECTIONAL | DIRECTIONAL | DIRECTIONAL | CHAR | 10 | 0 | IS-M: Direction for Street | TJS41 | |
106 | POSTDIRECTIONAL | DIRECTIONAL | DIRECTIONAL | CHAR | 10 | 0 | IS-M: Direction for Street | TJS41 | |
107 | ADDRSECABBREV | ADDRSECABBREV | ADDRSECABBREV | CHAR | 4 | 0 | IS-M: Secondary Address Text | TJS43 | |
108 | ADDRSECNUMBER | ADDRSECNUMBER | ADDRSECNUMBER | CHAR | 8 | 0 | IS-M: Secondary Address Number | ||
109 | STREET2 | STREET2_ISM | TEXT35 | CHAR | 35 | 0 | IS-M: Second street line | ||
110 | .INCLUDE | 0 | 0 | Include Structure for Alias (Alias Name) | |||||
111 | ALIASNAME | ALIASNAME | TEXT50 | CHAR | 50 | 0 | IS-M: Alias Text (Street Name + Suffix) | ||
112 | SORTL | SORTL | CHAR10 | CHAR | 10 | 0 | Sort field | ||
113 | SPRAS | SPRAS | SPRAS | LANG | 1 | 0 | Language Key | * | |
114 | REGIO | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | * | |
115 | TELFP | TELFP | TEXT16 | CHAR | 16 | 0 | IS-M: Home Phone Number | ||
116 | TELFD | TELFD | TEXT16 | CHAR | 16 | 0 | IS-M: Telephone Number at Work | ||
117 | TELFX | TELFX | TEXT31 | CHAR | 31 | 0 | Fax Number | ||
118 | TELTX | TELTX | TEXT30 | CHAR | 30 | 0 | Teletex number | ||
119 | TELX1 | TELX1 | TEXT30 | CHAR | 30 | 0 | Telex number | ||
120 | STDKO | STDKO_D | CHAR1 | CHAR | 1 | 0 | Default communications service | ||
121 | MAILN | JMAILN | SO_OBJ_NAM | CHAR | 12 | 0 | IS-M: Mail Address | ||
122 | ZLSCH | DZLSCH | ZLSCH | CHAR | 1 | 0 | Payment method | * | |
123 | VKBURZUS | VKBURZUS | VKBUR | CHAR | 4 | 0 | Sales office responsible | * | |
124 | KOSTL_L | KOSTL_L | KOSTL | CHAR | 10 | 0 | Debit Cost Center | * |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | RJKJK01 | ADDRSECABBREV | TJS43 | ADDRSECABBREV | KEY | 1 | CN |
2 | RJKJK01 | BEZUGSTYP | JDTBEZTYP | BEZTYP | |||
3 | RJKJK01 | LAND1 | T005 | LAND1 | REF | C | CN |
4 | RJKJK01 | POSTDIRECTIONAL | TJS41 | DIRECTIONAL | KEY | 1 | CN |
5 | RJKJK01 | PREDIRECTIONAL | TJS41 | DIRECTIONAL | KEY | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |