TJAK SAP (IS-M/SD: Sales Document Type) Table details
Dictionary Type: Table
Description: IS-M/SD: Sales Document Type
Description: IS-M/SD: Sales Document Type
Table field list including key, data, relationships and ABAP select examples
TJAK is a standard SAP Table which is used to store IS-M/SD: Sales Document Type data and is available within R/3 SAP systems depending on the version and release level.
The TJAK table consists of various fields, each holding specific information or linking keys about IS-M/SD: Sales Document Type data available in SAP. These include AUART (IS-M/SD: Sales Document Types), AUARTGRP (IS-M/SD: Sales document type grouping), KOPGR (Screen Sequence Group for Document Header & Item), FKART (IS-M: Billing/Settlement Type).. 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: C - Customising table, maintenance only by custDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)
Text table = TJAKT
SAP TJAK table 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 |
| MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
| AUART | IS-M/SD: Sales Document Types | AUART_ISP | CHAR | 4 | AUART_ISP | JAD | |||
| AUARTGRP | IS-M/SD: Sales document type grouping | JAUARTGRP | CHAR | 1 | JAUARTGRP | JKAUARTGRP | |||
| KOPGR | Screen Sequence Group for Document Header & Item | BIFGR_ISP | CHAR | 4 | TJHB | BIFGR_ISP | |||
| FKART | IS-M: Billing/Settlement Type | JFKART | CHAR | 4 | TJFK | JFKART | |||
| NUMKI | Number range for internal number assignment | NUMKI_ISP | CHAR | 2 | NUMKR | ||||
| NUMKE | Number range for external number assignment | NUMKE_ISP | CHAR | 2 | NUMKR | ||||
| INCPO | Increment of Purchase Order Item Number in Sales Document | INCPO_ISP | NUMC | 6 | NUM6 | ||||
| UEVOR | Default FCODE for first data screen | UEVOR_ISP | CHAR | 4 | UEVOR_ISP | ||||
| FAKSK | Block | FAKSP | CHAR | 2 | TVFS | FAKSP | |||
| TRVOG | Transaction Group for IS-M Order Processing | TRVOG_ISP | CHAR | 1 | TRVOG_ISP | ||||
| SPAPO | Division in sales order item comes from the material | SPAPO | CHAR | 1 | SPAPO | ||||
| SPAPR | Check division | SPAPR | CHAR | 1 | SPAPR | ||||
| TXN08 | Number of the standard text | TXN08 | CHAR | 8 | TXN08 | ||||
| FELDK | Field Selection Group for Header & Item | FAWGR_ISP | CHAR | 4 | TJHF | FAWGR_ISP | |||
| VBTYP | Sales document category, IS-M | VBTYP_ISP | CHAR | 1 | VBTYP_ISP | ||||
| TXTGR | Text determination procedure | TXTGR | CHAR | 2 | TTXG | TXTGR | |||
| KALVG | Document procedure (for determining pricing procedure) | KALVG | CHAR | 1 | TVKV | KALVG | |||
| KLIMP | Check credit limit | KLIMP | CHAR | 1 | KLIMP | ||||
| KALSM | Output determination procedure | KALSMB | CHAR | 6 | T683 | KALSM | |||
| KSCHL | Condition Type | KSCHL | CHAR | 4 | T685 | KSCHL | VKS | ||
| SPERR | Sales document block | SPEVB | CHAR | 1 | SPEVB | ||||
| XPVKANG | Check sales offer | XPVKANG | CHAR | 1 | XFELD | ||||
| XUPDPRVA | Update ad pre-print issues | XUPDPRVA | CHAR | 1 | XFELD | ||||
| XAUARTKORR | Correction sales document type | XAUARTKORR | CHAR | 1 | XFELD | ||||
| ERLDRERZ | Allowed Publications | ERLDRERZ | CHAR | 1 | ERLDRERZ | ||||
| EXEMPLART | IS-M: Copy Type | EXEMPLART | CHAR | 1 | EXEMPLART | ||||
| XGPRSE | Partner function social facility allowed as ordering party | XGPRSE | CHAR | 1 | XFELD | ||||
| XGPRVK | Partner function SD customer allowed as ordering party | XGPRVK | CHAR | 1 | XFELD | ||||
| XINTERN | IS-M: Internal Business Partner Indicator | XINTERN | CHAR | 1 | XFELD | ||||
| XGPREV | Partner function retailer allowed as ordering party | XGPREV | CHAR | 1 | XFELD | ||||
| XGPRVERLAG | Partner func.SD cust./ext.publ.allowed as ordering party | XGPRVERLAG | CHAR | 1 | XFELD | ||||
| XGPRALLG | Partner role general BP allowed as ordering party | XGPRALLG | CHAR | 1 | XFELD | ||||
| ETVAR | Schedule Line Maintenance Variant | ETVAR | CHAR | 1 | ETVAR | ||||
| PRSFD | IS-M: Order is subject to charge | XKSTPFLAUF | CHAR | 1 | XFELD | ||||
| STGVB | IS-M: Statistics group for sales documents | JSTGVB | CHAR | 2 | TJKMC1 | ALPHA | JSTGVB | ||
| XKOPFEINST | IS-M: Access Order from Basic Header Data | XKOPFEINST | CHAR | 1 | XFELD | ||||
| XPUEBEINST | IS-M: Access order via item overview | XPUEBEINST | CHAR | 1 | XFELD | ||||
| XFKBASAUFT | IS-M: Billing based on order | XFKBASAUFT | CHAR | 1 | XFELD | ||||
| XFKBASLIEF | IS-M: Billing based on delivery | XFKBASLIEF | CHAR | 1 | XFELD | ||||
| AUART_REKL | Sales Document Type for Complaint | AUART_REKL | CHAR | 4 | TJAK | AUART_ISP | JA7 | ||
| AUART_NF | IS-M: Subsequent Sales Document Type for Offers | AUART_NF | CHAR | 4 | TJAK | AUART_ISP | |||
| AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
| AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
| XWBZABO | IS-M: WBZ subscription | XWBZABO | CHAR | 1 | XFELD | ||||
| XRENEWAL | IS-M/SD: Order extended by renewal offer | XRENEWAL | CHAR | 1 | XFELD | ||||
| AMORTN | IS-M/SD: Use of Liability Account in Order | AMORTN | CHAR | 1 | AMORTN | ||||
| AUART_OF | IS-M/SD: Sales Document Type for Renewal Offer | AUART_OF | CHAR | 4 | TJAK | AUART_ISP | |||
| XCCARD | IS-M: Payment cards allowed in order | XJCCARD | CHAR | 1 | XFELD | ||||
| FKART_TRANSFER | IS-M/SD: Billing Type for Liability Account Transfer | FKART_TRANSFER | CHAR | 4 | TJFK | JFKART | |||
| TRANSFERHR | IS-M/SD: Transfer Billing Documents to Human Resources | TRANSFERHR | CHAR | 1 | TRANSFERHR | ||||
| XRETRO_BILL | IS-M/SD: Retroactive Billing Possible in Renewals | XRETRO_BILL | CHAR | 1 | XFELD |
| Key field | Non-key field |
How do I retrieve data from SAP table TJAK using ABAP code
The following ABAP code Example will allow you to do a basic selection on TJAK to SELECT all data from the tableDATA: WA_TJAK TYPE TJAK.
SELECT SINGLE *
FROM TJAK
INTO CORRESPONDING FIELDS OF WA_TJAK
WHERE...
How to access SAP table TJAK
Within an ECC or HANA version of SAP you can also view further information about TJAK 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