General SAP Tables of GL Master Data
The following are the table names of G/L Master data:
Table name : SKB1 : G/L Account Master ( Company Code)
Fields:
BUKRS : Company Code
SAKNR : G/L Account
Table name : SKA1 : G/L Account Master ( Chart of Accounts )
Fields:
KTOPL : Char of Accounts
SAKNR : G/L Account
Table name : SKAT : G/L Account Master Record ( Chart of Accounts : Description )
Fields:
SPRAS : Language
KTOPL : Char of Accounts
SAKNR : G/L Account
Viewed 12694 times by 3016 viewers
Structure of ADR tables
The ADRS structure in SAP system stores the address data. For example, in case of customer master the complete address details are not stored in table KNA1 (LFA1 for vendor master). KNA1 has a field ADRNR which stores the address number. The complete address is stored in table ADRC with reference to the address number ADRNR. The structure of ADRS stores the address obtained from table ADRC during processing. When you are looking at structure ADRS, you are effectively looking at / trying to store data into table ADRC.
Viewed 12406 times by 2342 viewers
The Kind of SAP Tables
T**** Tables are Transparent Tables
Has a Physical definition and gets created in the database.
V_ Tables are View Tables
View tables are basically LOGICAL VIEW of one or more tables. For example a view is not actually physically stored, instead it is derived from one or more other tables… if you look at the View Table Structure.. you will see that they are basically JOINS of other tables and the fields are derived by varied tables…
Checking SAP Tables via SM30 transaction. eg:
- T512W_D (Definition/Has Physical Storage)
- V_512W_D (Table with Joins/doesnt have physical storage)
Viewed 17786 times by 4721 viewers
Table Description
How can we find the description of each table in SAP?
There is a table which contains description of all tables in SAP. That table is DD02V, you can also see further information of each table here.
Viewed 2960 times by 1100 viewers
Join SAP Community:
mySAP ERP | SAP Business | SAP Tutorial | SAP Help
SAP Production Planning Powered By:
