topic Re: Table fields in Application Development and Automation Discussions

Table fields

Former Member — Mon, 24 Dec 2007 06:42:55 GMT

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

Re: Table fields

Former Member — Mon, 24 Dec 2007 06:44:45 GMT

try WHERE USED LIST

Re: Table fields

Former Member — Mon, 24 Dec 2007 06:56:56 GMT

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.

Re: Table fields

Former Member — Mon, 24 Dec 2007 06:58:52 GMT

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

Re: Table fields

Former Member — Mon, 24 Dec 2007 07:13:32 GMT

Check the below tables.

BSIK Accounting: Secondary Index for Vendors

BSAK Accounting: Secondary Index for Vendors (Cleared Items)

Regards,

Maha

Re: Table fields

Former Member — Mon, 24 Dec 2007 07:47:46 GMT

Hi,

tables REGUH- header and

REGUP- detail will have all the above details

saji

Re: Table fields

Former Member — Mon, 24 Dec 2007 07:50:29 GMT

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