Table fields

[Former Member]

Hi all,

Can you please tell me in which tables will i find all the following fields(with field names):

cheque no

account no

vendor name

vendor no

invoice no

invoice date

description(item description for invoice)

discount amount

net amount

bank name

PO box

bank city

state

zip

payee name

payee street address payee city

state

zip

[Former Member]

try WHERE USED LIST

[Former Member]

Hi Monika

Am giving you an rough idea, but this may not be same and it will vary with the conditions. It's not simple as it seems to be shown below ... There are so many condition to be considered before you can extract the data as mentioned from below tables and field.

cheque no BSIK/BSAK-??

account no BSIK/BSAK-SAKNR

vendor name LFA1-NAME

vendor no BSIK/BSAK-LIFNR

invoice no BSIK/BSAK-BELNR

invoice date BSIK/BSAK-BLDAT

description(item description for invoice)

discount amount Calculated value based on BSIK/BSAK-ZBD1T

ZBD2T and BSIK/BSAK-ZBD1P

ZBD2P

net amount BSIK/BSAK-DMBTR

All the below mentioned can be obtained may be from T012.

bank name

PO box

bank city

state

zip

payee name

payee street address payee city

state

zip

~ Ranganath

[Former Member]

hi monika,

Please use dd0* series tables.

For example: DD04t, DD04l etc to find the description of the domains and data elements. In this manner, u can easily figure out the fields at first and then the corresponding tables (in which the fields are present).

Following are some series tables:

1.) DD01L

2.) DD01T

3.) DD02DB2

4.) DD02T

5.) DD03L

6.) DD08T

To know more DD series tables, goto se11 (ABAP Dictionary), give DD0* as input in "DATABASE TABLE" and then press F4. u will definitely find the fields and their corresponding table names in the DD series tables.

Regards,

Rajesh.

[Former Member]

Check the below tables.

BSIK Accounting: Secondary Index for Vendors

BSAK Accounting: Secondary Index for Vendors (Cleared Items)

Regards,

Maha

[Former Member]

Hi,

tables REGUH- header and

REGUP- detail will have all the above details

tc

saji

[Former Member]

Hi Monika,

DD02L Table contains the SAP Tables.

DD02T Table contains the SAP Table Texts.

DD01L Table contains the Domains

DD01T Table contains the Domain Texts.

DD03L Table contains the Table Fields.

DD03T Table contains the Table Field Texts. (Language Dependent)

DD04L Table contains the Data Elements.

DD04T Table contains the Data Element Texts.

DD05s Table contains the Foreign Key Fields

last words with L and T only. L->Database Fetch T-> Text

Regards,

Chandru