topic offset account data in Application Development and Automation Discussions

offset account data

Former Member — Thu, 20 Jul 2006 04:48:56 GMT

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

Re: offset account data

Former Member — Thu, 20 Jul 2006 04:54:34 GMT

Hi ,

check tables GLPCT for G/L account data.

Regards

Prabhu

Re: offset account data

Former Member — Thu, 20 Jul 2006 05:01:44 GMT

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

Re: offset account data

andreas_mann3 — Thu, 20 Jul 2006 06:43:37 GMT

hi,

table t004 - look to my remarks from

Andreas