JCBKANKEY SAP (Canonical Key for Circulation Book) Structure details
Description: Canonical Key for Circulation Book
Structure field list including key, data, relationships and ABAP select examples
JCBKANKEY is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Canonical Key for Circulation Book" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_JCBKANKEY TYPE JCBKANKEY.
The JCBKANKEY table consists of various fields, each holding specific information or linking keys about Canonical Key for Circulation Book data available in SAP. These include ISSUE (Issue), PUBL_ORDER (Order Publication), EDITION_ORDER (Order-related edition), DELIV_RETRN_DATE (Shipping date or return date of delivered/returned issues).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
SAP JCBKANKEY structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
CIRC_ORIGIN | Technical data origin of circulation | J_CIRC_ORIGIN | CHAR | 1 | J_CIRC_ORIGIN | ||||
ISSUE | Issue | VAUSGB | CHAR | 10 | Assigned to domain | ALPHA | VAUSGB | JD8 | MJD4 |
PUBL_ORDER | Order Publication | DRERZAUFTR | CHAR | 8 | Assigned to domain | ALPHA | DRERZ | JD1 | |
EDITION_ORDER | Order-related edition | PVAAUFTR | CHAR | 8 | Assigned to domain | ALPHA | PVA | JD2 | |
DELIV_RETRN_DATE | Shipping date or return date of delivered/returned issues | VERSREMIDAT | DATS | 8 | DATUM | ||||
DLVRYDOCTYPE | Type of Delivery | LFNGART | CHAR | 1 | LFNGART | ||||
AUDITCAT | Circulation Audit Report Category ID | IVWKN | CHAR | 8 | Assigned to domain | IVWKN | |||
NRMLCOUNTRY | Normal delivery country | LAND1_ISP | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
CUKY_SDOC | SD Document Currency | WAERK | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
MIXTYPE | Mix Type | BEZUGSTYP_JE_PVA | CHAR | 2 | JDTBEZTYP | BEZUGSTYP_JE_PVA | JD3 | MJD7 | |
BILLFREQ | Billing Frequency | FKPER | CHAR | 2 | Assigned to domain | FKPER | JFKPER | ||
PRICEPER | IS-M: Price Frequency | PRSPER | CHAR | 2 | Assigned to domain | PRSPER | JPRSPER | ||
PRCGRPCUST | Price group (customer) | KONDA | CHAR | 2 | Assigned to domain | KONDA | VKA | ||
RATE_CODE | IS-M/SD: Rate Code | RATE_CODE | CHAR | 4 | Assigned to domain | RATE_CODE | JKM | ||
CT_SPRICE | Condition Type for Purchase Price | CTYPE_SPRICE | CHAR | 4 | Assigned to domain | KSCHL | |||
SUBS_PRICE | Purchase price | JBEZPRS | CHAR | 13 | CHAR13 | ||||
TAX_CODE | Tax on sales/purchases code | MWSKZ | CHAR | 2 | Assigned to domain | MWSKZ | |||
CUKY_SPRICE | Currency key for purchase price | JCURRBEZPRS | CUKY | 5 | Assigned to domain | WAERS | |||
CUST_GROUP | Customer group | KDGRP | CHAR | 2 | Assigned to domain | KDGRP | VKD | ||
SALES_ORG | Sales Organization | VKORG | CHAR | 4 | Assigned to domain | VKORG | VKO | C_VKORG | |
DISTR_CHAN | Distribution Channel | VTWEG | CHAR | 2 | Assigned to domain | VTWEG | VTW | C_VTWEG | |
PYMT_METH | Payment Method | DZLSCH | CHAR | 1 | Assigned to domain | ZLSCH | |||
SDOC_TYPE | IS-M/SD: Sales Document Types | AUART_ISP | CHAR | 4 | Assigned to domain | AUART_ISP | JAD | ||
ITEM_TYPE | Internal Item Type for Sales Order | POART_ISP | CHAR | 2 | Assigned to domain | POART_ISP | JAP | ||
DELIVTYPE_ORDER | Delivery Type for Order Delivery Viability Set | LFARTAUFTR | CHAR | 2 | Assigned to domain | LIEFERART | ALT | ||
DELIVTYPE_LOG | Logistical delivery type | LFARTLOG | CHAR | 2 | Assigned to domain | LIEFERART | ISM_HELP_FOR_LOGDELIVTYPE | ||
ACT_COUNTRY | Current country being supplied | LANDE_ISP | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
POSTAL_CODE | IS-M: Postal Code | PLZ_ISP | CHAR | 10 | PSTLZ | ||||
POSTAL_ZONE | Postal code evaluation area | JPLZAWGEB | CHAR | 6 | Assigned to domain | ALPHA | JPLZAWGEB | ||
PLANT | Plant | JWERK | CHAR | 4 | Assigned to domain | WERKS | WRK | ||
CFIELD1 | Field 1 for definition by customer (max. 10 characters) | JICFIELD1 | CHAR | 10 | CHAR10 | ||||
CFIELD2 | Customer field 2 (max. 10 characters) | JICFIELD2 | CHAR | 10 | CHAR10 | ||||
CFIELD3 | Customer field 3 (max. 18 characters) | JICFIELD3 | CHAR | 18 | CHAR18 | ||||
CFIELD4 | Customer Field 4 (Max. 18 Characters) | JICFIELD4 | CHAR | 18 | CHAR18 | ||||
CFIELD5 | Customer Field 5 (Max. 18 Characters) | JICFIELD5 | CHAR | 18 | CHAR18 | ||||
CFIELD6 | Customer Field 5 (Max. 18 Characters) | JICFIELD5 | CHAR | 18 | CHAR18 | ||||
MEDIAISSUE | Media Issue | ISMMATNR_ISSUE | CHAR | 18 | Assigned to domain | MATN1 | MATNR | JP_ISS | MJP_MEDISS |
MEDPRODFAM_SOLD | Media product family sold | MEDIAPRODUCTFAM_SOLD | CHAR | 18 | Assigned to domain | MATN1 | MATNR | ||
MEDIAPROD_SOLD | Media product sold | MEDIAPRODUCT_SOLD | CHAR | 18 | Assigned to domain | MATN1 | MATNR | ||
SDOC_TYPE_SD | Sales Document Type | AUART | CHAR | 4 | Assigned to domain | AUART | AUART | AAT | |
ITEM_TYPE_SD | Sales document item category | PSTYV | CHAR | 4 | Assigned to domain | PSTYV | |||
KREISG_SCH | IS-M: District municipality key of ship-to party | KGS_ORDER | CHAR | 15 | Assigned to domain | ALPHA | KREISG_SCH | ||
REGIO | STATE (State, Province, County) | REGIO | CHAR | 3 | Assigned to domain | REGIO | |||
COUNC | County Code | COUNC | CHAR | 3 | Assigned to domain | COUNC | |||
POSTEINORT | IS-M: City Number (Unique) | JALORT | CHAR | 8 | Assigned to domain | ALPHA | ALORT | JSO | |
NDM_ABC_ZONE | Newspaper Designated Market Zone for ABC | NDM_ABC_ZONE | CHAR | 1 | NDM_ABC_ZONE | ||||
TRAD_ABC_ZONE | Zone According to CTZ, RTZ, OTZ for ABC | TRAD_ABC_ZONE | CHAR | 1 | TRAD_ABC_ZONE | ||||
BEZPER | Service Type | BEZPER | CHAR | 5 | Assigned to domain | BEZPER | JD4 | ||
WEEKDAY | IS-M: Number of Weekday | ISM_WEEKDAY | NUMC | 1 | TJPWEEKDAY | ISM_WEEKDAY | |||
WERBEAKT | Sales Promotion | WERBEAKT | CHAR | 8 | Assigned to domain | ALPHA | WERBEAKT | JWT | MJW1 |
Key field | Non-key field |
How do I retrieve data from SAP structure JCBKANKEY using ABAP code?
As JCBKANKEY is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on JCBKANKEY as there is no data to select.How to access SAP table JCBKANKEY
Within an ECC or HANA version of SAP you can also view further information about JCBKANKEY and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects