offset account data

[Former Member]

Hi,

can anybody help me to find in which table I can get offset account data for example for a glaccount , I want to find its corresponding offset account.

thanks

bobby

[Former Member]

Hi ,

check tables GLPCT for G/L account data.

Regards

Prabhu

[Former Member]

The Offsetting Account Number(<b>GKONT)</b> & Offsetting Account Type (GKOAR) are stored in the table <b>COEP</b> (CO Object: Line Items (by Period)). This table is a monster & never attempt a direct SELECT on it. Go yo <b>COBK</b> first, grab the relvent document number for the Period in Question and then read<b> COEP</b>. You can also try the database View <b>COVP.</b>

[andreas_mann3]

hi,

table t004 - look to my remarks from

Andreas