User manual SAS FINANCIAL MANAGEMENT ADAPTER 5.1 FOR SAP

[. . . ] SAS Financial Management Adapter 5. 1 for SAP User's Guide ® ® The correct bibliographic citation for this manual is as follows: SAS Institute Inc. SAS Financial Management Adapter 5. 1 for SAP: User's Guide. Cary, NC: SAS Institute Inc. SAS® Financial Management Adapter 5. 1 for SAP: User's Guide Copyright © 2010, SAS Institute Inc. , Cary, NC, USA All rights reserved. Produced in the United States of America. [. . . ] For each table, a mirror SAS table is created in the R3mirror library. Individual extractions are independent of each other. This job extracts the following tables from SAP: T001: Company Codes T002: Language Keys (Component BC - 118) T002T: Language Key Texts T005T: Country Names T011: Financial Statement Versions T011T: Financial Statement Version Names T880: Global Company Data (for KONS Ledger) This job uses the following input tables from the SAP server: T001 T002 T002T T005T T011 Extraction Jobs Job Group: E00 Extraction of T Tables 83 T011T T880 This job creates the following output: Fmsr3mir. T001 Fmsr3mir. T002 Fmsr3mir. T002T Fmsr3mir. T005T Fmsr3mir. T011 Fmsr3mir. T011T Fmsr3mir. T880 fmsadpt_E00011_Create_Formats_from_SAP_FI_Tables Job This job creates formats from the tables that are extracted in the E00010 job. Run this job immediately after the job E00010, so that the formats are as current as the tables on which they are based. This job uses the following input tables from SAS: Fmsr3mir. T001: Company Codes Fmsr3mir. T002: Language Keys Fmsr3mir. T011: Financial Statement Versions This job creates the following output formats: $SAPTOSAS_LANGUAGE $company_to_country $LOCALCR $unassigned_accounts_parent $COMPANY_TO_FY_VARIANT $BUKRS $TRAD_PTNR_TO_BUKRS $COM2CAC fmsadpt_E00020_Extract_SAP_FI_T_Tables Job This job extracts general and financial tables from SAP R/3 that are named with a T prefix. These tables are generally text description tables. Individual extractions are independent of each other. This job extracts the following tables: T8G21: Splitting rule: (Item to be processed) TGSBT: Business Area Names TKA01: Controlling Areas TKA02: Controlling area assignment TKA00: Control parameters for controlling areas 84 Job Group: E00 Extraction of T Tables Chapter 6 This job uses the following input tables from the SAP server: T8G21 TGSBT TKA00 TKA01 TKA02 This job creates the following output: Fmsr3mir. T8G21 Fmsr3mir. TGSBT Fmsr3mir. TKA00 Fmsr3mir. TKA01 Fmsr3mir. TKA02 $CC2CA converts Company Code (BUKRS) to Controlling Area (KOKRS) fmsadpt_E00030_Extract_SAP_Fiscal_Period_T_Tables Job This job extracts financial tables from SAP R/3 that are named with a T009 prefix. This job extracts the following tables: T009: Fiscal Year Variants T009B - Fiscal year variant periods T009C - Period names T009T - Fiscal year variant names This job uses the following input: T009 T009B T009C T009T &lang (set in the preprocessing step) This job creates the following output: Fmsr3mir. T009 Fmsr3mir. T009T Fmsr3mir. T009B Fmsr3mir. T009C fmsadpt_E00031_Create_Formats_from_SAP_Fiscal_Period_Tables This job creates formats from the tables that are extracted in the job E00030. Run this job immediately after the job E00030, so that the formats are as current as the tables on which they are based. This job uses the following input: Fmsr3mir. T009C - Period names Extraction Jobs Job Group: E00 Extraction of T Tables 85 &lang (set in the preprocessing step) This job creates the following output: $PERIOD_DESCRIPTION converts concatenated Fiscal Year Variant (PERIV) and Posting Period (POPER) to Period Name Long Text (LTEXT) $PERIOD_NAME output converts concatenated Fiscal Year Variant (PERIV) and Posting Period (POPER) to Period Name Short Text (KTEXT) fmsadpt_E00040_Extract_Currency_T_Tables Job This job extracts the currency tables from SAP R/3 that are named with a TCUR prefix. This job extracts the following tables: TCURR - Exchange Rates TCURT - Currency Code Names This job uses the following input tables from the SAP server: TCURR TCURT This job creates the following output: Fmsr3mir. TCURR Fmsr3mir. TCURT fmsadpt_E00050_Extract_Account_T_Tables This job extracts general and financial tables from SAP R/3 that are named with a T030 prefix, and are related to accounts. This job extracts the following tables: T030 - Standard Accounts Table T030C - Global Standard Account Table This job uses the following input tables from the SAP server: T030 T030C This job creates the following output: Fmsr3mir. T030 Fmsr3mir. T030C fmsadpt_E00060_Extract_Operating_Concern_T_Tables Job This job extracts operating concern tables from SAP R/3 that are named with a T prefix. This job extracts the following tables: 86 Job Group: E01 Extraction of Master Tables Chapter 6 TKEB - Management for Operating Concerns TKEBT - Description of operating concern This job uses the following input tables from the SAP server: TKEB TKEBT This job creates the following output: Fmsr3mir. TKEB Fmsr3mir. TKEBT fmsadpt_E00070_Extract_Addl_Tables_for_Formats Job This job extracts miscellaneous tables from SAP R/3 that are required for formats, and have not already been extracted. This job extracts the table DD07T ­ DD (Domain Fixed Values (Language Dependent) Texts. ) This job uses the following input: DD07T from the SAP server &lang (set in the preprocessing step) This job creates the following output: Fmsr3mir. DD07T $SHKZG uses Fmsr3mir. DD07T to create the format $SHKZG. It converts single value or lower limit (DOMVALUE_L) to short text for fixed values (DDTEXT). $SHKZG is stored in the LIBRARY. FMT&LANG catalog, which is language dependent. fmsadpt_E00080_Extract_New_GL_Control_Table Job This job extracts the new GL Control table from SAP ECC. This job extracts the following table: FAGL_ACTIVEC - Activation of New General Ledger This job uses the following input table from the SAP server: FAGL_ACTIVEC This job creates the following output: Fmsr3mir. FAGL_ACTIVEC Extraction Jobs Job Group: E01 Extraction of Master Tables 87 Job Group: E01 Extraction of Master Tables Overview This job group includes common jobs that extract data for SAS Financial Management. fmsadpt_E01000_Extract_SAP_Master_Code_Tables Job This job extracts all required master data tables from SAP R/3. For each table, a mirror SAS table is created in the R3mirror library. This job extracts the following tables: CEPC - Profit Center Master Data Table CSKS - Cost Center Master Data SKA1 - G_L Account Master (Chart of Accounts) KNA1 - General Data in Customer Master LFA1 - Vendor Master (General Section). This job uses the following input tables from the SAP server: CEPC CSKS SKA1 KNA1 LFA1 This job creates the following output: Fmsr3mir. CEPC Fmsr3mir. CSKS Fmsr3mir. SKA1 Fmsr3mir. KNA1 Fmsr3mir. LFA1 fmsadpt_E01010_Extract_SAP_Master_Description_Tables Job This job extracts all required master data description tables from SAP R/3. For each table, a mirror SAS table is created in the R3mirror library. [. . . ] The SAS Financial Management Adapter for SAP might not load the employee dimension table. In the 107910 job, remove the data check against the ITEM_CATEGORY table because the SAS Financial Management Adapter for SAP does not load it. In the 106200 job, remove the data checks against the COUNTY, STATE_REGION, and EMPLOYEE columns. This information is not loaded into the INTERNAL_ORG table. [. . . ]