SAP Table JKACCOUNT
IS-M/SD: Liability Account for Subscription
JKACCOUNT (IS-M/SD: Liability Account for Subscription) 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 JKACCOUNT to other SAP tables.
JKACCOUNT table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||
| VBELN | IS-M/SD: Publishing Sales Order | AVNR | JKAK | CHAR | 10 | 0 | ||||||||
| POSNR_UR | Original Item in Publishing Sales Order | APNR_UR | JKAP | NUMC | 6 | 0 | ||||||||
| CYCLENR | IS-M/SD: Billing Cycle Number | CYCLENR | NUMC | 3 | 0 | |||||||||
| ZBETR | IS-M/SD: Payment Amount in Local Currency | BETRZ | CURR | 13 | 2 | |||||||||
| AMOBETR | IS-M/SD: Amortization Amount | AMOBETR | CURR | 13 | 2 | |||||||||
| VAUSGB_F | IS-M/SD: First Issue Delivered in Billing Cycle | VAUSGB_F | JDTVAUSGB | CHAR | 10 | 0 | ||||||||
| VAUSGB_L | IS-M/SD: Last Issue Delivered in Billing Cycle | VAUSGB_L | JDTVAUSGB | CHAR | 10 | 0 | ||||||||
| VAUSGB_LBI | IS-M/SD: Last issue delivered before billing doc.transfer | VAUSGB_LBI | JDTVAUSGB | CHAR | 10 | 0 | ||||||||
| XCYCLE_FIN | IS-M/SD: Amortization Complete for Liability Account | XCYCLE_FIN | CHAR | 1 | 0 |
Possible values
|
||||||||
| EXPDATE | IS-M/SD: Expiration Date of Subscription | EXP_DATE | DATS | 8 | 0 | |||||||||
| DELIV_BILL | Number of Deliveries Billed in Billing Cycle | DELIV_BILL | NUMC | 3 | 0 | |||||||||
| DELIV_AMO | Number of Amortized Deliveries in Billing Cycle | DELIV_AMO | NUMC | 3 | 0 | |||||||||
| TFBETR | IS-M/SD: Transfer amount | TFBETR | CURR | 13 | 2 | |||||||||
| WAERK | SD Document Currency | WAERK | TCURC | CUKY | 5 | 0 | ||||||||
| KURST | Exchange Rate Type | KURST | TCURV | CHAR | 4 | 0 | ||||||||
| TRANS_DATE | Translation Date | WWERT_D | DATS | 8 | 0 | |||||||||
| UKURS | Exchange Rate | UKURS_CURR | DEC | 9 | 5 | |||||||||
| XINVOICE | IS-M/SD: Billing and Transfer Performed for Cycle | XINVOICE | CHAR | 1 | 0 |
Possible values
|
||||||||
| XGOLIVE | IS-M/SD: Cycle from Data Transfer | XGOLIVE | CHAR | 1 | 0 |
Possible values
|
||||||||
| XFKRUECK | IS-M: Retroactive Billing of Period Already Billed | XFKRUECK | CHAR | 1 | 0 |
Possible values
|
||||||||
| POSNR_NP_LAST | Standard Item Last Amortized Within Original Item | POSNR_NP_LAST_AMO | NUMC | 6 | 0 | |||||||||
| XADVANCE_BILL | IS-M/SD: Perform Billing in Advance | XADVANCE_BILL | CHAR | 1 | 0 |
Possible values
|
||||||||
| XAMO_ARCHIVED | IS-M/SD: Amortization Data on Cycle Activated | XAMO_ARCHIVED | CHAR | 1 | 0 |
Possible values
|
||||||||
| DIFFBETR | IS-M/SD: Diff. Amount Due to Retroactive Billing/Recalc. | ISM_DIFFBETR | CURR | 13 | 2 | |||||||||
JKACCOUNT foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| JKACCOUNT | KURST | JKACCOUNT | MANDT | TCURV | Exchange rate types for currency translation | MANDT |
| JKACCOUNT | KURST | JKACCOUNT | KURST | TCURV | Exchange rate types for currency translation | KURST |
| JKACCOUNT | MANDT | JKACCOUNT | MANDT | T000 | Clients | MANDT |
| JKACCOUNT | POSNR_UR | JKACCOUNT | MANDT | JKAP | Sales Order - Item Data | MANDT |
| JKACCOUNT | POSNR_UR | JKACCOUNT | VBELN | JKAP | Sales Order - Item Data | VBELN |
| JKACCOUNT | POSNR_UR | JKACCOUNT | POSNR_UR | JKAP | Sales Order - Item Data | POSNR |
| JKACCOUNT | VAUSGB_F | JKACCOUNT | MANDT | JDTVAUSGB | IS-M/SD: Issues | MANDT |
| JKACCOUNT | VAUSGB_F | JKACCOUNT | VAUSGB_F | JDTVAUSGB | IS-M/SD: Issues | VAUSGB |
| JKACCOUNT | VAUSGB_L | JKACCOUNT | MANDT | JDTVAUSGB | IS-M/SD: Issues | MANDT |
| JKACCOUNT | VAUSGB_L | JKACCOUNT | VAUSGB_L | JDTVAUSGB | IS-M/SD: Issues | VAUSGB |
| JKACCOUNT | VAUSGB_LBI | JKACCOUNT | MANDT | JDTVAUSGB | IS-M/SD: Issues | MANDT |
| JKACCOUNT | VAUSGB_LBI | JKACCOUNT | VAUSGB_LBI | JDTVAUSGB | IS-M/SD: Issues | VAUSGB |
| JKACCOUNT | VBELN | JKACCOUNT | VBELN | JKAK | Sales Order Header Data | VBELN |
| JKACCOUNT | VBELN | JKACCOUNT | MANDT | JKAK | Sales Order Header Data | MANDT |
| JKACCOUNT | WAERK | JKACCOUNT | MANDT | TCURC | Currency Codes | MANDT |
| JKACCOUNT | WAERK | JKACCOUNT | WAERK | TCURC | Currency Codes | WAERS |
