User manual BUSINESS OBJECTS PURCHASING RAPID MART XI 3.2 FOR SAP SOLUTIONS 12.2.0.0

[. . . ] SAP BusinessObjects Purchasing Rapid Mart XI 3. 2, version for SAP solutions User Guide Version 12. 2. 0. 0 October 2009 Copyright © Copyright 2009 SAP AG. No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP AG. Some software products marketed by SAP AG and its distributors contain proprietary software components of other software vendors. Trademarks All rights reserved. SAP, R/3, SAP NetWeaver, Duet, PartnerEdge, ByDesign, SAP Business ByDesign, and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP AG in Germany and other countries. [. . . ] Contains the following sub-classes related to the valuation of various monetary currencies: Currency Sources Currency Sources for 2nd and 3rd Local Currencies. The Currency source indicates which currency was used as a source for the 2nd or 3rd Local currency. The exchange rate is determined from this source currency to the 2nd or 3rd local currency. Standard Values: · · 1 = Translation taking first local currency as basis, i. e. , the main Local Currency or Company Code Currency was used as the currency source. 2 = Translation taking transaction (or document) currency as basis. Currency Types Currency Types for 2nd and 3rd Local Currencies. In addition to the local currency as house currency, you can manage parallel currencies with the following currency types: SAP BusinessObjects Purchasing Rapid Mart XI 3. 2 for SAP solutions User Guide 195 5 Universe SAP Master Data Universe · · · · Group currency Hard currency Index currency Global company currency Monetary Currencies The Rapid Marts maintain various currencies, including: · · · Benefit Currency - The monetary currency associated with personnel administration. Controlling Area Currency - The monetary currency assigned to the controlling area Group Currency - Group currency is used in the consolidated financial statements. Before the consolidation process can be completed all values in the individual financial statements must be translated from the local or transaction currency into group currency. Local (Company Code) Currency - The monetary currency assigned to the company code Transaction (Document) Currency - The monetary currency of each individual transaction document. Update Currency - Used for Euro conversion in European Union: The update currency is the currency, in addition to the local (company) currency, in which the transaction figures are updated in the general ledger. You specify whether the document or account currencies should also be the update currency in the G/L account master record. · · · Monetary Exchange Rates These are the conversion rates used to convert one currency to another. They are used to compute global currency amounts in the universe. MRP Material Resource Planning - A term for procedures in requirements planning that take into account and plan every future requirement during the creation of order proposals such as independent requirements, and dependent requirements. Contains the following sub-classes: Mrp Controller The person responsible for a group of materials in MRP in a plant or company. Material that takes part in material requirements planning must be assigned to an MRP controller. 196 SAP BusinessObjects Purchasing Rapid Mart XI 3. 2 for SAP solutions User Guide Universe SAP Master Data Universe 5 Mrp Element Type A term for all objects displayed as items in the MRP list or in the stock and requirements list. Such objects include planned orders, purchase orders, reservations, and sales orders. Mrp Group The MRP group, groups material from the material requirements planning point of view to allocate them control parameters for planning. The control parameters include the strategy group, the planning horizon and the creation indicator for the planning run. Mrp Lot Size A key that defines which lot-sizing procedure the system uses for calculating the quantity to procure in the MRP run. Mrp Profile A collection of data required for updating the material master record for planning. The MRP profile contains the necessary MRP data for the material master. This simplifies updating the material master record. When creating or changing a material master, the data in the MRP profile is copied automatically to the material master. The MRP profile defines: · · · Which fields are mandatory when entering MRP data Values of these fields Which values can be overwritten (default values) or not (fixed values) Mrp Type A key that controls the MRP procedure (MRP or reorder point) used for planning a material. [. . . ] Only Line Item 1 carries the value; the rest of lines are set to 0 Use for aggregation - Gross invoice amount in document currency. Only Line Item 1 carries the value; the rest of lines are set to 0 DECIMAL 1 0 0 yes 2 48 28 2 yes 3 48 28 2 yes 4 48 28 2 yes 5 DECIMAL 48 28 2 yes 6 AMT_INV_TAX_LOC Use for Aggregation - Tax amount (+/-) in Local currency. Only Line Item 1 carries the value; DECIMAL the rest of lines are set to 0 Use for Aggreation - Tax amount (+/-) in document currency. Only Line Item 1 carries the value; the rest of lines are set to 0 Calculated field - Line item invoice amount in Local currency RESG. WRBRW- Line item invoice amount in document currency Calculated field - Cash discount amount in Local currency RBKP. WSKTO - Cash discount amount in document currency Calculated field - Gross invoice amount in Local currency RBKP. RMWWR- Gross invoice amount in document currency Calcluated field - Tax amount (+/-) in Local currency RBKP. WMWST1- Tax amount (+/-) in document currency RSEG. SPGRG- Blocking reason: project budget DECIMAL 48 28 2 yes 7 AMT_INV_TAX_TRX 48 28 2 yes 8 AMT_LOC DECIMAL 48 28 2 yes 9 AMT_TRX DECIMAL 48 28 2 yes 10 AMT_TTL_CASH_DIS CNT_LOC AMT_TTL_CASH_DIS CNT_TRX AMT_TTL_GROSS_LO C AMT_TTL_GROSS_TR X DECIMAL 48 28 2 yes 11 DECIMAL 48 28 2 yes 12 DECIMAL 48 28 2 yes 13 DECIMAL 48 28 2 yes 14 AMT_TTL_TAX_LOC DECIMAL 48 28 2 yes 15 AMT_TTL_TAX_TRX DECIMAL 48 28 2 yes 16 BLOCK_BUDGET_FLA G NVARCSTR 1 0 0 yes Rapid Mart Data Schema 22 Appendix Table Column Details A 17 BLOCK_DATE_FLAG RSEG. SPGRT- Blocking reason: date NVARCSTR 1 0 0 yes 18 BLOCK_MANUAL_FLA G RSEG. SPGRQ-Indicator: manual blocking reason NVARCSTR 1 0 0 yes 19 BLOCK_OTHER_FLAG RSEG. SPGRS-Block. reason: others NVARCSTR 1 0 0 yes 20 BLOCK_PRICE_FLAG RSEG. SPGRP- Blocking reason: price NVARCSTR 1 0 0 yes 21 BLOCK_PRICE_QTY_ FLAG RSEG. SPGRG- Blocking reason: order price quantity NVARCSTR 1 0 0 yes 22 BLOCK_QTY_FLAG RSEG. SPGRM- Blocking reason: quantity NVARCSTR 1 0 0 yes 23 BLOCK_QUALITY_FLA G CASH_DISCNT_PRCN T_01 CASH_DISCNT_PRCN T_02 RSEG. SPGRC- Block. reason: quality NVARCSTR 1 0 0 yes 24 RBKP. ZBD1P - Percentage for first cash discount RBKP. ZBD2P - Percentage for second cash discount DECIMAL 48 5 3 yes 25 DECIMAL 48 5 3 yes 26 CMPNY_CODE_ID PK RBKP. BUKRS- Company code NVARCSTR 4 0 0 yes 27 CONDITN_TYPE_ID PK RSEG. KSCHL - Condition type NVARCSTR 4 0 0 yes 28 CREATE_DATE PK RBKP. CPUDT-Accounting document entry date DATETIME 24 0 9 yes 29 CTRL_AREA_ID PK Lookup on TKA02. KOKRS - Controlling Area NVARCSTR 4 0 0 yes 30 CURR_ID_LOC T001. WAERS - Local Currency Code NVARCSTR 5 0 0 yes 31 CURR_ID_TRX PK RBKP. WAERS- Currency key NVARCSTR 5 0 0 yes 32 DISCNT_PERIOD_01 RBKP. ZBD1T - Days for first cash discount INTEGER 4 0 0 yes 33 DISCNT_PERIOD_02 RBKP. ZBD2T- Days for second cash discount INTEGER 4 0 0 yes 34 DOC_DATE RBKP. BLDAT- Date of the document DATETIME 24 0 9 yes Rapid Mart Data Schema 23 Appendix Table Column Details A 35 DOC_TYPE_ID PK RBKP. BLART- Document type Code NVARCSTR 2 0 0 yes 36 DR_CR_ID PK RESG. SHKZG - Debit/credit indicator NVARCSTR 10 0 0 yes 37 EXCH_RATE_LOC RBKP. KURSF - Exchange rate to local currency DECIMAL 48 9 5 yes 38 FINAL_INVOICE_FLAG RSEG. EREKZ - Final invoice indicator NVARCSTR 1 0 0 yes 39 FISC_PERIOD PK Fiscal Period in SAP - Lookup INTEGER 4 0 0 yes 40 FISC_YEAR PK RBKP. GJAHR - Fiscal year INTEGER 4 0 0 no 41 FISC_YEAR_REVERS AL RBKP. STJAH - Fiscal year of reversal document INTEGER 4 0 0 yes 42 FISC_YR_VARIANT_ID PK Lookup on T001. PERIV -Fiscal Year Variant NVARCSTR 2 0 0 yes 43 INVOICE_DESCR RBKP. BKTXT - Document header text NVARCSTR 25 0 0 yes 44 INVOICE_ID PK RBKP. BELNR - Document number of an invoice document RBKP. STBLG - Document number of reversal document RSEG. BUZEI - Document item in invoice document NVARCSTR 10 0 0 no 45 INVOICE_ID_REVERS AL INVOICE_LINE_ITEM_I PK D NVARCSTR 10 0 0 yes 46 NVARCSTR 6 0 0 no 47 LOAD_DATE PK Date loaded into Rapid Mart DATETIME 24 0 9 yes 48 LOAD_TIME Time loaded into Rapid Mart NVARCSTR 8 0 0 yes 49 MATERIAL_ID PK RSEG. BWKEY - Material NVARCSTR 18 0 0 yes 50 MTRL_GRP_ID PK Lookup on MARA. MATKL Material group NVARCSTR 9 0 0 yes 51 NET_DUE_PERIOD RBKP. ZBD3T Net payment terms period INTEGER 4 0 0 yes 52 PAYMNT_TERM_ID RBKP. ZTERM - Terms of payment key NVARCSTR 4 0 0 yes Rapid Mart Data Schema 24 Appendix Table Column Details A 53 PLANT_ID PK RSEG. WERKS - Plant NVARCSTR 4 0 0 yes 54 POST_DATE RBKP. BUDAT- Posting date in the document DATETIME 24 0 9 yes 55 PROD_HIER_ID PK MARA. [. . . ]