Posts

Featured Post

SAP-BI@ExtractionMethod-CO-PA Extraction

CO-PA Extraction
----------------
Introduction:-
--------------
1) CO-PA stands for Controlling - Profitablility analysis.
2) We can do Planning in CO-PA. So we will 2 types of transactions in CO-PA a) Actual and b)Plan.
3) Value type :- is used as indicatore for Actual/Plan.
4) Actual transaction is more detailed and Plan transaction is more Aggregated.
5) Planning can be in multiple versions.(Version)
6) In BW we do 0Vtype reporting on CO-PA Cube.
7) Co-PA is an Integration Module.
8) Each actual transaction is stored in 3 different curriencies.ex:- Company code Currency,Transaction currency,Operating Concern currecy.
9) Currecncy Type :- Used as indicator of the currency.
10) CO-PA comes as part of customer generated extractors.
11) CO-PA datasource is generated based on Operating Concern.
12) Operating Concern is the top most Legal entity for controlling which will have its own Data structure with Value fields and Charcteristic fields.
13) CE1xxxx - Actual Line Item table
    CE2…

SAP purchase order Tcodes

ME21N - Create purchase order MM - Purchasing
ME22N - Change purchase order MM - Purchasing
ME23N - Display purchase order MM - Purchasing
ME21 - Create purchase order MM - Purchasing
ME2N - purchase orders by PO Number MM - Purchasing
ME9F - Message Output: purchase orders MM - Purchasing
ME29N - Release purchase order MM - Purchasing
ME2L - purchase orders by Vendor MM - Purchasing
ME2M - purchase orders by Material MM - Purchasing
SPRO - Customizing - Edit Project Basis - Customizing Project Management (IMG)
MIGO - Goods Movement MM - Inventory Management
MIRO - Enter Incoming Invoice MM - Invoice Verification
MD04 - Display Stock/Requirements Situation PP - Master Data
NACE - WFMC: Initial Customizing Screen SD - Output Determination
ME51N - Create purchase Requisition MM - Purchasing
ME52N - Change purchase Requisition MM - Purchasing
ME53N - Display purchase Requisition MM - Purchasing
VA01 - Create Sales order SD - Sales
VA02 - Change Sales order SD - Sales
MMBE - Stock Overvi…

SAP BW Modelling-Quick Notes

sap bw/biw/biversions-----sap bw...1.x/2.0b/3/0a/3.0b/3.1c/3.5/////7.03.x-bw/biw7.0---sap business intelligencesap bw--bi?---role?-----ETL/ANALSYSoltp----online trnsaction processing sys---operational sysDATA BASE(ORACLE/DB2)//SAP ERP///XML//FILEOLTP(BDATA)------10 TO THE 18 GB----------DATAWAREHOUSEOLTP(BDATA)------STAGE THE DATA (ETL)--------ETL---EXTRACTION/TRANSFORMATION AND DATA LOADINGOLTP--------DW(BDATA)-----------ANALYSYS:MDIM REPORTSEMP--SALESCOUNTRY/REG/ORG/EMP/PRD/GRP---------SALES/REV/COST/OPERATING MARGINDATA ANALYSYS---REPORTS---------DW--MDIM REPORTS---OLAP SYS(BI TOOLS)OLAP(BI TOOLS)---MDIM REPORTSETL----BI----SAP BW///OTHER DWOTHER DW----ETL---INFORMATICA/DATA STAGE----CLIENT HAS TO PAY FOR ETLOLTP(BD)----ETL------------DW(DB)-----BI TOOL-MDIM REPORTSBI TOOL----COGNOS BI/HYPERION ESSBASE/BUSINESS OBJECTSSAP BW-----ETL ------EXTRACTORS----FILE-----FILE EXTRACTOR/DB---DB EXTRACTORS///SAP --SAP EXTRACTORS/XML----XML EXTARCTORSSAP BW---DBSAP DB---MAX DBBI TOOL----------…