Archive for ‘ September, 2011 ’

MM and FI connection

Area and Tech Name and Description

Purchasing
EKKO – PO Header
EKPO – PO Item
EBAN – Purchase requisition
EKBE – History per Purchase doc.
EKKN – Account Assignment in Purchasing Document /span>

Accounting
BKPF – Accounting Document Header
BSEG – Accounting Document Segment
CSKS – Cost Center Master Data
PRPS – WBS master data
AUFK – Order master data

CEPC – Profit Center master data
RBSELBEST – PO associated with aparked invoice

Line items (Rep: RPUDRIG0)
COVP – CO Object: Line Items (See FM HRGPBS_DRILL_READ_COVP)
COOI – Commitments Management: Line Items

PPDHD – Transfer to Accounting: Document Header
PPDIT – Transfer to Accounting: Lines in HR IDOCs
(See FM HRGPBS_DRILL_SELECT_POST_LINE)

Order data (Network)
AUFK – Order master data
AFKO – Order header data
AFPO – Order item data

AFVC – Operation within an order
AFVV – quantities/dates/values in the operation

Invoice data
EKKO – PO Header
RSEG – Incoming invoice (Invoice doc, PO doc)
RBKP – Invoice receipt

Project plan/WBS
PROJ – Project data
PRPS – WBS
PRHI – WBS breakdown within project

Sales
VBAK – Header
VBAP – Item
VBPA – Sales Document Partner

Shipment
VTTK – Shipment Header
VTTP – Shipment Item

Delivery
LIKP – Delivery Header
LIPS – Delivery item

Vendor
LFA1 – Vendor Master
LFB1 – Vendor Master (Company Code)

Customer
KNA1 – Customer Master
KNB1 – Customer Master (Company Code)

Material
MARA – Material data
MARC – Material Plant Details

HR
PNP – Get Pernr (Personnel data)
PCH – Get Objec

TEM
TEM table structure

sap mm transaction code (t-code)

List of mm Tcode

Transaction codes for materials

MM01: Create material
MM02: Change material
MM03: Display material

Transaction codes for Reservations

MB21: Create Reservation
MB22: Change Reservation
MB23: Display Reservation
MB25: List of Reservations

Purchasing display transaction codes

ME53: Display purchase requisition
ME23 Display purchase order
ME43: Display RFQ
ME48: Display quotation
ME33K: Display contract
ME33L: Display scheduling agreement
ME13: Display info record
ME03: Display source list
MEQ3: Display quota arrangement
MP02: Display approved manufacturer parts list
ME62: Display vendor evaluation
MN03: Display RFQ message
MN06: Display purchase order message
MN09: Display outline purchase agreement message
MN12: Display scheduling agreement delivery schedule message
MN15: Display service entry sheet message
MN26: Display inbound delivery message
WWNC: Display messages for settlement run
MEB3: Display rebate arrangements
WWSC: Display conditions for subsequent
MEK3: Display conditions in purchasing

Transaction codes for processing RFQ (Request for quotation)

ME41: Create RFQ
ME42: Change RFQ
ME43: Display RFQ
ME44: Maintain RFQ supplement
ME45: Release RFQ

Transaction codes to maintain quotations

ME47: Enter quotation
ME48: Display quotation
ME49: Quotation price comparison list

Transaction codes to process a purchase requisition

ME51N: Create purchase requisition
ME52N: Change purchase requisition
ME53N: Display purchase requisition

Transaction codes to release Purchase Requisitions

ME54: Individual release for purchase requisitions
ME55: Individual release for purchase requisitions
ME5F: Release reminder for purchase requisitions

Transaction codes to process Purchase Orders

ME21N: Create purchase order
ME25: Create purchase order – vendor unknown
ME22N: Change purchase order
ME23N: Display purchase order
ME56: Assign source to purchase requisition
ME57: Assign and process purchase requisitions
ME58: Order for assigned purchase requisitions
ME59: Generate purchase orders from requisitions automatically
ME24: Maintain PO supplement
ME28: Release purchase order

Transaction codes to process a purchasing info record

ME11: Create purchasing info record
ME12: Change purchasing info record
ME13: Display purchasing info record
ME14: Display changes to purchasing info record
ME15: Flag purchasing info record for deletion

Transaction codes to process physical inventory documents.

MI01: Create Physical Inventory Document
MI02: Change Physical Inventory Document
MI03: Display Physical Inventory Document
MI21: Print Physical Inventory Document
MI07: Process List of Differences
MI08: Create List of Differences with Document
MI10: Create List of Differences without Document
MI20: Print List of Differences
MI11: Recount Physical Inventory Document

Transaction cods for Physical Inventory

MI01: Create Physical Inventory Document
MI02: Change Physical Inventory Document
MI03: Display Physical Inventory Document
MI21: Print Physical Inventory Document
MI07: Process List of Differences
MI08: Create List of Differences with Document
MI10: Create List of Differences without Document
MI20: Print List of Differences
MI11: Recount Physical Inventory Document
MI22: Display Physical Inventory Documents for Material.
MI23: Display Physical Inventory Data for Material.
MIDO: Display Changes.
MI24: Physical Inventory List.
MIAL: Read Physical Inventory Document Archive.
MI04: Enter Physical Inventory Count with Document
MI09: Enter Physical Inventory Count without Document
MI05: Change Physical Inventory Count
MI06: Display Physical Inventory Count

Transaction codes to process a purchase contract

ME31K: Create contract
ME32K: Change contract
ME33K: Display contract
ME34K: Maintain contract supplement
ME3P: Recalculate contract prices
MLRP: Periodic invoicing plans

Vendor Evaluation transaction codes

ME61: Maintain vendor evaluation
ME62: Display vendor evaluation
ME63: Re-evaluate automatic sub criteria
ME6A: Display changes to vendor evaluation
ME6F: Print evaluation sheet
ME6G: Vendor evaluation in the background

Transaction codes for Scheduling Agreements

ME31L: Create scheduling agreement
ME37: Create stock transport scheduling agreement
ME32L: Change scheduling agreement
ME33L: Display scheduling agreement
ME34L: Maintain scheduling agreement supplement
ME3R: Recalculate scheduling agreement prices
ME85: Re-number schedule lines
ME86: Aggregate schedule lines
ME87: Aggregate PO history
ME88: Reset agreed cumulative quantity and reconciliation date

SAP Crystal Reports Tutorials

SAP Crystal Reports software enables you to easily design interactive reports and connect them to virtually any data source. Your users can benefit from on-report sorting and filtering – giving them the power to execute decisions instantly.

And with SAP Crystal Reports Dashboard Design package, you can gain even more functionality for compelling reports. This bundled product includes SAP Crystal Reports and SAP Crystal Dashboard Design ( formerly known as Xcelsius Engage), giving you the power to create highly formatted reports with what-if scenario models, interactive charts – and deliver them via the Web, e-mail, Microsoft Office, Adobe PDF, or embedded in enterprise applications. As a result, you can leverage your reports to make better operational and strategic decisions.

With SAP Crystal Reports, you can:

  • Leverage professional reporting – priced for everyone
  • Empower end users to explore reports with on-report sorting and parameters
  • Minimize IT and developer effort with interactive reports
  • Develop powerful data mashups
  • Save valuable report design time
  • Embed professional-looking reports in Java and .NET applications
  • Tailor your solution by adding report management and viewing tools

To Download the Tutorials Please the link below:

—>>>>>>>> Crystal Report toturial

 

crystal report limit records Query

To make it show 5 records per page do the following

1. Open the report in Design View

2. Right click on the Details section and select Section Expert

3. Make sure the Details section is selected in the Section Expert dialog box. Check the box that says “New Page After”

4. Click the formula editor button to the right of the checkbox.

5. Enter the following formula

if Remainder (RecordNumber, 5) = 0 then true else false

6. Click Save and Close and then click OK.

If you run the report it should break after each 5 rows.

 

FI/CO Tables

T001: Company Codes
T002: Language Keys
T003: FI Document Types
T004: Chart Of Accounts
T005: Country Keys
T007A: Tax Keys
T012: House Banks
TKA01: Controlling Areas
SKA1, SKB1: G/L Account Master data
SKAT : G/L Accounts Texts
KNBK: Customer Master(Bank Details)
LFBK: Vendor Master (Bank Details)
BKPF: Accounting Doc. Header
BSEG: Accounting Doc. Item(Cluster Table)
BSIS: G/L Open Items
BSAS: G/L Closed Items
BSID: Customer Open Items(Account Receivables)
BSAD: Customer Closed Items)(Account Receivables)
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 Information
BSEC: One Time Vendor Records
CSKS: Cost Center Master
CSKT: Cost Center Texts
CSSK: Cost Center/ Cost Element Relations
GLPCA: EC-PCA: Actual Line Items
GLPCT: EC-PCA: Totals Table
COEP: Co-Object Line Items by Period
COST: Co-Object Price Totals
CSSL: Cost Center- Activity Type
CRCO: Work Center- Cost Center Assignment
CSLA: Activity Types Master(LSTAR)
CSKB: Cost Elements(KSTAR, KOKRS)
COSS: Cost Totals(OBJNR, KSTAR)
COBL: Coding Block
CEPC: Profit Center Master Data
BNKA: Master Records of banks
TBSL: Posting Keys
KEKO: Product Costing Header Data
ANLH: Main Asset Number
ANLA, ANLB, ANLC : Segment Assets Masters

PP & PM Tables

AFKO: PP Order Header Data
AFPO: PP Order Item Data
AFVV: Order Operations Data Qty/Date/Values
AFVC: Operations within an Order
AFRU: Order Completion Confirmation
CSLA: Activity Types Master Data
CSLT: Activity Types Texts
KAKO: Capacity Header Segment
CRHD: Work Center Header Data
AUFK: Order Master Data
AFIH: Maintenance Order Header
AUFM: Goods Movement For Order
EQUI: Equipment Master Data
EQKT: Equipment Texts
ILOA: PM Object Location
T024I: Maintenance Planner Groups
T357: Plant Section
IFLO: Functional Location Text
IHSG: Permits in PM
IHGNS: Permit segment in PM
T357G_T: Permit Text
RESB: Reservation / Dependent requirement
V_EQUI: View for Equipment description
VIAUFKS: View for Order and Equipment Data
CAVFVD: Work Center Text.
VIQMEL: Notification Header View
VIQMFEL: PM Notification View
VIQMMA, VIQMSM : Views for Activities and Tasks

SALES & DISTRIBUTION 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, 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’, but we use the
following 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 Partner’s 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)
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) Types
KONV: Condition Types (pricing) (KNUMV, KSCHL, KWETR)
T685T: Condition Types Texts.
ADRC: To get Addresses of Partners
VBBE, VBBS: Sales Requirements Data
VBKA: Sales Activities Data
VBPV: Sales Document Product Proposal

 

Material Management Tables(MM)

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 Data
EKKO – 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 ‘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)
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)
T163F – Confirmation Texts (EBTYP, EBTXT)
T156 – Movement Types (BWARE)
T024 – Purchasing Groups
T024E – Purchase Organizations
T163 – Item Category’s in Purchasing Documents(PSTYP)
T149D – Valuation Types
T134 – Material Types
FVLK – Delivery Types
STKO, STPO – BOM(Bill Of Material) related Data (Header & Item)
STPU, STPN, STST, STZU – BOM Related Tables
RKPF, RBKP, RSEG (Header & Item) – MM – FI Related Data
KONO, KONH – Pricing data
T006 – Basic Unit Of Measurements

 

INFORMATION