topic Re: relation between ( BSEG or Bkpf) with Ska1 in Application Development and Automation Discussions

relation between ( BSEG or Bkpf) with Ska1

Former Member — Mon, 02 Feb 2009 12:28:39 GMT

Hi Everyone,

I want to know the relation between the table ( BSEG or Bkpf) with Ska1 , Am using BSEG and Bkpf table. I have to find out the account number. Please let me know the relation

Thanks

Imran

Re: relation between ( BSEG or Bkpf) with Ska1

SuhaSaha — Mon, 02 Feb 2009 12:30:40 GMT

Hello,

BSEG-HKONT = SKA1-SAKNR.

Suhas

Re: relation between ( BSEG or Bkpf) with Ska1

Former Member — Mon, 02 Feb 2009 12:33:47 GMT

first, use the BKPF (header), then BSEG, and for each BSEG, use the SKA1 with BSEG-HKONT.

Regards

Re: relation between ( BSEG or Bkpf) with Ska1

ThomasZloch — Mon, 02 Feb 2009 12:45:18 GMT

SKA1 also has KTOPL as key, you'll have to look it up via BSEG-BUKRS and table T001.

Thomas

Re: relation between ( BSEG or Bkpf) with Ska1

Former Member — Mon, 02 Feb 2009 13:33:33 GMT

Hi,

SKA1 is the G/L account Master Table.

BSEG and BKPF are the Accounting Documents Segment and Header tables.

Re: relation between ( BSEG or Bkpf) with Ska1

RaymondGiuseppi — Mon, 02 Feb 2009 14:57:58 GMT

Look at foreign keys via SE11 (HKONT --foreign key-> SKB1, there T001-KTOPL and SAKNR ~~foreign keys~~> SKA1)

- Read first T001 from BKPF-BUKRS

- Read then SKA1 from T001-KTOPL and BSEG-HKONT

Regards