Really Urgent

[Former Member]

Hi,

i want to know the table which shows the cost of material had been paid or not?

Plzz help me its really urgent to me.

[Former Member]

hI

[Former Member]

hi,

can u tell me which tables is used for costing of materials whether its payment is done or not?

[Former Member]

Hi Ric,

LFA1 – vendor data (LIFNR)

LFB1 -- Company Code Segment : Vendor Data(LIFNR, BUKRS)

LFC1 -- FI Related Vendor Data (LIFNR, BELNR)

LFM1 – Pur. Orgn. Related Vendor Data (LIFNR, EKORG)

MARA – Material Master (MATNR)

MARC – Material Master with Plant Data (MATNR, WERKS)

MARD – Material Master with Storage Location Data (MATNR, LGORT, WERKS)

MAKT – Material Master Material Descriptions (MATNR, MATKL)

MBEW – Material Valuation Data (MATNR, BWTAR)

MVKE – Material Master : Sales related Data

MDKP, MDTB – MRP related Data( Header, Item)

MCHA, MCHB – Material Batches (Header, Item) (MATNR, WERKS, LGORT, CHARG)

EBAN – Pur. Req. Data( BANFN, BNFPO, BADAT, MATNR)

EINA – Purchase Info. Record(General Data)(INFNR, MATNR, LIFNR)

EINE – Purchase Info. Record (pur. Orgn. Data) (INFNR, EKORG)

ELBK, ELBN, ELBP – Vendor Evaluation Related Data

EKKO – PO Data (Header) (EBELN, BSTYP, BSART)

EKPO – PO Data (Item) (EBELN, EBELP, MATNR)

Pur. Req., RFQ and PO are differentiated by Doc Type (BSTYP) in EKKO table.

For RFQ it is ‘A’ and for PO it is ‘F’

MKPF – GRN Data (Header) (EBELN, BLDAT, BUDAT, XBLNR, BKTXT)

MSEG – GRN Data(Item) MBLNR, BWART, LIFNR, MATNR, EBELN)

Apart from this there are lot of tables which begin with ‘M’ & ‘E’, but we

use the following very often.

EQUK – Quota (Header)(QUNUM, MATNR)

EQUP – Quota (Item) (QUNUM, QUPOS, LIFNR)

EKBE – PO History Data (EBELN, EBELP, BELNR, BLDAT, MATNR, VGABE)

EKBZ – PO History with Delivery Costs(EBELN, BELNR, LIFNR, XBLNR)

EKET – Schedule lines data of a PO(EBELN, EINDT, SLFDT)

EKES – Vendor Confirmations Data (EBELN, EBTYP, EINDT, XBLNR)

T163F – Confirmation Texts (EBTYP, EBTXT)

T156 – Movement Types (BWARE)

T024 – Purchasing Groups

T024E – Purchase Organizations

T163 – Item Category’s in Purchasing Documents(PSTYP)

T149D – Valuation Types

T134 – Material Types

FVLK – Delivery Types

STKO, STPO – BOM(Bill Of Material) related Data (Header & Item)

STPU, STPN, STST, STZU – BOM Related Tables

RKPF, RBKP, RSEG (Header & Item) – MM – FI Related Data

KONO, KONH – Pricing data

VBAK : Sales Document(Header Data) (VBELN)

VBAP : Sales Document(Item Data) (VBELN, POSNR, MATNR, ARKTX, CHARG)

Enquiry, Quotation, Sales Order are differentiated based on Doc.

Type(VBTYP Field) in VBAK, VBAP Tables for Enquiry VBTYP = A, for Quotation ‘B’ & for Order it is ‘C’.)

LIKP : Delivery Table(Header Data) (VBELN, LFART, KUNNR, WADAT, INCOL)

LIPS : Delivery Table(Item Data)(VBELN, POSNR, WERKS, LGORT, MATNR, VGBEL)

(LIPS – VBGELN = VBAK- VBELN, LIPS-VGPOS = VBAP-POSNR)

VTTK : Shipment Table(Header Data) (TKNUM)

VTTP : Shipment Table (Item Data)(TKNUM, TPNUM, VBELN)

(VTTP – VBELN = LIKP – VBELN)

VBRK : Billing Table(Header Data) (VBELN, FKART, BELNF)

VBRP : Billing Table(Item Data) (VBELN, POSNR, FKIMG, NEWR, VGBEL, VGPOS)

(VERP – AUBEL = VBAK- VBELN, VBRP – VBEL = LIKP – VBELN)

Apart from these tables there are lot of other tables which starts with ‘V’, but we use the

following tables frequently.

VBUK: All Sales Documents status & Admn. Data(Header) (VBELN, VBTYP)

VBTYP = ‘C’ (Sales Order) VBTYP = ‘L’(Delivery) VBTYP = ‘M’(Invoice)

VBUP: Sales Documents status & Admin. Data(Item) (VBELN, POSNR)

VBEP : Sales Document Schedule Lines Data (VBELN, POSNR, EDATU, WMENG)

VBKD: To get sales related Business data like Payment terms etc.(VBELN, ZTERM)

VBFA: Sales Document flow data(VBELV, VBELN, POSNV, VBTYP)

VBPA: Partner functions Data(VBELN, PARVW, KUNNR, LIFNR)

TVLKT: Delivery Type: Texts(LFART, VTEXT)

KNA1, KNB1, KNC1 : Customer Master Data and Other Partner’s Data(KUNNR,

NAME1,LAND1)

KNVK: Customer Master Contact Person(PARNR, KUNNR)

KNVV: Customer Master Sales Data.

LFA1, LFB1, LFC1: Vendor Master Data(To get Transporter data)(LIFNR, NAME1, ORT01)

MARA, MARC, MARD : Material Master Data(Basic, Plant, St. Location Views)

TVKO: Sales Organizations(VKORG)

TVKOV: Distribution Channels(VTWEG)

TVTA: Divisions(SPART)

TVKBZ: Sales Office(VKBUR)

TVBVK: Sales Group(VKGRP)

T077D: Customer Account Group(KTOKD)

T001W: Plants(WERKS)

T001L: Storage Locations(LGORT)

TWLAD: To get address of Storage Location and Plant(LGORT, ADRNR)

TVAU: Sales Document (Order) Types

KONV: Condition Types (pricing) (KNUMV, KSCHL, KWETR)

T685T: Condition Types Texts.

ADRC: To get Addresses of Partners

VBBE, VBBS: Sales Requirements Data

VBKA: Sales Activities Data

VBPV: Sales Document Product Proposal

Hope this Might Help u

[Former Member]

hi,

but i want to know about only 1 or 2 tables which shows the costing of a material.

plzz help me out as it is really urgent to me.

Edited by: ric .s on Apr 22, 2008 9:28 AM