Table name - MM module

[Former Member]

Hi all,

I have a requirement for Purches ledger Report in

MM Module, I want to add TDS amount in this report.

In MIR4, if we give Invoice document no it will

shows corresponding Accounting document no

and TDS amount.

I want to know about ' MM Table ' which consist of

those two document numbers like Accounting Document no and

Invoice document number..

Kindly reply me any one know about this table.

[Former Member]

hi,

u can find accounting doc no in bseg and bsak,

or u want both to be in same table

regards

karthik

[Former Member]

Hi karthikeyan,

Thankx for ur reply. I want Invoice Document Number and Accounting document Number in same table. Kindly suggest to me,,

Thankx & Regars,

T.Durai murugan.

[Former Member]

Can you try with RBKP and RSEG?

Reward the points if it is useful..

[Former Member]

hi

good

check with these tables

EINA Purchasing Info Record- General Data

EINE Purchasing Info Record- Purchasing Organization Data

MAKT Material Descriptions

MARA General Material Data

MARC Plant Data for Material

MARD Storage Location Data for Material

MAST Material to BOM Link

MBEW Material Valuation

MKPF Header- Material Document

MSEG Document Segment- Material

MVER Material Consumption

MVKE Sales Data for materials

RKPF Document Header- Reservation

T023 Mat. groups

T024 Purchasing Groups

T156 Movement Type

T157H Help Texts for Movement Types

MOFF Lists what views have not been created

reward point if helpful.

thanks

mrutyun^

[Former Member]

Hi all,

I already checked all above mentione tables.That tables doesn't have this two fields like acc.doc.no and invoice.doc.no.

[Former Member]

Hi,

Have you checked EKBE - PO History table?

Please check it once.

ashish

[Former Member]

Hi Ashish,

Ya, i checked EKBE table also.Tell me anyother table which consist of Invoice document number and Accounting document number.

Thankx & Regards,

T.Durai murugan.

[Former Member]

Hi,

You will have to get Invoice document no form EKBE, using this you can get accounting document no from BKPF / BSEG using AWTYP and AWKEY.

ashish

[Former Member]

Hi,

But EKBE didn't have fiels like : AWTYP and AWKEY,then how we will equal this two table and catch the corresponding value.Plz tell me clear.

[Former Member]

Hi,

But EKBE didn't have fiels like : AWTYP and AWKEY,then how we will equal this two table and catch the corresponding value.Plz tell me clear.

[Former Member]

Hi,

First 10 chars of AWKEY is Document Number

regards

Nishant

[Former Member]

hi nishant,

Ya, it's correct. Plz tell me Qurey (sql) for the above case, it's very helpful to me. I want Accounting document number for corresponding invoice document.

Thankx advance.

[Former Member]

Select *

from EKBE

into TABLE tb_EKBE

FOR ALL ENTRIES in it_tab

where EBELN = lt_tab-awkey+0(10).

This should work.

regards

Nishant

[Former Member]

hi durai murugan,

This may b usefull for u ..

SAP MODULE WISE TABLES

Name

Description

Uses

LIKP

Shipped Lines header

LIPS

Shipped Lines detail

VBAK

Order header

Every order (unless archiving)

VBAP

Table fields

Every line item (unless archiving)

VBBE

Open sales order line items

Great file, but be careful. Contents don't reflect orders that do not affect purchasing (go figure).

VBFA

Document flow

Let's you move from order to shipping document to invoice.

VBUK

Order status

VBUP

Line item detail status

Material Management

Name

Description

Uses

MARA

Inventory Master

MARC

Plant Data

MARD

Current Inventory

MAKT

Descriptions

MBEW

Material Valuation

T179

Product Hierarchy

MVKE

Sales data (materials)

MKPF

Material document

Status code 'R' in VBFA

Purchasing

Name

Description

Uses

EINA

Purchasing inforecord

by MATNR/LIFNR contains things like vendor material number and access key for EINE

EINE

Purchasing inforecord detail

Contains minimum purchase, group, currency

EKPO

Purchase orders

EKET

Scheduled lines

EKES

Vendor confirmed lines

Service Management

Name

Description

Uses

CAUFV

Service order header

AFPO

Service order line

Holds items that will create "reservations"

RESB

SM Reservations

Materials needed for line

Customer Data

KNAI

Customer Master

KNVV

Sales information

KNVP

Partners (ship-to, etc)

System tables

Name

Description

Uses

DD02T

Table texts

DD03L

Table fields

Lists the fields in a table

DD04T

Data element texts

USR02

Valid user names

Config tables (normally begin with "T")

Name

Description

Uses

T001

Client table

T002

Languages

T005

Region (Country)

TCURR

Currency and exchange rates

TVAK

Order type

TVSB

Shipping condition

TVAGT

Rejected reason for order line

Other tables

Name

Description

Uses

STXH

Text header

STXL

Text detail

[Former Member]

hi,

can yoou try with table RBKP and its related item table like RBCO?

[Former Member]

Thankx for all, my probelm is solved .

Regards,

durai.