Relation field between table VBRK/VBRP and BSEG

[Former Member]

Can any body guide on the common fields between VBRK/ VBRP and BSEG, except field "assignment".

[Manoj_Mahajan78]

Dear Anjali,

Below are common fileds-

Common Fileds in VBRK & BSEG

MANDT:::Client

BUKRS:::Company Code

BELNR:::Document Number

GJAHR:::Fiscal Year

ZUONR:::Assignment

VBUND:::Trading Partner

Common Fileds in VBRP & BSEG

MANDT:::Client

SHKZG:::Debit/Credit Ind.

GSBER:::Business Area

MWSKZ:::Tax Code

SGTXT:::Text

KOKRS:::Controlling Area

KOSTL:::Cost Center

AUFNR:::Order

Regds

MM

[Former Member]

Hi,

If you know the accounting document number, Goto SE16. enter BSEG table and enter.

Enter the accounting document number in selection screen. E.g 90000498.

You will get multiple lines. E.g normal billing document(Not credit memo /debit memo)

Customer information will be available in posting key 01 line (Header). And Item information will be avilable in Posting key 50 line.

List of fields available in Header.

Billing document number

Customer

Payment terms

Amount.

Company code

Controlling area

Reconciliation account number

Assignment

Item level information in Posting key 50.

Material

Plant

Amount

Tax amount

Tax code

As per my knowledge for reporting purpose we don't use BSEG bcoz of performance issue.

BKPF - Accounting document Header

BSID

BSIS

Regards,

Chandra

[Former Member]

Dear Anjali,

You may check and compare the same, by yourself.

T. Code: SE16

Key-in your table, say VBRK/ VBRP or BSEG.

Execute and on to next page go to Menu-Bar:

Settings --> Format List --> Choose Fields

Here, you will find all the fields for respective Tables.

Just, Copy and paste them in to Excel and compare, what are all fields are common.

i think, its not difficult.

Best Regards,

Amit

[Lakshmipathi]

Dear Anjali

Following VBRK fields can be found in BSEG

MANDT:::Client

BUKRS:::Company Code

BELNR:::Document Number

GJAHR:::Fiscal Year

ZUONR:::Assignment

VBUND:::Trading Partner

Following VBRP fields can be found in BSEG

MANDT:::Client

SHKZG:::Debit/Credit Ind.

GSBER:::Business Area

MWSKZ:::Tax Code

SGTXT:::Text

KOKRS:::Controlling Area

KOSTL:::Cost Center

AUFNR:::Order

thanks

G. Lakshmipathi

[Former Member]

some more that i can think of are

Terms of Payment

Payment method

[Former Member]

MWSKZ- Tax code

VBELN- Billing document

are the important common fields apart frm a/c assignment.

Regards,

Mili