Welcome toVigges Developer Community-Open, Learning,Share
Welcome To Ask or Share your Answers For Others


0 votes
in Technique[技术] by (71.8m points)

sap erp - SAP query - BSEG and BKPF

I have two tables in SAP ERP, BSEG and BKPF, can we identify which transactions came from BSIS, BASS, BAUD, BSAD, BSIK or BSAK? If yes then how? which columns and filters should we use?

Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)

You can use the account type field (BSEG-KOART):

BSEG-KOART = 'S' => G/L postings, index tables are BSIS and BSAS
BSEG-KOART = 'D' => customer postings, index tables are BSID and BSAD
BSEG-KOART = 'K' => vendor postings, index tables are BSIK and BSAK.

Alternatively you can use the posting key field as well (BSEG-BSCHL), however it is a bit more complicated:

BSEG-BSCHL = '40' or '50' => G/L postings
BSEG-BSCHL = '01' - '09' or '11' - '19' => customer postings
BSEG-BSCHL = '21' - '29' or '31' - '39' => vendor postings

Welcome to Vigges Developer Community for programmer and developer-Open, Learning and Share