topic Re: Table name - MM module in Application Development and Automation Discussions

Table name - MM module

Former Member — Tue, 30 Oct 2007 11:54:58 GMT

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.

Re: Table name - MM module

Former Member — Tue, 30 Oct 2007 12:00:16 GMT

hi,

u can find accounting doc no in bseg and bsak,

or u want both to be in same table

regards

karthik

Re: Table name - MM module

Former Member — Tue, 30 Oct 2007 12:44:12 GMT

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.

Re: Table name - MM module

Former Member — Tue, 30 Oct 2007 12:52:20 GMT

Can you try with RBKP and RSEG?

Reward the points if it is useful..

Re: Table name - MM module

Former Member — Tue, 30 Oct 2007 13:09:38 GMT

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^

Re: Table name - MM module

Former Member — Tue, 30 Oct 2007 13:53:39 GMT

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.

Re: Table name - MM module

Former Member — Tue, 30 Oct 2007 13:59:40 GMT

Hi,

Have you checked EKBE - PO History table?

Please check it once.

ashish

Re: Table name - MM module

Former Member — Wed, 31 Oct 2007 04:57:09 GMT

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.

Re: Table name - MM module

Former Member — Wed, 31 Oct 2007 05:12:03 GMT

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

Re: Table name - MM module

Former Member — Wed, 31 Oct 2007 05:24:22 GMT

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.

Re: Table name - MM module

Former Member — Wed, 31 Oct 2007 05:28:35 GMT

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.

Re: Table name - MM module

Former Member — Wed, 31 Oct 2007 05:29:55 GMT

Hi,

First 10 chars of AWKEY is Document Number

regards

Nishant

Re: Table name - MM module

Former Member — Wed, 31 Oct 2007 05:40:25 GMT

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.

Re: Table name - MM module

Former Member — Wed, 31 Oct 2007 05:47:26 GMT

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

Re: Table name - MM module

Former Member — Wed, 31 Oct 2007 06:06:52 GMT

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

Re: Table name - MM module

Former Member — Wed, 31 Oct 2007 07:29:35 GMT

hi,

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

Re: Table name - MM module

Former Member — Thu, 01 Nov 2007 05:48:22 GMT

Thankx for all, my probelm is solved .

Regards,

durai.