Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Common Table For Char of accounts and company code

Former Member
0 Kudos
431

Hi Experts,

can any one give a SAP Database table name wihch has both cadr of accounts (KTOPL : Char of Accounts ) and Compnay code (BUKRS) as it fields.

Regards

Dharmaraju

1 ACCEPTED SOLUTION

Former Member
0 Kudos
167

Hi Dharmaraju,

I did the following to find the answer to your question: looking into table DD03L, entering your two fields in FIELDNAME and selected (via Excel) all tables, that occure twice in the result.

If the result is too big, just select the tables that have one of the fields as key (KEYFLAG = 'X', also with help of Excel).

TABNAME Tabledescription

BIW_ASS_AF Interface FI-AA <-> BW: Provider Struct. f. IO 0ASSET_AFAB

DTFIAP_3 Data Transfer: Customer Items to BW (New)

DTFIAR_3 Data Transfer: Customer Items to BW (New)

FLQACC_ACT Liquidity Calculation - Other Actual Accounts

FLQACC_BURNED Liquidity Calculation - Other Accounts

FLQACC_INFO Liquidity Calculation - Accounts with Assignment Information

FLQACC_INFO_APP Liquidity Calculation - Accounts with Assignment Information

J_1ICOMP Additional company data

J_1IEWTHKONT Table for for TDS provisions Accounts / Loss Accounts

RECP_OI_DOC_CA_COMPCODE Company Code Data

RECP_SENDER_C Sender (Company Code Data)

T001 Company Codes

T038 Cash Management: Grouping Structure

T882 Company Code/Ledger Assignment

Best Regards

Manfred

(I think you know how to extract the Data from SE16 to Excel)

4 REPLIES 4

Former Member
0 Kudos
168

Hi Dharmaraju,

I did the following to find the answer to your question: looking into table DD03L, entering your two fields in FIELDNAME and selected (via Excel) all tables, that occure twice in the result.

If the result is too big, just select the tables that have one of the fields as key (KEYFLAG = 'X', also with help of Excel).

TABNAME Tabledescription

BIW_ASS_AF Interface FI-AA <-> BW: Provider Struct. f. IO 0ASSET_AFAB

DTFIAP_3 Data Transfer: Customer Items to BW (New)

DTFIAR_3 Data Transfer: Customer Items to BW (New)

FLQACC_ACT Liquidity Calculation - Other Actual Accounts

FLQACC_BURNED Liquidity Calculation - Other Accounts

FLQACC_INFO Liquidity Calculation - Accounts with Assignment Information

FLQACC_INFO_APP Liquidity Calculation - Accounts with Assignment Information

J_1ICOMP Additional company data

J_1IEWTHKONT Table for for TDS provisions Accounts / Loss Accounts

RECP_OI_DOC_CA_COMPCODE Company Code Data

RECP_SENDER_C Sender (Company Code Data)

T001 Company Codes

T038 Cash Management: Grouping Structure

T882 Company Code/Ledger Assignment

Best Regards

Manfred

(I think you know how to extract the Data from SE16 to Excel)

Former Member
0 Kudos
167

Hi Dharma, these tables have both fields; 'T001,T038, T882'.

Kevin

Oops sorry I didn't see the previous reply....please ignore

Edited by: Kevin May on Sep 25, 2009 12:20 PM

Former Member
0 Kudos
167

Hi

Which is your issue?

A company code can have an only one chart of account, so u can find it in the master data table for company code: T001.

Max

Former Member
0 Kudos
167

Thank you all.

The issue has been resolved.

Regards

Dharmaraju