sap ecc table by application

7/28/2019 SAP ECC Table by Application

1/5

About

SAP-related Resources and Web Sites

ECC Tables:

MM MODULE

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

Tables and important Fields.

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 DataEKKO 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 FMKPF 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 weuse 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 l ines data of a PO(EBELN, EINDT, SLFDT)

Careers at Detering

Submit Resume

ECC Table by Application http://deteringconsulting.com/about/SAPECCTablebyApplic

25/06/2013


2/5

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

T163F Confirmation Texts (EBTYP, EBTXT)T156 Movement Types (BWARE)T024 Purchasing GroupsT024E Purchase OrganizationsT163 Item Categorys in Purchasing Documents(PSTYP)T149D Valuation TypesT134 Material Types

FVLK Delivery TypesSTKO, STPO BOM(Bill Of Material) related Data (Header & Item)

STPU, STPN, STST, STZU BOM Related TablesRKPF, RBKP, RSEG (Header & Item) MM FI Related DataKONO, KONH Pricing dataT006 Basic Unit Of Measurements

SALES & DISTRIBUTION MODULE RELATED TABLES :

Cycle:Enquiry Quotation Sales Order Delivery(Picking, Packing, Post GoodsIssue 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, forQuotation 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, butwe use thefollowing 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 Partners 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)


25/06/2013


3/5

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) TypesKONV: Condition Types (pricing) (KNUMV, KSCHL, KWETR)T685T: Condition Types Texts.ADRC: To get Addresses of Partners

VBBE, VBBS: Sales Requirements DataVBKA: Sales Activities Data

VBPV: Sales Document Product Proposal

PP & PM Module

AFKO: PP Order Header DataAFPO: PP Order Item DataAFVV: Order Operations Data Qty/Date/ValuesAFVC: Operations within an OrderAFRU: Order Completion ConfirmationCSLA: Activity Types Master DataCSLT: Activity Types TextsKAKO: Capacity Header SegmentCRHD: Work Center Header DataAUFK: Order Master Data

AFIH: Maintenance Order HeaderAUFM: Goods Movement For OrderEQUI: Equipment Master DataEQKT: Equipment TextsILOA: PM Object LocationT024I: Maintenance Planner GroupsT357: Plant SectionIFLO: Functional Location TextIHSG: Permits in PMIHGNS: Permit segment in PMT357G_T: Permit TextRESB: Reservation / Dependent requirementV_EQUI: View for Equipment descriptionVIAUFKS: View for Order and Equipment Data

CAVFVD: Work Center Text.VIQMEL: Notification Header ViewVIQMFEL: PM Notification ViewVIQMMA, VIQMSM : Views for Activities and Tasks

FI/CO Module

T001: Company CodesT002: Language KeysT003: FI Document Types

T004: Chart Of AccountsT005: Country KeysT007A: Tax Keys

T012: House BanksTKA01: Controlling AreasSKA1, SKB1: G/L Account Master dataSKAT : G/L Accounts Texts

KNBK: Customer Master(Bank Details)LFBK: Vendor Master (Bank Details)BKPF: Accounting Doc. HeaderBSEG: Accounting Doc. Item(Cluster Table)

BSIS: G/L Open ItemsBSAS: G/L Closed ItemsBSID: Customer Open Items(Account Receivables)BSAD: Customer Closed Items)(Account Receivables)


25/06/2013


4/5

BSIK: Vendor Open Items(Account Payables)

BSAK: Vendor Closed Items(Account Payables)BKPF and BSEG Tables consists of data from BSIS, BSAS, BSID, BSAD, BSIK,and BSAK tables.BSET: Tax InformationBSEC: One Time Vendor RecordsCSKS: Cost Center MasterCSKT: Cost Center Texts

CSSK: Cost Center/ Cost Element RelationsGLPCA: EC-PCA: Actual Line Items

GLPCT: EC-PCA: Totals TableCOEP: Co-Object Line Items by PeriodCOST: Co-Object Price TotalsCSSL: Cost Center- Activity TypeCRCO: Work Center- Cost Center AssignmentCSLA: Activity Types Master(LSTAR)CSKB: Cost Elements(KSTAR, KOKRS)COSS: Cost Totals(OBJNR, KSTAR)COBL: Coding BlockCEPC: Profit Center Master DataBNKA: Master Records of banksTBSL: Posting KeysKEKO: Product Costing Header DataANLH: Main Asset Number

ANLA, ANLB, ANLC : Segment Assets Masters

Home Products & Services Solutions Consulting About Careers Contact Sitemap


25/06/2013


5/5
