Accounts payable table relationship.

[Former Member]

hi ,

i want how the for bseg-belnr is related to material no matnr

please if possible give me the details how fi and mm arerealted .

[Former Member]

hi ,

i want how the for bseg-belnr is related to material no matnr

please if possible give me the details how fi and mm arerealted .

[Lakshmant1]

Hi rasmi,

Have a look at url

http://www.abap.es/Descargas/TAB%20-%20Relacion%20de%20las%20tablas%20por%20modulos.PDF

Hope this helps

Thanks

Lakshman

[Former Member]

Hi ,

i do have this pdf . but i am unable to get the relationship betweet belnr and matnr ....

[Lakshmant1]

Hi rasmi,

When an invoice is posted and verified, the following occurs:

1)The system automatically determines the accounts to be posted to and the amounts for posting. This information comes from Account Determination in Purchase Order and Purchase Requisition.

2)The system creates an MM invoice document, and an FI document which is used in the Financial Accounting and Controlling modules. Both documents will be given the same number.

3)After the invoice has been posted, the document appears as an open item on the vendor account (line item display).

Hope this helps

Thanks

Lakshman

[Former Member]

Hi,

Check this

https://forums.sdn.sap.com/click.jspa?searchID=11619906&messageID=4533050

Regards

Kiran Sure

[Former Member]

Hi,

They are not related. Material number is related to MM master table and BSEG table is used for accounting calculations.

Hope this helps.

Regds

Seema

[GauthamV]

hi,

The FI - MM integration:

First you define the g/l master records.

1) Inventry raw material a/c

2) GR/IR clearing a/c

3) Raw material consumption a/c

Above like this you define all required g/l accounts

then you will go to T.CODE - OBYC

Double click BSX (this is transaction key)

" GBB

" WRX

" PRD

These are transaction keys important.

Then you go to T CODE - OMSY (this is also important) then

Material creation T Code MM01

then

1) Purchase order T.code ME21N

2) Goods received " MIGO

3) Invoice verification " MIRO

given below r tables related to mm:

Common Tables used by SAP MM

Below are few important Common Tables used in Materials Management Modules:

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

A501 Plant/Material

EBAN Purchase Requisition

EBKN Purchase Requisition Account Assignment

EKAB Release Documentation

EKBE History per Purchasing Document

EKET Scheduling Agreement Schedule Lines

EKKN Account Assignment in Purchasing Document

EKKO Purchasing Document Header

EKPO Purchasing Document Item

IKPF Header- Physical Inventory Document

ISEG Physical Inventory Document Items

LFA1 Vendor Master (General section)

LFB1 Vendor Master (Company Code)

NRIV Number range intervals

RESB Reservation/dependent requirements

T161T Texts for Purchasing Document Types

SAP MM Tips by : Bahadur

Following are the list of Important MM tables. Please check if its useful.

Inventory Management:

---- ----
	Table	Description
---- ----
Material	MSEG	Material document / transaction details
Document/Movements	MKPF	Material document header information
---- ----
Material Stock Balances	MARD	Material stock
	MBEW	Material stock with valuation
---- ----
Sales Order Stock	MSKA	Stock balance with associated sales
		order data
---- ----
Stock Transport	EKUB	Index for Stock Transport Orders for
	MDUB	Material
		Reading View of Stock Transport Ord. for
		Release Ord.
---- ----
Special Stocks	MKOL	Consignment, material provided to
		vendor, etc.
---- ----

Material Master Data:

---- ----
	Table	Description
---- ----
Materials	MARA	General Data, material type, group,
		configurable & batch ind.
	MAKT	Short Texts, descriptions
	MARM	Conversion Factors
	MVKE	Sales Org, distribution channel
	MLAN	Sales data, tax indicator, tax
	MARC	classification
	MBEW	Plant Planning Data
	MLGN	Valuation Data
	MLGT	Warehouse Management Inventory Data
	MVER	Warehouse Management Storage Type
	MAPR	Data
	MARD	Consumption Data
	MCHA	Pointer for Forecast Data
	MCHB	Storage location data with stock
		balances
		Batches
		Batch Stocks

All The Tables In SAP MM Purchasing

Please find all tables in MM-PUR (Purchasing) :

EBAN - Purchase Requisition

EBKN - Purchase Requisition Account Assignment

EBUB - Index for Stock Transport Requisitions for Materi

EINA - Purchasing Info Record: General Data

EINE - Purchasing Info Record: Purchasing Organization D

EIPA - Order Price History: Info Record

EKAB - Release Documentation

EKAN - Vendor Address: Purchasing Document

EKBE - History per Purchasing Document

EKBEH - Removed PO History Records

EKBZ - History per Purchasing Document: Delivery Costs

EKBZH - History per Purchasing Document: Delivery Costs

EKEH - Scheduling Agreement Release Documentation

EKEK - Header Data for Scheduling Agreement Releases

EKES - Vendor Confirmations

EKET - Scheduling Agreement Schedule Lines

EKETH - Scheduling Agreement Schedules: History Tables

EKKI - Purchasing Condition Index

EKKN - Account Assignment in Purchasing Document

EKKO - Purchasing Document Header

EKPA - Partner Roles in Purchasing

EKPB - "Material Provided" Item in Purchasing Document

EKPO - Purchasing Document Item

EKPV - Shipping-Specific Data on Stock Tfr. for Purch. D

EKRS - ERS Procedure: Goods (Merchandise) Movements to b

EKUB - Index for Stock Transport Orders for Material

EORD - Purchasing Source List

EQUK - Quota File: Header

EQUP - Quota File: Item

T024 - Purchasing Groups

T024E - Purchasing Organizations

T024W - Valid Purchasing Organizations for Plant

T024Z - Purchasing Organizations

T027A - Shipping Instructions, Purchasing

T027B - Texts: Shipping Instructions

T027C - Codes for Compliance with Shipping Instructions

T027D - Compliance with Shipping Instructions: Texts

T069 - Certificate Categories

T069Q - Control Data for Source Determination and Checkin

T069T - Certificate Categories: Text Description

T160 - SAP Transaction Control, Purchasing

T160B - SAP Transaction Control, List Displays, Purchasin

T160C - SAP Transaction Control for List Displays in CALL

T160D - Function Authorizations: Purchase Order

T160E - Function Authorizations: Purchasing: Descriptions

T160I - Control of Intrastat Reports

T160J - Text Table for Intrastat Reports

T160L - Scope of Purchasing Lists

T160M - Message Control: Purchasing (System Messages)

T160O - Description of Scope of List

T160P - Entities Table Routines

T160Q - Scope of List: Buyer's Negotiation Sheet: Routine

T160R - Routines for Buyer's Negotiation Sheet

T160S - Selection Parameters for Purchasing Lists

T160T - Description of Selection Parameters

T160V - Default Values for Purchasing

T160W - Description for Default Values for Purchasing Ope

T160X - Scope of List: Buyer's Negotiation Sheet

T160Y - Scope of List: Buyer's Negotiation Sheet: Descrip

T161 - Purchasing Document Types

T161A - Linkage of Requisition Doc. Type to Purchasing Do

T161B - Default Business Transaction Type for Import

T161E - Release Codes

T161F - Release Point Assignment for Purchase Requisition

T161G - Release Prerequisite, Purchase Requisition

T161H - Fields for Release Procedure, Purchase Requisitio

T161I - Determination of Release Strategy

T161M - Fine-Tuned Control: Message Types

T161N - Message Determination Schemas: Assignment

T161P - Check of Document Type, Document Category, Item C

T161R - REORG Control, Purchasing

T161S - Release Indicator, Purchase Requisition

T161T - Texts for Purchasing Document Types

T161U - Texts for Release Indicator

T161V - Shipping-Specific Data for Stock Tfr. for Purch.

T161W - Order Types for Stock Transfer

T161Z - Additional Checks for Outline Agreements on Reorg

T162 - Field Selection, Purchasing Document

T162K - Field Selection, Account Assignment Fields, Purch

T162T - Description of Field Selection Reference Key

T162X - Description of Field Groups from T162/T162K

T162Y - Groups: Field Selection

T163 - Item Categories in Purchasing Document

T163A - Check Item Category/Account Assignment Category

T163B - Purchase Order History Categories

T163C - Texts for Purchase Order History Categories

T163D - Assignment Internal/External Confirmation Categor

T163E - Confirmation Categories

T163F - Confirmation Categories: Descriptions

T163G - Confirmation Control

T163I - Texts for Account Assignment Categories

T163K - Account Assignment Categories in Purchasing Docum

T163KS - Assignment of Tax Indicator to Account Assignment

T163L - Confirmation Control Keys

T163M - Confirmation Control Keys: Description

T163P - Release Creation Profile

T163S - Description for Release Creation Profile

T163X - "Zombie" T163X

T163Y - Texts for Item Categories

T165K - Copying Options: Header Texts

T165P - Copying Options: Item texts

T166A - Supplement Text in Purchasing Document Printouts

T166C - Print-Relevant Purchasing Document Changes

T166K - Header Texts in Purchasing Document Printouts

T166P - Item Texts in Purchasing Document Printouts

T166T - Change Texts in Purchasing Document Printouts

T166U - Headings in Purchasing Document Printout

T167 - Number Range Management for Purchasing Master Dat

T167T - Transaction Description

T168 - Screen Control, Purchasing

T168F - Function Codes, Purchasing

T168T - Screen Titles

T16FB - Release Indicators: Purchasing Document

T16FC - Release Codes

T16FD - Description of Release Codes

T16FE - Descriptions of Release Indicators: Purchasing Do

T16FG - Release Groups

T16FH - Descriptions of Release Groups

T16FK - Release Statuses

T16FS - Release Strategies

reward POINTS if hlpful.