Object Tables.

[#1]

Hi SAP Gurus,

does any one have any idea about in which table, object types and desc for invoice, orders, deliveries etc are stored.

i appreciate your help.

Thanks and Regards,

kaviprashu

[Former Member · Accepted solution]

Hi this might be help you.

Or you can show them by enabling the system information in View.

Object Name     Object ID     Description

ACT     1     Chart of Accounts

CRD     2     Business Partner Cards

ITM     4     Items

PLN     6     Price list names

SPP     7     Special prices

CPR     11     Contact employees

USR     12     Users

INV     13     Invoices

RIN     14     Credit notes

DLN     15     Delivery notes

RDN     16     Revert delivery notes

RDR     17     Orders

PCH     18     Purchases

RPC     19     Revert purchases

PDN     20     Purchase delivery notes

RPD     21     Revert purchase delivery notes

POR     22     Purchase orders

QUT     23     Quotations

RCT     24     Receipts incoming payments

DPS     25     Bill of Exchange Deposits

BTD     28     Journal vouchers

JDT     30     Journal entries

ITW     31     Item warehouse

CLG     33     Contact activities

CRN     37     Currency codes

CTG     40     Payment terms types

BNK     42     Bank pages

VPM     46     Payments to vendors

ITB     52     Item groups

CHO     57     Checks for payment

IGN     59     Inventory general entry

IGE     60     Inventory general exit

WHS     64     Warehouses codes and names

ITT     66     Product trees

WTR     67     Stock transfer

WKO     68     Work orders

SCN     73     Alternate catalog numbers

BGT     77     Budget

BGD     78     Budget Distribution

ALR     81     Alerts messages

BGS     91     Budget scenarios

SRI     94     Items serial numbers

OPR     97     Sales Opportunities

CLT     103     Activity types

CLO     104     Activity locations

IBT     106     Item batch numbers

DRF     112     Document draft

EXD     125     Additional Expenses

STA     126     Sales tax authorities

STT     127     Sales tax authorities type

STC     128     Sales tax code

DUN     151     Dunning letters

UFD     152     User fields

UTB     153     User tables

PEX     158     Payment run export

MRV     162     Material revaluation (country-specific for Poland)

163     Purchase invoice correction document

164     Reverse purchase invoice correction document.

CTT     170     Contract templates

HEM     171     Employees

INS     176     Customer equipment cards

WHT     178     Withholding tax data

BOE     181     Bill of exchange for payment

BOT     182     Bill of exchange transaction

CRB     187     Business partner - bank accounts

SLT     189     Service call solutions

CTR     190     Service contracts

SCL     191     Service call

UKD     193     User keys description

QUE     194     Queues

FCT     198     Sales forecast

TER     200     Territories

OND     201     Industries

PKG     205     Packages types

UDO     206     User-defined objects

ORL     212     Relationships

UPT     214     User permission tree

CLA     217     Activity status

BPL     247     Business Places (country-specific for Korea)

JPE     250     Local Era (country-specific for Japan)

TSI     280     Sales tax invoice (country-specific for Poland)

TPI     281     Purchase tax invoice (country-specific for Poland)

[Former Member · Accepted solution]

Hi ,

Thank you so much Bry Bry for providing useful information regarding tables.

but i still didn't able to get object Table..

when i run Inventory Audit Report, there is a column 'Document' in this column Object Name and Document Number is captured.

for example.

Document  IM 2622  Object Name IM stands for 'Inventory Transfer'.

i am searching in which table Object Name is stored..

i appreciate your help.

Thanks and Regards,

kaviprashu

[Former Member · Accepted solution]

Please explain it well, I still can't get it. Sorry.

[Former Member · Accepted solution]

Hi,

i am executing a query, like inventory audit report, but in this query i have requirement to get those data whose Object Type is 13.

my problem solved..

Thanks and Regards,

kaviprashu.