SAP ABAP Table FKKOPK (G/L Account Items in Open Item Account Document)
Hierarchy
☛
FI-CA (Software Component) FI-CA
⤷ FI-CA (Application Component) Contract Accounts Receivable and Payable
⤷ FKKB (Package) Contract A/R & A/P: Central Objects
⤷ FI-CA (Application Component) Contract Accounts Receivable and Payable
⤷ FKKB (Package) Contract A/R & A/P: Central Objects
Basic Data
Table Category | INTTAB | Structure |
Structure | FKKOPK | Table Relationship Diagram |
Short Description | G/L Account Items in Open Item Account Document |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
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 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
2 | OPBEL | OPBEL_KK | OPBEL_KK | CHAR | 12 | 0 | Number of Contract Accts Rec. & Payable Doc. | * | |
3 | OPUPK | OPUPK_KK | OPUPK_KK | NUMC | 4 | 0 | Item number in contract account document | ||
4 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
5 | HKONT | HKONT_KK | SAKNR | CHAR | 10 | 0 | General ledger account | SKA1 | |
6 | GSBER | GSBER | GSBER | CHAR | 4 | 0 | Business Area | TGSB | |
7 | BUPLA | BUPLA | J_1BBRANCH | CHAR | 4 | 0 | Business Place | J_1BBRANCH | |
8 | SEGMENT | SEGMT_KK | FB_SEGMENT | CHAR | 10 | 0 | Segment for Segmental Reporting | FAGL_SEGM | |
9 | PRCTR | PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | * | |
10 | KOSTL | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
11 | KDAUF | KDAUF | VBELN | CHAR | 10 | 0 | Sales Order Number | * | |
12 | KDPOS | KDPOS | NUM06 | NUMC | 6 | 0 | Item number in Sales Order | ||
13 | KDEIN | KDEIN | NUM04 | NUMC | 4 | 0 | Delivery schedule for sales order | ||
14 | PS_PSP_PNR | PS_PSP_PNR | PS_POSNR | NUMC | 8 | 0 | Work Breakdown Structure Element (WBS Element) | * | |
15 | PAOBJNR | RKEOBJNR | RKEOBJNR | NUMC | 10 | 0 | Profitability Segment Number (CO-PA) | ||
16 | PASUBNR | RKESUBNR | RKESUBNR | NUMC | 4 | 0 | Profitability Segment Changes (CO-PA) | ||
17 | FDLEV | FDLEV_KK | FDLEV | CHAR | 2 | 0 | Planning level | T036 | |
18 | VALUT | VALUT | DATUM | DATS | 8 | 0 | Fixed Value Date | ||
19 | KURSF | KURSF_KK | KURSF | DEC | 9 | 5 | Exchange rate | ||
20 | BETRH | BETRH_KK | WRTV7 | CURR | 13 | 2 | Amount In Local Currency With +/- Signs | ||
21 | BETRW | BETRW_KK | WRTV7 | CURR | 13 | 2 | Amount in Transaction Currency with +/- Sign | ||
22 | BETR2 | BETR2_KK | WRTV7 | CURR | 13 | 2 | Amount in second parallel currency with +/- sign | ||
23 | BETR3 | BETR3_KK | WRTV7 | CURR | 13 | 2 | Amount in third parallel currency with +/- sign | ||
24 | WHGRP | WHGRP_KK | WHGRP_KK | NUMC | 3 | 0 | Repetition group | * | |
25 | STRKZ | STRKZ_KK | STRKZ_KK | CHAR | 2 | 0 | Tax Code for Other Taxes | TFK007F | |
26 | QSSEW | QSSEW_KK | QSSEW_KK | CHAR | 2 | 0 | Withholding Tax Supplement | * | |
27 | MWSKZ | MWSKZ | MWSKZ | CHAR | 2 | 0 | Tax on sales/purchases code | T007A | |
28 | MWSZKZ | MWSZKZ_KK | MWSKZ | CHAR | 2 | 0 | Supplementary Tax | * | |
29 | TXJCD | TXJCD | TXJCD | CHAR | 15 | 0 | Tax Jurisdiction | TTXJ | |
30 | TXJCO | TXJCO_KK | TXJCD | CHAR | 15 | 0 | Jurisdiction code (specified value) | TTXJ | |
31 | TXCNT | TXCNT_KK | NUM01 | NUMC | 1 | 0 | Level Counter for Multi-Level Taxes in Tax Jurisdiction | ||
32 | TXDAT | TXDAT_KK | DATUM | DATS | 8 | 0 | Decisive Date for Calculating Taxes | ||
33 | TXEXK | TXEXK_KK | CHAR16 | CHAR | 16 | 0 | Key for tax exception | ||
34 | SBASH | SBASH_KK | WRTV7 | CURR | 13 | 2 | Amount Subject to Tax in Local Currency (Tax Base Amount) | ||
35 | SBASW | SBASW_KK | WRTV7 | CURR | 13 | 2 | Amount Subject to Tax in Transaction Currency (Tax Base Amt) | ||
36 | KTOSL | KTOSL_KK | CHAR3 | CHAR | 3 | 0 | Transaction key for account determination | ||
37 | STPRZ | STPRZ_KK | STPRZ_KK | NUMC | 6 | 0 | Tax rate | ||
38 | KSCHL | KSCHL | KSCHL | CHAR | 4 | 0 | Condition Type | * | |
39 | AUFNR | AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | * | |
40 | XEIPH | XEIPH_KK | XFELD | CHAR | 1 | 0 | Create Line Item in General Ledger | ||
41 | VBUND | RASSC | RCOMP | CHAR | 6 | 0 | Company ID of trading partner | * | |
42 | KONTT | KONTT_KK | KONTT_KK | CHAR | 2 | 0 | Account Assignment Category | * | |
43 | KONTL | KONTL_KK | CHAR50 | CHAR | 50 | 0 | Acct assnmnt string for industry-specific account assngments | ||
44 | XINTB | XINTB_KK | XFELD | CHAR | 1 | 0 | Item Created by Posting Interface | ||
45 | EUROU | EUROU_KK | EUROU_KK | CHAR | 1 | 0 | Status of Euro Conversion | ||
46 | FIKEY | FIKEY_KK | FIKEY_KK | CHAR | 12 | 0 | Reconciliation Key for General Ledger | * | |
47 | XCOPA | XCOPA_KK | XFELD | CHAR | 1 | 0 | CO-PA update done directly | ||
48 | MENGE | MENGE_D | MENG13 | QUAN | 13 | 3 | Quantity | ||
49 | MEINS | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | T006 | |
50 | REGIO | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | * | |
51 | COUNC | COUNC | COUNC | CHAR | 3 | 0 | County Code | * | |
52 | GRICD | J_1AGICD_D | J_1AGICD2 | CHAR | 2 | 0 | Activity Code for Gross Income Tax | * | |
53 | GITYP | J_1ADTYP_D | J_1ADTYP | CHAR | 2 | 0 | Distribution Type for Employment Tax | * | |
54 | INTBU | INTBU_KK | INTBU_KK | CHAR | 1 | 0 | Reason for Automatic Creation of Posting | ||
55 | NEGBU | NEGBU_KK | NEGBU_KK | NUMC | 1 | 0 | Control Field for Negative Posting | ||
56 | PSWSL | PSWSL_KK | WAERS | CUKY | 5 | 0 | Update Currency for General Ledger Transaction Figures | * | |
57 | HZUON | HZUON_KK | ZUONR | CHAR | 18 | 0 | Assignment Number in G/L Document | ||
58 | SGTXT | SGTXT_KK | TEXT50 | CHAR | 50 | 0 | Item Text for G/L Document | ||
59 | ANLN1 | ANLN1 | ANLN1 | CHAR | 12 | 0 | Main Asset Number | * | |
60 | ANLN2 | ANLN2 | ANLN2 | CHAR | 4 | 0 | Asset Subnumber | * | |
61 | ANBWA | ANBWA | BWASL | CHAR | 3 | 0 | Asset Transaction Type | * | |
62 | BZDAT | BZDAT | DATUM | DATS | 8 | 0 | Asset Value Date | ||
63 | PSGRP | PSGRP_KK | CHAR4 | CHAR | 4 | 0 | Grouping Key for Document Items | ||
64 | INVGR | INVGR_KK | CHAR4 | CHAR | 4 | 0 | Grouping Key for Invoicing | ||
65 | SCTAX | SCTAX_KK | WRTV7 | CURR | 13 | 2 | Tax Portion in FI-CA Local Currency | ||
66 | .INCLUDE | 0 | 0 | FM Account Assignments for FI-CA Including Type | |||||
67 | FMTYP | FMTYP_KK | FMTYP_KK | CHAR | 2 | 0 | Update Method for FM - FI-CA Integration | ||
68 | .INCLUDE | 0 | 0 | Funds Management Account Assignments for FI-CA | |||||
69 | ORIGFIKRS | ORIGFIKRS_KK | FIKRS | CHAR | 4 | 0 | Original FM Area for FM Account Assignment | * | |
70 | FIPEX | FM_FIPEX | FM_FIPEX | CHAR | 24 | 0 | Commitment item | * | |
71 | FISTL | FISTL | FISTL | CHAR | 16 | 0 | Funds Center | * | |
72 | FONDS | BP_GEBER | BP_GEBER | CHAR | 10 | 0 | Fund | * | |
73 | FKBER | FKBER | FKBER | CHAR | 16 | 0 | Functional Area | * | |
74 | MEASURE | FM_MEASURE | FM_MEASURE | CHAR | 24 | 0 | Funded Program | * | |
75 | GRANT_NBR | GM_GRANT_NBR | GM_GRANT_NBR | CHAR | 20 | 0 | Grant | ||
76 | BUDGETYEAR | FM_START_OF_CHAIN | GJAHR | NUMC | 4 | 0 | Original Year for FM Account Assignment | ||
77 | BUDGET_PD | FM_BUDGET_PERIOD | FM_BUDGET_PERIOD | CHAR | 10 | 0 | FM: Budget Period | * | |
78 | .INCLUDE | 0 | 0 | Include for Funds Commitment (OPK) | |||||
79 | .INCLUDE | 0 | 0 | Include: OII for Utility Companies: IS-U | |||||
80 | .INCLUDE | 0 | 0 | Insurance Include for Offsetting Items | |||||
81 | .INCLUDE | 0 | 0 | ||||||
82 | .INCLUDE | 0 | 0 | Public Sector: Fields for General Ledger Items | |||||
83 | .INCLUDE | 0 | 0 | FI-CA Extended: Include G/L Items | |||||
84 | .INCLUDE | 0 | 0 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | FKKOPK | BUKRS | T001 | BUKRS | REF | C | CN |
2 | FKKOPK | BUPLA | J_1BBRANCH | BRANCH | |||
3 | FKKOPK | FDLEV | T036 | EBENE | REF | C | CN |
4 | FKKOPK | GSBER | TGSB | GSBER | REF | C | CN |
5 | FKKOPK | HKONT | SKA1 | SAKNR | REF | C | CN |
6 | FKKOPK | MEINS | T006 | MSEHI | C | CN | |
7 | FKKOPK | MWSKZ | T007A | MWSKZ | REF | C | CN |
8 | FKKOPK | SEGMENT | FAGL_SEGM | SEGMENT | |||
9 | FKKOPK | STRKZ | TFK007F | STRKZ | |||
10 | FKKOPK | TXJCD | TTXJ | TXJCD | 1 | CN | |
11 | FKKOPK | TXJCO | TTXJ | TXJCD |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |