Skip to Content
author's profile photo Former Member
Former Member

Which are the tables used for bdc, and some other questions?

1.Which are the tables used for bdc, and some other questions?,

2. in which table does the runtime data or while runtime does the internal table data stored,

3. tables and fields common in SD and MM modules used for ABAPERs?

4. can any one name some BAPI's?

Thank you,

Regards,

Jagrut Bharatkumar Shukla

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    Posted on Nov 30, 2007 at 09:41 AM
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 30, 2007 at 09:40 AM

    hi

    see the SD and MM related tables

    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)

    BAPI

    list of all bapis

    http://www.planetsap.com/LIST_ALL_BAPIs.htm

    Regards

    Anji

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 30, 2007 at 09:43 AM

    Hi,

    1>Tables are BDCMSGCOLL,BDCDATA,RSPARAMS.

    3>Check the belwo link

    http://www.sap-img.com/sap-sd/link-between-sap-sd-mm-and-fi.htm

    4>BAPI_PO_CREATE1,

    BAPI_SALESORDER_CREATEFROMDAT2

    Regards,

    nagaraj

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.