SD MM Table

Former Member — Thu, 31 Jan 2008 07:42:36 GMT

Can any body give me the important tables in SD and MM.

Re: SD MM Table

Former Member — Thu, 31 Jan 2008 07:44:55 GMT

SD tables

http://www.erpgenie.com/abap/tables_sd.htm

MM tables

http://www.erpgenie.com/abap/tables_mm.htm

Reward if useful.

Re: SD MM Table

Former Member — Thu, 31 Jan 2008 07:46:59 GMT

SALES & DISTRIBUTION MODULE RELATED TABLES: (SD)

Cycle:

Enquiry->Quotation->Sales Order->Delivery(Picking, Packing, Post Goods

Issue and Shipment)->Billing-> Data to FI

TABLES and Important Fields:

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,INCO1)

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

(LIPS-VGBEL = VBAK-VBELN, LIPS-VGPOS = VBAP-POSNR)

VTTK: Shipment Table (Header Data)(TKNUM)

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

(VTTP-VBELN = LIKP-VBELN)

VTFA: Shipping Document Flow(TKNUM,VBELV,VBELN)

VTPA: Shipping Partners data(VBELN,PARVW,KUNNR,PERNR)

VTTS: Stages in Shipment(TKNUM,TSNUM,TSTYP)

VTSP: Transport Stage/Shipment Item Allocation(TKNUM,TSNUM,TPNUM)

VEKP: Handling Unit: Header(Packing)(VENUM,VSTEL)

VEPO: Handling Unit: Item (Packing)(VENUM,VEPOS,VBELN)

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

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

(VBRP-AUBEL = VBAK-VBELN, VBRP-VGBEL = 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=’J’(Delivery) VBTYP=’M’(Invoice)

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

VBEP: Sales Doc. 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)

VEDA: Contract Data(VBELN,VPOSN)

VEDAPO: Contract Data(VBELN,VPOSN)

KONA: Rebate Agreements (KNUMA,VKORG,VTWEG,SPART)

VBRL: SD Document: Invoice List(VBELN,POSNR,VBELN_VF,NETWR,KUNAG)

VKDFS: SD Index: Billing Indicator(FKTYP,VBELN,FKART,VKORG)

VBSK: Collective Processing for a Sales Document Header(SAMMG,SMART)

VBSS: Collective Processing: Sales Documents(SAMMG,VBELN,SORTF)

VRKPA: Sales Index: Bills by Partner Functions(VBELN,BELNR,KUNDE,PARVW)

VRPMA: SD Index: Billing Items per Material(MATNR,VBELN,BELNR,KUNNR)

TVLKT: Delivery Type: Texts(LFART,VTEXT)

KNA1: Customer Master-General(KUNNR,NAME1,LAND1)

KNB1: Customer Master(Company Code)(KUNNR,BUKRS,PERNR)

KNC1: Customer Master Data (Transaction Figures)(KUNNR,BUKRS,GJAHR)

KNVK: Customer Master Contact Partner(PARNR,KUNNR,NAME1)

KNVV: Customer Master sales data(KUNNR,VKORG,VTWEG,KDGRP)

KNBK: Customer Bank Details(KUNNR,BANKS,BANKL,BANKN)

KNVH: Customer Hierarchy (HITYP,KUNNR,VKORG,VTWEG,SPART)

KNVP: Customer Master Partner Functions(KUNNR,PARVW,KUNN2)

KNVS: Customer Shipment data(KUNNR,VSTEL,TRANS)

KNVI: Customer Tax data(KUNNR,ALAND,TATYP)

LFA1: Vendor Master-General (LIFNR,NAME1,ORT01)

LFB1: Vendor Master(Company Code)(LIFNR,BUKRS,PERNR)

LFC1: Vendor Master (Transaction Figures)(LIFNR,BUKRS,GJAHR)

MARA: Material Master-General (MATNR,MTART,MATKL)

MARC: Material Master-Plant data(MATNR,WERKS,EKGRP)

MARD: Material Master- St.Location Data(MATNR,WERKS,LGORT,LABST)

EBEW: Sales Order Stock Valuation(MATNR,VBELN,BWKEY,BWTAR)

TVKO: Sales Organizations(VKORG)

TVTW: Distribution Channel(VTWEG)

TSPA: Divisions(SPART)

TVKOV: Distribution Channels for S.Orgn(VKORG,VTWEG)

TVKOS: Divisions for S.Orgn(VKORG,SPART)

TVTA: Sales Areas(VKORG,VTWEG,SPART)

TVBUR: Sales Offices(VKBUR,ADRNR)

TVKBT: Sales Office Texts(VKBUR,SPRAS,BEZEI)

TVKBZ: Sales Office Assign.to Sales Area(VKORG,VTWEG,VKBUR)

TVKGR: Sales Group(VKGRP)

TVGRT: Sales Group Texts(VKGRP,SPRAS,BEZEI)

TVBVK: Sales Group to Sales office(VKBUR,VKGRP)

TVKWZ: Plants Assign.to S.Orgn(WERKS,VKORG)

T171T: Sales District Texts(BZIRK,BZTXT,SPRAS)

TVLA: Loading Points(LSTEL)

TVST: Shipping Points (VSTEL)

TVSWZ: Shipping Point to Plant(VSTEL,WERKS)

TVPT: Item Categories (PSTYV)

TINC: Customer Incoterms(INCO1)

T077D: Customer Account Group (KTOKD)

T001W: Plants (WERKS)

T001L: Storage Locations (LGORT)

T499S: Locations(WERKS,STAND,KTEXT)

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

TVAK: Sales Document (Order) Types (AUART)

TVAU: Sales Documents: Order Reasons (AUGRU)

TVFK: Billing Document Types (FKART)

TVLK: Delivery Types(LFART)

TVSB: Shipping Conditions (VSBED)

TTDS: Transportation Points(TPLST)

TVKT: Account Assignment Groups (KTGRD)

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

ADRC: To get Addresses of Partners(ADDRNUMBER,NAME1)

VBBE: Sales Requirements: Individual records(VBELN,POSNR,MATNR)

VBBS: Sales Requirement totals Record(MATNR,WERKS,LGORT,CHARG)

VBKA: Sales Activities Data(VBELN,KTAAR)

VBPV: Sales Document Product Proposal(VTWEG,MATNR,KUNNR,CHARG)

T682: Access Sequences (KOZGF)

T682T: Access Sequence Texts (KOZGF,VTXTM)

T683: Pricing Procedures (KALSM)

T683T: Pricing Procedures Texts(KALSM,KAPPL,SPRAS,VTEXT)

T685: Pricing Condition Types (KSCHL)

T685T: Condition Type Texts(KSCHL,SPRAS,KAPPL,VTEXT)

KONH: Conditions (Header)(KNUMH,KAPPL,KSCHL)

KONP: Conditions (Item)(KNUMH,KOPOS,KAPPL,KSCHL)

KONV: Conditions (Transaction Data)(KNUMV,KSCHL,KBERT,KWERT)

KOND: Conditions (KNUMD,ZUSKO,KSCHL)

MATERIAL MANAGEMENT MODULE: (MM)

Cycle:

Purchase Requisition->Request for Quotation(RFQ)->(Vendor Evaluation)->Purchase Order(PO)->Goods Receipt Note(GRN)->Invoice Verification->Data to FI

TABLES and Important Fields:

LFA1--Vendor Master-General (LIFNR,NAME1,ORT01)

LFB1--Vendor Master(Company Code)(LIFNR,BUKRS,PERNR)

LFC1--Vendor Master (Transaction Figures)(LIFNR,BUKRS,GJAHR)

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

MARA--Material Master-General (MATNR,MTART,MATKL)

MARC--Material Master-Plant data(MATNR,WERKS,EKGRP)

MARD--Material Master- St.Location Data(MATNR,WERKS,LGORT,LABST)

MAKT--Material Descriptions(MATNR,MATKL,MAKTX)

MBEW--Material Valuation Data(MATNR,BWTAR)

MVKE—-Material Master: Sales related Data(MATNR,VKORG,VTWEG)

MDKP--MRP related data(Header)(DTART,MATNR,PLWRK,PLSCN)

MDTB—-MRP Table(DTNAM,DTPOS,PLANR)

MCHA--Batches (MATNR,WERKS,CHARG)

MCHB—-Batch Stocks(MATNR,WERKS,LGORT,CHARG)

EBAN-- Pur.Reqn. Data (BANFN,BNFPO,BADAT,MATNR)

EBKN-- Purchase Requisition Account Assignment(BANFN,BNFPO,VBELN)

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

EINE-- Purchase Info.Record (Pur.Orgn Data )(INFNR,EKORG)

ELBK-- Vendor Evaluation Header Data(LIFNR,EKORG,KLASS)

ELBM-- Vendor Evaluation: Material-Related Item(LIFNR,MATNR,EKORG,INFNR,HKRIT)

ELBP—- Main Criteria for Vendor Evaluation (LIFNR,EKORG,HKRIT)

EKKO-- Purchase Order Data (Header)(EBELN,BSTYP,BSART)

EKPO-- Purchase Order Data (Item)(EBELN,EBELP,MATNR)

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)

ESLH--Service Package Header Data (PACKNO,EBELN,VBELN)

ESLL--Lines of Service Package (PACKNO)

ESUH--Ext. Services Management: Unpl.Service Limits: Header Data(PACKNO)

ESKN--Account Assignment in Service Package(PACKNO)

EKKN--Account Assignment in Purchasing Document(EBELN,EBELP,VBELN)

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)

T001W-- Plants (WERKS)

T001L-- Storage Locations (LGORT)

T300—- Warehouse Numbers(LGNUM)

T301—- Storage Types(LGNUM,LGTYP)

T320—- Assign. Stor.Locn to WM Warehouse(WERKS,LGORT,LGNUM)

T163F--Confirmation Texts(EBTYP,EBTXT)

T156-- Movement Types(BWART)

T024-- Purchasing Groups(EKGRP,EKNAM)

T024E--Purchase Organizations(EKORG,BUKRS)

T024W--Plants Assign.to P.Orgn(WERKS,EKORG)

T161-- Purchasing Document Types(BSTYP,BSART)

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

T149D--Valuation Types(BWTAR)

T134-- Material Types(MTART)

T179—- Material Product Hierarchies(PRODH)

T179T—-Material Product Hierarchies: Texts(PRODH,SPRAS,VTEXT)

TJ02T—-System status texts(ISTAT,SPRAS,TXT30)

STKO-- BOM(Bill of Material)(Header)( STLTY,STLNR,STLAL)

STPO—- BOM(Bill of Material)(Item)( STLTY,STLNR,STLKN,STPOZ)

STPU-- BOM Sub-Item (STLTY,STLNR,STLKN)

STPN-- BOM Follow-Up Control (STLTY,STLNR,MATNR)

STST-- Standard BOM Link (STOBJ,STLNR,STLAN,STLAL)

STZU—- Permanent BOM data( STLTY,STLNR,STLAN,ALTST)

RKPF-- Document Header: Reservation(RSNUM,BWART,ANLN1,KOSTL)

RBKP-- Document Header: Invoice Receipt(BELNR,BLART,GJAHR,BUDAT)

RSEG-- Document Item: Incoming Invoice(BELNR,BUZEI,EBELN,MATNR)

Reward if useful.

Re: SD MM Table

Former Member — Thu, 31 Jan 2008 07:57:22 GMT

HI,

SD tables

http://www.erpgenie.com/abap/tables_sd.htm

MM tables

http://www.erpgenie.com/abap/tables_mm.htm

these are links

actually u can search by using google all these things

plzz reward if it is useful.

Re: SD MM Table

Former Member — Thu, 31 Jan 2008 07:58:27 GMT

Hi,

SD tables

http://www.erpgenie.com/abap/tables_sd.htm

MM tables

http://www.erpgenie.com/abap/tables_mm.htm

PLzz reward points if it helps.

topic Re: SD MM Table in Application Development and Automation Discussions

SD MM Table

Re: SD MM Table

Re: SD MM Table

Re: SD MM Table

Re: SD MM Table