MASTER TABLE

[Former Member]

Hi Gurus,

I am new to ABAP...can you please tell me the master table of the following:

vkgrp->purchasing group

vkorg-> purchasing organization

lgort-> Storage Location

werks -> Plant

Thanks

Rajeev Gupta

[former_member198275 · Accepted solution]

Vbak - Sales Document: Header Data

Vbap - Sales Document: Item Data

Vbuk - Sales Document: Header Status and Administrative Data

Vbfa - Sales Document Flow

Vbpa - Sales Document: Partner

Vbrk - Billing Document: Header Data

Vbrp - Billing Document: Item Data

Mkpf - Header: Material Document

Mseg - Material : Document Segment

Mard - Storage Location Data for Material

Mast - Material to BOM Link

Mvke - Sales Data for Material

Makt - Material Descriptions

Mbew - Material Valuation

Tvmst - Materials: SD Status: Texts

Bsak - Accounting: Secondary Index for Vendors (Cleared Items)

Bsis - Accounting: Secondary Index for G/L Accounts

Bseg - Accounting Document Segment

Bkpf - Accounting Document Header

Lfa1 - Vendor Master (General Section)

Lfb1 - Vendor Master (Company Code)

Kna1 - General Data in Customer Master

Knb1 - Customer Master (Company Code)

Ekko - Purchasing Document Header

Eban - Purchasing Document Header

Likp - SD Document: Delivery Header Data

Lips - SD document: Delivery: Item data

Stko - BOM Header

Stpo - BOM item

T001 - Company Codes

T005s - Taxes: Region (Province) Key

Cdhdr - Change document header

Sl.no. Table Description Fields Fld. Desc.

1. Vbak Sales Document: Header Data Erdat

ernam

Lifsk

Faksk

Netwr

Aufnr

Vkorg

Vtweg

Spart

Quart

Kunnr

vbeln Date created

Person created

Delivery block

Billing block

Net value of S.O. in doc.

Order no.

Sales orgn.

Distribution channel

Division

Cr/db memo(value:L2/g2)

Cust no.

Sales document

2. Vbap Sales Document: Item Data Vbeln

Posnr

Matnr

Charg

Matkl

Arktx

Posar

Aufnr

Ernam

Kwmeng

Netwr Sales Document

Sales Document Item

Material Number

Batch Number

Material Group

Short Text for S.O Item

Item type

Sales order no.

Person created

Order qty

Net value

3. Vbuk Sales Document: Header Status and Administrative Data Vbeln

Bestk

Lfstk

Fkstk

Cmgst S.D Document Number

Confirmation status

Delivery status

Billing status

Overall status of cr checks

4. Vbfa

5. Vbpa

6. Vbrk Billing doc.:Header Vbeln

Waerk

Vkorg

Fkdat

Bukrs

netwr Billing doc. No.

Sd. Doc. Curr

Sales orgn.

Billing/invoice date

Company code

Net value in doc. curr

7. Vbrp Billing doc. : item Vbeln

Posnr

Fkimg

vrkme

matnr

arktx

Netwr

Mwsbp

Posnr

tx9.jcd Billing doc. no

Billing item

Actual invoiced qty

Sales unit

Material no.

Sales order item text

Net amount

Tax amount

Billing item

Tax code

8. Mkpf Header : mat. Doc. Mblnr

Budat

Blart No. of material document

Posting date in doc.

Doc.type

9. Mseg Doc.segment-material Matnr

Mblnr

lifnr

Werks

Lgort

Bwart

Menge

Meins

Dmbtr

Lbkum

Salk3

bwtar

Material no.

Material doc. No.

Vendor a/c no.

Plant

Storage loc.

Mvmnt. Type

Quantity

Units

Amnt. In local curr.

Val. Of total val.ed stock

total val.ed stock

valuation type

10. Mard Storage Location Data for Material Matnr

Werks

Lgort Material no.

plant

Storage location

11. Mast Material to BOM Link Matnr werks

Stlnr Material number

Plant

Bill of material

12. Mvke Sales Data for Material Matnr

Vkorg

Vtweg

Vmsta Material number

Sales organization

Distribution channel

Distibution-chain-specific- -material status

13. Makt Material Desc. Matnr

Spras

Maktx

maktg Material no.

Lang. Key

Material description

Mat. Desc. in U.Case for matchcodes

14. Mbew Material Valuation Matnr

Bwkey

Bwtar

Salk3

lbkum Material no.

Valuation area

Valuation type

Total valuated stock

Value of total val.ed stock

15. tvmst Materials: SD Status: Texts Spras

Vmstb

Vmsta Language key

description

Distribution-chain-specific material status

16. Bsak A/c.ing : Secondary Index for Vendors (Cleared Items) Bukrs

Lifnr

Umsks

Augdt

Gjahr

Belnr

Bldat

Waers

Bschl

Dmbtr

Zlsch

Augbl

Buzei

Ebeln

Shkzg

Blart

Sknto

Company Code

A/c No. of Vendor/credtor

Spl G/L Transaction Type

Clearing Date

Fiscal Year

A/c.ing Doc No.

Doc Date in Document

Currency Key

Posting Key

Amt. in local currency

Payment method

Clearing doc. No.

Line item no. of doc. No.

Purchase doc. No.

Db/ cr indicator

Doc. Type

Cash disc. In local curr.

17. Bsis A/cing : Secondary Index for G/L a/c.s Buzei

Bukrs

Augbl

Gjahr

Budat

Shkzg

Bschl

Dmbtr

Augdt

belnr Line item no. of doc. No.

Company Code

Clearing doc. No.

Fiscal Year

Doc. Posting date

Db/ cr indicator

Posting Key

Amt. in local currency

Clearing doc. No.

A/c.ing Doc No.

18. Bseg A/cDoc. Segment Bukrs

Belnr

Gjahr

Buzei

Augdt

Augbl

Bschl

Zlsch

Shkzg

Dmbtr

Ebeln

Sknto

Lifnr Company Code

A/cing doc no.

Fiscal Year

Line item no. of doc. No.

Clearing doc. No.

Clearing doc. No.

Posting Key

Payment method

Db/ cr indicator

Amt. in local currency

Purchase doc. No.

Cash disc. In local. Curr

Vendor no.

19. Bkpf A/c.ing doc.:Header Belnr

Budat

bukrs A/c doc. No.

Posting date

Co., code

20. Lfa1 Vendor Master -(General Section) Lifnr

Kunnr

Name1

Ort01

Pstlz Vendor a/c no.

Cust no.

Name1

City

Postal code

21. Lfb1 Vendor Master (Company Code) Lifnr

Bukrs

Pernr A/c No of Vendor/Creditor

Company code

Personnel number

22. Kna1 Cust Mstr: Gen data Kunnr

Name1

Ort01

Ort02

Pstlz

Stras

Regio Cust. No.

Name1

City

district

Postal code

House no. & street

region

23. Knb1 Cust.Mastr:co code Akont

Kunnr

bukrs Reconciliation a/c in G/L

Cust. No.

Co., code

24. Ekko Purchasing Doc. : Header Ebeln

ekgrp Purchase doc. No.

Purchase group

25. Eban Purchase Requisition Banfn

Bnfpo

Bsart

Bstyp

Frgzu

Matnr Purchase reqisition number

Item no. of purchase Req.

Purchase req doc type

Purchasing doc. category

Release status

Material number

26. likp SD Document: Delivery Header Data Vbeln

Ernam

Erdat

bzirk

Vkorg

Lfart

Lfdat Delivery

Creating person name

Record creation date

Sales district

Sales Organization

Delivery type

Delivery date

27. Lips SD document: Delivery: Item data Vbeln

Posnr

Ernam

Erdat

Matnr

matkl

werks

charg

vrkme Delivery

Delivery item

Creator name

Created date

Material number

Material group

Plant

Batch number

Sales unit

28. Stko BOM Header Stlty

Stlnr

Stlal BOM category

Bill of Material

Alternate BOM

29. Stpo BOM item Stlty

Stlnr BOM category

Bill of Material

30. T001 Company codes Butxt

bukrs Co., code

Name of company

31. T005s Taxes: Region (Province) Key Fprcd Provincial tax code

32. Cdhdr Change doc: header Changenr

Udate Doc. Change number

Change doc. creation date

[Former Member]

Hi Rajeev,

Master table for

EKGRP - Purchasing Group -T024

EKORG - Purchasing Organization - T024E

LGORT - Storage Location - T001L

WERKS - Plant -T001W

Please award points if answer is helpful.

Regards

Puneet

[Former Member]

Hey thanks for the reply, but now I am kind of confused, I mean I get to know MARC and T001w for plant, MARD and T001L for storage location, ca you please guide me which one to take.

Thanks

Rajeev Gupta

[former_member188827]

check

MARC(FOR PLANT)

EINE (FOR PURCHASING ORG DATA)

MARD(FOR STORAGE LOCATION)

PLZ REWARD POINTS IF DIS HELPS

Message was edited by:

abapuser

[Former Member]

Hi

Master Tables

for

vkgrp->purchasing group -<b>T024</b>

vkorg-> purchasing organization - <b>T024E</b>

lgort-> Storage Location - <b>T001L[/b

]werks -> Plant -<b>T001W</b>

Regards

Anji

Message was edited by:

Anji Reddy Vangala

[Former Member]

Thanks for the reply ANji,

actually somehow I asked the wrong table names:

I ma looking for the master table of the following:

ekgrp

ekorg

lgort

and werks.

Sorry for the inconvinence.

Rajeev Gupta

[Former Member]

hi,

Look for the master table name in the 'CHECK TABLE' column.

Cheers

L

[Former Member]

Hi Rajeev

I have given the right Table names only though you asked wrong field names

see them they are right only

EKGRP- purchasing group -<b>T024</b>

Ekorg-> purchasing organization - <b>T024E</b>

lgort-> Storage Location - <b>T001L</b>

werks -> Plant -<b>T001W</b>

Regards

Anji

[Former Member]

Hey thanks for the reply, I have one small question. I was just tryinh to locate the table names and I found MARD for storage location and you have suggested T001L, whats is the difference in these two.

Thanks

Rajeev Gupta