SAP Table TJAK

IS-M/SD: Sales Document Type

TJAK (IS-M/SD: Sales Document Type) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link TJAK to other SAP tables.

TJAK table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
AUART IS-M/SD: Sales Document Types AUART_ISP CHAR 4 0
AUARTGRP IS-M/SD: Sales document type grouping JAUARTGRP CHAR 1 0
1 Subscription Order
2 Single Unit Sales Order
3 Reserve Order
4 Free Copy Delivery Order
5 Return Notification
6 Credit/Debit Memo Requirements
7 Charitable Transfer
8 Ad Pre-Print Order
9 Coupon Order
B Voucher Copy Order
C Coupon Confirmation
KOPGR Screen Sequence Group for Document Header & Item BIFGR_ISP TJHB CHAR 4 0
FKART IS-M: Billing/Settlement Type JFKART TJFK CHAR 4 0
NUMKI Number range for internal number assignment NUMKI_ISP CHAR 2 0
NUMKE Number range for external number assignment NUMKE_ISP CHAR 2 0
INCPO Increment of Purchase Order Item Number in Sales Document INCPO_ISP NUMC 6 0
UEVOR Default FCODE for first data screen UEVOR_ISP CHAR 4 0
PUE1 Overview screen
KKAU Basic header data
FAKSK Block FAKSP TVFS CHAR 2 0
TRVOG Transaction Group for IS-M Order Processing TRVOG_ISP CHAR 1 0
0 Subscription Order
1 Retail Order
2 Coupon Order
3 Transfer Distribution Order
4 Subscription Offer
5 Retail Offer
6 Currently not in use
7 Complaint
8 Return Notification
9 Commission Correction (curr.not in use)
A External Delivery Order
B Internal Order
C Coupon Confirmation
SPAPO Division in sales order item comes from the material SPAPO CHAR 1 0
NULL Division from order header is valid for all items
X Division in the item has been proposed from the mat.master
SPAPR Check division SPAPR CHAR 1 0
NULL No dialog
1 Dialog
2 Error
TXN08 Number of the standard text TXN08 CHAR 8 0
FELDK Field Selection Group for Header & Item FAWGR_ISP TJHF CHAR 4 0
VBTYP Sales document category, IS-M VBTYP_ISP CHAR 1 0
A Inquiry
B Offer
C Order
H Return
I Free Delivery
K Credit Memo Request
L Debit Memo Request
M Invoice
N Reverse Invoice
O Credit Memo
P Debit Memo
S Reverse Credit Memo
U Pro Forma Invoice
TXTGR Text determination procedure TXTGR TTXG CHAR 2 0
KALVG Document procedure (for determining pricing procedure) KALVG TVKV CHAR 1 0
KLIMP Check credit limit KLIMP CHAR 1 0
NULL No credit limit check
A Run simple credit limit check and warning message
B Rund simple redit limit check and error message
C Run simple credit limit check and delivery block
D Credit management: Automatic credit control
KALSM Output determination procedure KALSMB T683 CHAR 6 0
KSCHL Condition Type KSCHL T685 CHAR 4 0
SPERR Sales document block SPEVB CHAR 1 0
NULL No block
A Only automatic creation allowed, e.g. for rebate processing
X The sales document type is blocked
XPVKANG Check sales offer XPVKANG CHAR 1 0
X Yes
NULL No
XUPDPRVA Update ad pre-print issues XUPDPRVA CHAR 1 0
X Yes
NULL No
XAUARTKORR Correction sales document type XAUARTKORR CHAR 1 0
X Yes
NULL No
ERLDRERZ Allowed Publications ERLDRERZ CHAR 1 0
NULL No publications allowed
B Own and third-party publications allowed
E Own publications allowed
F Third-party publications allowed
EXEMPLART IS-M: Copy Type EXEMPLART CHAR 1 0
0 Customer copies
1 Promotional copies
2 Reserve copies
XGPRSE Partner function social facility allowed as ordering party XGPRSE CHAR 1 0
X Yes
NULL No
XGPRVK Partner function SD customer allowed as ordering party XGPRVK CHAR 1 0
X Yes
NULL No
XINTERN IS-M: Internal Business Partner Indicator XINTERN CHAR 1 0
X Yes
NULL No
XGPREV Partner function retailer allowed as ordering party XGPREV CHAR 1 0
X Yes
NULL No
XGPRVERLAG Partner func.SD cust./ext.publ.allowed as ordering party XGPRVERLAG CHAR 1 0
X Yes
NULL No
XGPRALLG Partner role general BP allowed as ordering party XGPRALLG CHAR 1 0
X Yes
NULL No
ETVAR Schedule Line Maintenance Variant ETVAR CHAR 1 0
1 Schedule line maintenance with item
2 Schedule line maintenance via fast entry screen
PRSFD IS-M: Order is subject to charge XKSTPFLAUF CHAR 1 0
X Yes
NULL No
STGVB IS-M: Statistics group for sales documents JSTGVB TJKMC1 CHAR 2 0
XKOPFEINST IS-M: Access Order from Basic Header Data XKOPFEINST CHAR 1 0
X Yes
NULL No
XPUEBEINST IS-M: Access order via item overview XPUEBEINST CHAR 1 0
X Yes
NULL No
XFKBASAUFT IS-M: Billing based on order XFKBASAUFT CHAR 1 0
X Yes
NULL No
XFKBASLIEF IS-M: Billing based on delivery XFKBASLIEF CHAR 1 0
X Yes
NULL No
AUART_REKL Sales Document Type for Complaint AUART_REKL TJAK CHAR 4 0
AUART_NF IS-M: Subsequent Sales Document Type for Offers AUART_NF TJAK CHAR 4 0
AENAM Name of Person Who Changed Object AENAM CHAR 12 0
AEDAT Changed On AEDAT DATS 8 0
XWBZABO IS-M: WBZ subscription XWBZABO CHAR 1 0
X Yes
NULL No
XRENEWAL IS-M/SD: Order extended by renewal offer XRENEWAL CHAR 1 0
X Yes
NULL No
AMORTN IS-M/SD: Use of Liability Account in Order AMORTN CHAR 1 0
NULL No liability account
A Manage liability account in money
B Manage liability account in deliveries
C Manage liability account in money w/o ref.to performance
AUART_OF IS-M/SD: Sales Document Type for Renewal Offer AUART_OF TJAK CHAR 4 0
XCCARD IS-M: Payment cards allowed in order XJCCARD CHAR 1 0
X Yes
NULL No
FKART_TRANSFER IS-M/SD: Billing Type for Liability Account Transfer FKART_TRANSFER TJFK CHAR 4 0
TRANSFERHR IS-M/SD: Transfer Billing Documents to Human Resources TRANSFERHR CHAR 1 0
NULL Financial Accounting
X Human Resources
XRETRO_BILL IS-M/SD: Retroactive Billing Possible in Renewals XRETRO_BILL CHAR 1 0
X Yes
NULL No

TJAK foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TJAK AUART_NF TJAK MANDT TJAK IS-M/SD: Sales Document Type MANDT
TJAK AUART_NF TJAK AUART_NF TJAK IS-M/SD: Sales Document Type AUART
TJAK AUART_OF TJAK AUART_OF TJAK IS-M/SD: Sales Document Type AUART
TJAK AUART_OF TJAK MANDT TJAK IS-M/SD: Sales Document Type MANDT
TJAK AUART_REKL TJAK MANDT TJAK IS-M/SD: Sales Document Type MANDT
TJAK AUART_REKL TJAK AUART_REKL TJAK IS-M/SD: Sales Document Type AUART
TJAK FAKSK TJAK MANDT TVFS Billing: Reasons for Blocking MANDT
TJAK FAKSK TJAK FAKSK TVFS Billing: Reasons for Blocking FAKSP
TJAK FELDK TJKTB OBJEKT_BCF TJHF IS-M/SD Sales Documents - Field Selection Groups OBJEKT
TJAK FELDK TJAK FELDK TJHF IS-M/SD Sales Documents - Field Selection Groups FAWGR
TJAK FELDK TJAK MANDT TJHF IS-M/SD Sales Documents - Field Selection Groups MANDT
TJAK FKART TJAK MANDT TJFK IS-M/SD: Billing Document Types MANDT
TJAK FKART TJAK FKART TJFK IS-M/SD: Billing Document Types FKART
TJAK FKART_TRANSFER TJAK FKART_TRANSFER TJFK IS-M/SD: Billing Document Types FKART
TJAK FKART_TRANSFER TJAK MANDT TJFK IS-M/SD: Billing Document Types MANDT
TJAK KALSM 'B' T683 Pricing procedures KVEWE
TJAK KALSM 'J0' T683 Pricing procedures KAPPL
TJAK KALSM TJAK KALSM T683 Pricing procedures KALSM
TJAK KALSM TJAK MANDT T683 Pricing procedures MANDT
TJAK KALVG TJAK MANDT TVKV Pricing Procedures: Transaction MANDT
TJAK KALVG TJAK KALVG TVKV Pricing Procedures: Transaction KALVG
TJAK KOPGR TJAK MANDT TJHB IS-M/SD Sales Documents - Screen Sequence Groups MANDT
TJAK KOPGR TJKTB OBJEKT_BCF TJHB IS-M/SD Sales Documents - Screen Sequence Groups OBJEKT
TJAK KOPGR TJAK KOPGR TJHB IS-M/SD Sales Documents - Screen Sequence Groups BIFGR
TJAK KSCHL 'J0' T685 Conditions: Types KAPPL
TJAK KSCHL TJAK KSCHL T685 Conditions: Types KSCHL
TJAK KSCHL TJAK MANDT T685 Conditions: Types MANDT
TJAK KSCHL 'B' T685 Conditions: Types KVEWE
TJAK MANDT TJAK MANDT T000 Clients MANDT
TJAK STGVB TJAK MANDT TJKMC1 IS-M/SD: Stats Groups for Sales Docs (Doc.Type, Item Type) MANDT
TJAK STGVB TJAK STGVB TJKMC1 IS-M/SD: Stats Groups for Sales Docs (Doc.Type, Item Type) STGVB
TJAK TXTGR TJKTB OBJEKT_BCF TTXG Text Processing: Text ID Groups TDOBJECT
TJAK TXTGR TJAK TXTGR TTXG Text Processing: Text ID Groups TXTGR
TJAK TXTGR TJAK MANDT TTXG Text Processing: Text ID Groups MANDT