Re: about tables

Former Member — Sun, 19 Aug 2007 10:15:16 GMT

SALES & DISTRIBUTION MODULE RELATED TABLES:

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:

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)

FI/CO Module

TABLES and Important Fields:

T001: Company Codes (BUKRS)

T880: Company Data(RCOMP,NAME1,CNTRY)

T001W: Plants (WERKS)

T001L: Storage Locations (LGORT)

T001K: Assign. Plant(Val.Area) to CC(BUKRS,BWKEY)

T002: Language Keys (SPRAS)

T003: FI Document Types (BLART)

T004: Chart of Accounts (KTOPL)

T005: Country Keys (LAND1)

T006: Basic Unit of Measurements (MSEHI)

T007A: Tax Keys (KALSM,MWSKZ)

T009: Fiscal Year Variants(PERIV)

T077s: Account Groups(GL Accounts)(KTOPL,KTOKS)

T010O: Posting Period Variants(OPVAR)

T010P: Posting Period Variants Names(OPVAR,SPRAS,OPVTX)

T012: House Banks (BUKRS,HBKID,BANKS,BANKL)

T014: Credit Control Areas(KKBER,WAERS)

T247,T015M: Month Names(SPRAS,MNR,KTX)

TCURC: Currencies (WAERS)

TCURR,TCURT,TCURX: Currency related Tables

TKA01: Controlling Areas (KOKRS,BEZEI,KTOPL)

TKA02: Assignment of CC to CCA(BUKRS,KOKRS)

TBSL: Posting Keys (BSCHL,SHKZG,KOART)

TBSLT: Posting Key Texts (BSCHL,SPRAS,LTEXT)

SKA1: G/L Account Master (Chart of Accounts)(KTOPL,SAKNR)

SKB1: G/L account master (Company code)(BUKRS,SAKNR)

SKAT: G/L Account Master-Description (KTOPL,SAKNR,SPRAS,LTEXT)

KNBK: Customer master (bank details)(KUNNR,BANKS,BANKL,BANKN)

LFBK: Vendor master (bank details)(LIFNR,BANKS,BANKL,BANKN)

BKPF: Accounting Doc.Header(BUKRS,GJAHR,BELNR,MONAT)

BSEG: Accounting Doc.Item (Cluster Table)(BUKRS,GJAHR,BELNR,BUZEI)

BSIS: G/L Open Items (BELNR,AUGBL,HKONT,BUZEI,BUKRS,ZUONR,GJAHR)

BSAS: G/L Closed Items(BELNR,AUGBL,HKONT,BUZEI,BUKRS,GJAHR,ZUONR)

BSID: Customer Open Items(A/Receivables)(BELNR,AUGBL,KUNNR,VBELN)

BSAD: Customer Closed Items(A/Receivables)(BELNR,AUGBL,KUNNR,VBELN)

BSIK: Vendor Open Items(A/Payables)(BELNR,AUGBL,LIFNR,EBELN)

BSAK: Vendor Open Items(A/Payables)(BELNR,AUGBL,LIFNR,EBELN)

BKPF and BSEG tables Consists of data from BSIS,BSAS,BSID,

BSAD,BSIK and BSAK tables.

BSET: Tax Information Data (BELNR,BUZEI,HKONT,MWSKZ)

BSEC: One time Vendor records(BELNR,BUZEI,BUKRS,NAME1)

CSKS: Cost Center Master(KOKRS,KOSTL,BUKRS,GSBER,PRCTR)

CSKT: Cost Center Texts (KOSTL,KOKRS,SPRAS,LTEXT)

CSSK: Cost Center/Cost Element relations(KOKRS,KOSTL,KSTAR)

GLT0: G/L account master-Ledger(RLDNR,RACCT,BUKRS,RVERS,RBUSA)

GLTPC: Profit Center Accounting(RLDNR,RACCT,BUKRS,RVERS,PRCTR)

GLPCA: EC-PCA: Actual Line Items(RLDNR,RACCT,KOSTL,KOKRS,RPRCTR)

GLPCT: EC-PCA: Totals Table(RLDNR,RACCT,RPRCTR,TSLXX,HSLXX,KSLXX)

COEP: CO Object Line Items by period(KOKRS,BELNR,BUZEI)

COST: CO Object Price Totals(LEDNR,OBJNR,GJAHR,TKGXXX)

CSSL: Cost Center-Activity Type(KOKRS,KOSTL,LSTAR,GJAHR)

CRCO: Work Center-Cost Center Assignment(OBJID,KOSTL,LSTAR)

CSLA: Activity Types Master(KOKRS,LSTAR,DATBI,LATYP)

CSKB: COST Elements(KSTAR,KOKRS,KATYP)

COSS: Cost Totals (OBJNR,GJAHR,KSTAR)

CEPC: Profit Center Master Data(PRCTR,DATBI,KOKRS)

BNKA: Master Record of Banks(BANKS,BANKL,BANKA)

KEKO: Product Costing Header data(KALKA,KALNR,KADKY,MATNR)

ANLH: Main Asset Number(BUKRS,ANLN1)

ANLA: Asset Master Record Segment(BUKRS,ANLN1,ANLN2)

ANLB: Depreciation terms(BUKRS,ANLN1,ANLN2,AFABE)

ANLC: Asset Value Fields(BUKRS,ANLN1,ANLN2,AFABE)

ANEK: Document Header Asset Posting(BUKRS,ANLN1,ANLN2,GJAHR)

ANKT: Asset classes: Description(SPRAS,ANLKL,TXT50)

PP & PM Module

AFKO: PP Order Header Data(AUFNR)

AFPO: PP Order Item data(AUFNR,POSNR,PROJN)

AUFK: Order Master data(AUFNR,AUART,BUKRS,GSBER,WERKS)

AFIH: Maintenance Order Header(AUFNR,EQUNR,ILOAN)

AUFM: Goods Movement for Order(MBLNR,MJAHR,ZEILE,MATNR)

AFVV: Order Operations data Qty/Date/Values(AUFPL,APLZL)

AFVC: Operations within an Order(AUFPL,APLZL,VORNR)

AFRU: Order Completion Confirmation(RUECK,

COKL: CO data- Activity Types(LEDNR,OBJNR,GJAHR,VERSN)

CSLA: Activity Types Master(KOKRS,LSTAR,DATBI,LATYP)

CSLT: Activity types Texts(SPRAS,KOKRS,LSTAR,LTEXT)

KAKO: Capacity Header Segment(KAPID)

CRHD: Work Center Header data(OBJID,ARBPL)

EQUI: Equipment Master data(EQUNR,EQTYP,WERK,MATNR)

EQKT: Equipment Texts(EQUNR,SPRAS,EQKTX)

EQST: Equipment to BOM Link(EQUNR,WERKS,STLNR,STLAN)

ILOA: PM Object Location(ILOAN,SWERK,BEBER,KOSTL)

T024D: MRP controllers (WERKS,DISPO)

T024I: Maintenance Planner groups(IWERK,INGRP,INNAM)

T357: Plant Section(WERKS,BEBER)

T390: PM: Shop papers for print control(PM_APPL)

IFLO: Functional Location Text(TPLNR,SPRAS,PLTXT)

IHSG: Permits in PM(OBJNR,COUNTER)

IHGNS: Permit segment in PM(OBJNR,COUNTER)

T357G_T: Permit text(PMSOG,SPRAS,GNTXT)

RESB: Reservation/Dependent requirement(RSNUM,RSPOS)

V_EQUI: View for Equipment& Fun.Locn(EQUNR,TPLNR,EQKTU)

VIAUFKS: PM Order Selection (AUFNR,EQUNR,IWERK,GEWRK)

CAUFV: Order Header PP/CO(AUFNR,AUART,GSBER,KOKRS)

VIQMEL: Notification Header View(QMNUM,ILOAN,EQUNR)

VIQMFEL:PM Notification View(QMNUM,FENUM,FEGRP,FECOD)

VIQMMA: Notification: Activities(QMNUM,FENUM,MNGRP,MNCOD)

VIQMSM: Notification - Tasks(QMNUM,MNGRP,MNCOD)

PRPS: WBS Element Master data(PSPNR,POSID,OBJNR)

PROJ: Project Definition(PSPNR,PSPID,OBJNR)

PRTE: Scheduling Data for Project Items(POSNR,PSPHI)

PRHIS: Standard WBS, Edges(Hierarchy Pointers)(POSNR,PSPHI)

KLAH: Class Header data(CLINT,KLART,CLASS)

KSSK: Allocation Table: Object to Class(OBJEK,KLART,CLASS)

KSML: Characteristics of a Class(CLINT,KLART,POSNR)

CABN: Characteristics(ATINN,ADZHL,ATNAM)

CAWN: Characteristic values(ATINN,ADZHL,ATZHL)

AUSP: Characteristic Values(OBJEK,ATINN,KLART,ATZHL)

COBRB: Distribution Rules Settlement Rule Order Settlement(OBJNR,BUREG)

IMPR: Investment Program Positions(POSNR,POSID,PRNAM,OBJNR)

IMPU: Texts for cap. inv. program positions(POSNR,POST1,SPRAS)

IMTP: Investment programs(PRNAM,GJAHR,PRART)

IMTT: Capital Investment Program Texts(PRNAM,POST1,SPRAS)

IMZO: Assign.Table:CO Object-Capital Inv.Prog.Pos.(POSNR,OBJNR,IPPOS)

<b>Reward points for useful Answers</b>

Regards

Anji

topic Re: about tables in Application Development and Automation Discussions

about tables

Re: about tables

Re: about tables

Re: about tables