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

[. . . ] SAP BusinessObjects Sales 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. [. . . ] Leave Type Job leave type descriptive attributes from T533T MATERIAL The Materials Master in SAP R/3 and ERP. The material can be traded, used in manufacture, consumed, or produced. This class also contains the following subclasses: Material Batch Batch material management - Material Master from MCHA Material by Plant MARA and MARC Tables - Plant Level Material attributes. Material Group A grouping of materials and services according to their characteristics. SAP BusinessObjects Sales Rapid Mart XI 3. 2 for SAP solutions User Guide 243 5 Universe SAP Master Data Universe Material (Product) Hierarchy Materials can be grouped into hierarchies. Every material (product) can be assigned to one material product hierarchy level. Material Production Defines production version information (from MKAL). Material Type A grouping together of materials with the same basic attributes such as raw materials, semi-finished products, or finished products. All materials must be assigned to a material type which determines: · · · · · · Whether the material is intended for a specific purpose such as a configurable material or process material Whether the material number can be assigned internally or externally The number range from which the material number is drawn Which screens appear and in what sequence Which user department data you may enter What procurement type the material has; that is, whether it is manufactured in-house or procured externally, or both MONETARY DIMENSIONS A medium of exchange in current use within a particular country to valuate goods and services. 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: 244 SAP BusinessObjects Sales Rapid Mart XI 3. 2 for SAP solutions User Guide Universe SAP Master Data Universe 5 · · · · 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. SAP BusinessObjects Sales Rapid Mart XI 3. 2 for SAP solutions User Guide 245 5 Universe SAP Master Data Universe Mrp Element Type A term for all objects displayed as items in the MRP list or in the stock and requirements list. [. . . ] into SKU VBRP-UMVKZ - Numerator (factor) for conversion of sales quantity into SKU INTEGER 4 0 0 yes 75 INTEGER 4 0 0 yes 76 SHIP_POINT_ID VBRP. VSTEL Shipping Point/Receiving Point NVARCSTR 4 0 0 yes 77 STORAGE_LOCATN_I PK D VBRP. LGORT Storage location NVARCSTR 4 0 0 yes 78 TO_FACTOR_GBL TCURR-TFACT - Number of Currency for the units in the To-currency INTEGER 4 0 0 yes 79 UOM_ID_BASE VBRP-MEINS - Base Unit of Measure NVARCSTR 3 0 0 yes 80 UOM_ID_SALES PK VBRP-VRKME - Sales Unit NVARCSTR 3 0 0 yes Rapid Mart Data Schema 13 Appendix Table Column Details A BILLING_FACT_BAD VBRP, VBRK - Table for Sales Billing Documents including Invoices, Credt Memos, Invoice Cancellations, Debit Memos, Pro Forma Invoices, etc. # Column Name Key Column Desc Column Datatype Dtype Length Precision Scale Is Nullable 1 AMT_NET_VALUE_GB L AMT_NET_VALUE_HD R_GBL AMT_NET_VALUE_HD R_TRX AMT_NET_VALUE_TR X VBRP-NETWR - Net Value (Global Currency) DECIMAL 48 17 2 yes 2 Net value in document currency (Global Currency) DECIMAL 48 15 2 yes 3 VBRP-NETWR - Net Value of the billing Item in DECIMAL Document Currency 48 15 2 yes 4 Net value in document currency Calcualted field (Global Currency): for sales documents of catetories U or 5 or 6 it is 0, for sales documents of categories N or O it is set to a negative of the net it Calcualted field: for sales documents of catetories U or 5 or 6 it is 0, for sales documents of categories N or O it is set to a negative of the net item value, for ther VBRP-WAVWR - Cost in Global Currency DECIMAL 48 15 2 yes 5 AMT_REVENUE_GBL DECIMAL 48 15 2 yes 6 AMT_REVENUE_TRX DECIMAL 48 15 2 yes 7 AMT_STD_COST_GBL DECIMAL 48 15 2 yes 8 AMT_STD_COST_TRX VBRP-WAVWR - Cost in Document Currency DECIMAL 48 13 2 yes 9 AMT_SUBTTL_01_GB L AMT_SUBTTL_01_TR X AMT_SUBTTL_02_GB L AMT_SUBTTL_02_TR X AMT_SUBTTL_03_GB L AMT_SUBTTL_03_TR X AMT_SUBTTL_04_GB L AMT_SUBTTL_04_TR X VBRP-KZWI1 - Customer Configurable Subtotal 1 (Global Currency) VBRP-KZWI1 - Customer-Configurable Subtotal 1 VBRP-KZWI2 - Customer Configurable Subtotal 2 (Global Currency) VBRP-KZWI2 - Customer-Configurable Subtotal 2 VBRP-KZWI3 - Customer Configurable Subtotal (Global Currency) VBRP-KZWI3 - Customer-Configurable Subtotal 3 VBRP-KZWI4 - Customer Configurable Subtotal 4 (Global Currency) VBRP-KZWI4 - Customer-Configurable Subtotal 4 DECIMAL 48 15 2 yes 10 DECIMAL 48 13 2 yes 11 DECIMAL 48 15 2 yes 12 DECIMAL 48 13 2 yes 13 DECIMAL 48 15 2 yes 14 DECIMAL 48 13 2 yes 15 DECIMAL 48 15 2 yes 16 DECIMAL 48 13 2 yes Rapid Mart Data Schema 14 Appendix Table Column Details AMT_SUBTTL_05_GB L AMT_SUBTTL_05_TR X AMT_SUBTTL_06_GB L AMT_SUBTTL_06_TR X VBRP-KZWI5 - Customer Configurable Subtotal 5 (Global Currency) VBRP-KZWI5 - Customer-Configurable Subtotal 5 VBRP-KZWI6 - Customer Configurable Subtotal 6 (Global Currency) VBRP-KZWI6 - Customer-Configurable Subtotal 6 A 17 DECIMAL 48 15 2 yes 18 DECIMAL 48 13 2 yes 19 DECIMAL 48 15 2 yes 20 DECIMAL 48 13 2 yes 21 BILL_DATE VBRK. FKDAT - Billing Date DATETIME 24 0 9 yes 22 BILL_DOC_ID PK VBRP-VBELN - Billing Document NVARCSTR 10 0 0 no 23 BILL_DOC_ID_CANCE L VBRK-SFAKN - Cancelled billing document number NVARCSTR 10 0 0 yes 24 BILL_LINE_ITEM_ID PK VBRP-POSNR - Billing Item NVARCSTR 6 0 0 no 25 BILL_PLAN_ID VBRP. FPLNR - Billing plan number NVARCSTR 10 0 0 yes 26 CHANGE_DATE VBRK-AEDAT - Changed On DATETIME 24 0 9 yes 27 CMPNY_CODE_ID VBRK. BUKRS Company Code NVARCSTR 4 0 0 yes 28 CREATE_DATE VBRP-ERDAT - Date on Which the Record Was Created DATETIME 24 0 9 yes 29 CR_CTRL_AREA_ID VBRK. KKBER - Credit control area NVARCSTR 4 0 0 yes 30 CTRL_AREA_ID VBRP. KOKRS Controlling Area NVARCSTR 4 0 0 yes 31 CURR_ID_GBL TCURR-FCURR - From currency NVARCSTR 5 0 0 yes 32 CURR_ID_STATS VBRK-STWAE - Statistics currency NVARCSTR 5 0 0 yes 33 CURR_ID_TRX VBRK-WAERK - Document Currency NVARCSTR 5 0 0 yes 34 CUSTOMER_GRP_ID VBRP-KVGR1 - Customer Group 1 NVARCSTR 3 0 0 yes Rapid Mart Data Schema 15 Appendix Table Column Details CUSTOMER_ID_PAYE R CUSTOMER_ID_SOLD TO DISTRIBTN_CHANNEL _ID A 35 VBRK-KUNRG - Payer NVARCSTR 10 0 0 yes 36 VBRK-KUNAG - Sold-to Party NVARCSTR 10 0 0 yes 37 VBRK-VTWEG - Distribution Channel NVARCSTR 2 0 0 yes 38 DIVISION_ID VBRP-SPART - Division NVARCSTR 2 0 0 yes 39 DOC_CANCEL_FLAG VBRP-SHKZG - Billing document line item is cancelled if set to 1 INTEGER 4 0 0 yes 40 DOC_CATEG_ID VBRK-VBTYP - SD category NVARCSTR 1 0 0 yes 41 DOC_CATEG_ID_PRE CDNG VBRP-VGTYP - Document category of preceding SD document NVARCSTR 1 0 0 yes 42 DOC_CATEG_ID_REF VBRP-AUTYP - SD document category NVARCSTR 1 0 0 yes 43 DOC_TYPE_ID VBRK-FKART - Billing Type NVARCSTR 4 0 0 yes 44 ETL_ERROR_ACTN DI Validation transform error action code NVARCSTR 1 0 0 yes 45 ETL_ERROR_COLU MN EXCH_RATE_ACCT NG DI Valication transfrom error column name NVARCSTR 500 0 0 yes 46 VBRK-KURRF - Exchange Rate for Financial Accounting DECIMAL 48 20 5 yes 47 EXCH_RATE_GBL TCURR-UKURS - Exchange rate DECIMAL 48 9 5 yes 48 EXCH_RATE_STATS VBRP-STCUR - Exchange rate for statistics (Exch. rate at time of creation) DECIMAL 48 9 5 yes 49 EXCH_TYPE_ID_GBL TCURR-KURST - Exchange rate type NVARCSTR 4 0 0 yes 50 FISC_PERIOD Fiscal Period in SAP INTEGER 4 0 0 yes 51 FISC_YEAR Fiscal Year in SAP INTEGER 4 0 0 yes 52 FISC_YR_VARIANT_ID Fiscal Year Variant in SAP NVARCSTR 2 0 0 yes Rapid Mart Data Schema 16 Appendix Table Column Details TCURR-FFACT - Number of Currency for the from currency units A 53 FROM_FACTOR_GBL INTEGER 4 0 0 yes 54 INTER_CMPNY_TERM 01_ID VBRK. INCO1 Incoterms (Part 1) NVARCSTR 3 0 0 yes 55 ITEM_CATEG_ID SD document item category NVARCSTR 4 0 0 yes 56 LOAD_DATE PK System date of loading DATETIME 24 0 9 no 57 LOAD_TIME System time load NVARCSTR 8 0 0 yes 58 MATERIAL_ID VBRP-MATNR - Material Number NVARCSTR 18 0 0 yes 59 MTRL_GRP_ID VBRP. MATKL Material Group NVARCSTR 9 0 0 yes 60 PAYMNT_TERM_ID VBRK. ZTERM Terms of payment key NVARCSTR 4 0 0 yes 61 PLANT_ID VBRP-WERKS - Plant ID NVARCSTR 4 0 0 yes 62 PRICE_PROCEDURE_ ID PROCESS_STATUS_I D VBRK-KALSM - Pricing procedure for sales and distribution VBUP-GBSTA - Overall Processing Status of the SD item NVARCSTR 6 0 0 yes 63 NVARCSTR 1 0 0 yes 64 PROD_HIER_ID VBRP. PRODH Product Hierarchy NVARCSTR 18 0 0 yes 65 PROFIT_CNTR_ID VBRP. PRCTR Profit center Calculated field as QTY_INVOICED * SLS_TO_BASE_DIVISOR / SLS_TO_BASE_NUMERATOR VBRP-FKLMG - Billing Qty in StockKeeping Unit VBRP-VGBEL - Document number of the reference document NVARCSTR 10 0 0 yes 66 QTY_BILL_SLSUOM DECIMAL 48 13 3 yes 67 QTY_BILL_STOCKUO M DECIMAL 48 13 3 yes 68 REF_DOC_ID NVARCSTR 10 0 0 yes 69 REF_LINE_ITEM_ID VBRP-VGPOS - Item number of the reference NVARCSTR item 6 0 0 yes 70 RETURN_FLAG VBRP-SHKZG - Returns item NVARCSTR 1 0 0 yes Rapid Mart Data Schema 17 Appendix Table Column Details A 71 SALES_DOC_ID VBRP-AUBEL - Sales Document Number NVARCSTR 10 0 0 yes 72 SALES_GRP_ID VBRP-VKGRP - Sales group NVARCSTR 3 0 0 yes 73 SALES_LINE_ITEM_ID VBRP-AUPOS - Sales Document Item NVARCSTR 6 0 0 yes 74 SALES_OFFICE_ID VBRP-VKBUR - Sales Office NVARCSTR 4 0 0 yes 75 SALES_ORG_ID VBRK-VKORG - Sales Organization NVARCSTR 4 0 0 yes 76 SALES_TO_BASE_DIV ISOR SALES_TO_BASE_MU LTIPLR VBRP-UMVKN - Denominator (divisor) for conversion of sales qty. into SKU VBRP-UMVKZ - Numerator (factor) for conversion of sales quantity into SKU INTEGER 4 0 0 yes 77 INTEGER 4 0 0 yes 78 SHIP_POINT_ID VBRP. VSTEL Shipping Point/Receiving Point NVARCSTR 4 0 0 yes 79 STORAGE_LOCATN_I D VBRP. LGORT Storage location NVARCSTR 4 0 0 yes 80 TO_FACTOR_GBL TCURR-TFACT - Number of Currency for the units in the To-currency INTEGER 4 0 0 yes 81 UOM_ID_BASE VBRP-MEINS - Base Unit of Measure NVARCSTR 3 0 0 yes 82 UOM_ID_SALES VBRP-VRKME - Sales Unit NVARCSTR 3 0 0 yes Rapid Mart Data Schema 18 Appendix Table Column Details A BILLING_STAGE VBRP, VBRK - Table for Sales Billing Documents including Invoices, Credt Memos, Invoice Cancellations, Debit Memos, Pro Forma Invoices, etc. # Column Name Key Column Desc Column Datatype Dtype Length Precision Scale Is Nullable 1 AMT_NET_VALUE_GB L AMT_NET_VALUE_HD R_GBL AMT_NET_VALUE_HD R_TRX AMT_NET_VALUE_TR X VBRP-NETWR - Net Value (Global Currency) DECIMAL 48 17 2 yes 2 Net value in document currency (Global Currency) DECIMAL 48 15 2 yes 3 VBRP-NETWR - Net Value of the billing Item in DECIMAL Document Currency 48 15 2 yes 4 Net value in document currency Calcualted field (Global Currency): for sales documents of catetories U or 5 or 6 it is 0, for sales documents of categories N or O it is set to a negative of the net it Calcualted field: for sales documents of catetories U or 5 or 6 it is 0, for sales documents of categories N or O it is set to a negative of the net item value, for ther VBRP-WAVWR - Cost in Global Currency DECIMAL 48 15 2 yes 5 AMT_REVENUE_GBL DECIMAL 48 15 2 yes 6 AMT_REVENUE_TRX DECIMAL 48 15 2 yes 7 AMT_STD_COST_GBL DECIMAL 48 15 2 yes 8 AMT_STD_COST_TRX VBRP-WAVWR - Cost in Document Currency DECIMAL 48 13 2 yes 9 AMT_SUBTTL_01_GB L AMT_SUBTTL_01_TR X AMT_SUBTTL_02_GB L AMT_SUBTTL_02_TR X AMT_SUBTTL_03_GB L AMT_SUBTTL_03_TR X AMT_SUBTTL_04_GB L AMT_SUBTTL_04_TR X VBRP-KZWI1 - Customer Configurable Subtotal 1 (Global Currency) VBRP-KZWI1 - Customer-Configurable Subtotal 1 VBRP-KZWI2 - Customer Configurable Subtotal 2 (Global Currency) VBRP-KZWI2 - Customer-Configurable Subtotal 2 VBRP-KZWI3 - Customer Configurable Subtotal (Global Currency) VBRP-KZWI3 - Customer-Configurable Subtotal 3 VBRP-KZWI4 - Customer Configurable Subtotal 4 (Global Currency) VBRP-KZWI4 - Customer-Configurable Subtotal 4 DECIMAL 48 15 2 yes 10 DECIMAL 48 13 2 yes 11 DECIMAL 48 15 2 yes 12 DECIMAL 48 13 2 yes 13 DECIMAL 48 15 2 yes 14 DECIMAL 48 13 2 yes 15 DECIMAL 48 15 2 yes 16 DECIMAL 48 13 2 yes Rapid Mart Data Schema 19 Appendix Table Column Details AMT_SUBTTL_05_GB L AMT_SUBTTL_05_TR X AMT_SUBTTL_06_GB L AMT_SUBTTL_06_TR X VBRP-KZWI5 - Customer Configurable Subtotal 5 (Global Currency) VBRP-KZWI5 - Customer-Configurable Subtotal 5 VBRP-KZWI6 - Customer Configurable Subtotal 6 (Global Currency) VBRP-KZWI6 - Customer-Configurable Subtotal 6 A 17 DECIMAL 48 15 2 yes 18 DECIMAL 48 13 2 yes 19 DECIMAL 48 15 2 yes 20 DECIMAL 48 13 2 yes 21 BILL_DATE VBRK. FKDAT - Billing Date DATETIME 24 0 9 yes 22 BILL_DOC_ID PK VBRP-VBELN - Billing Document NVARCSTR 10 0 0 no 23 BILL_DOC_ID_CANCE L VBRK-SFAKN - Cancelled billing document number NVARCSTR 10 0 0 yes 24 BILL_LINE_ITEM_ID PK VBRP-POSNR - Billing Item NVARCSTR 6 0 0 no 25 BILL_PLAN_ID VBRP. FPLNR - Billing plan number NVARCSTR 10 0 0 yes 26 CHANGE_DATE VBRK-AEDAT - Changed On DATETIME 24 0 9 yes 27 CMPNY_CODE_ID VBRK. BUKRS Company Code NVARCSTR 4 0 0 yes 28 CREATE_DATE VBRP-ERDAT - Date on Which the Record Was Created DATETIME 24 0 9 yes 29 CR_CTRL_AREA_ID VBRK. KKBER - Credit control area NVARCSTR 4 0 0 yes 30 CTRL_AREA_ID VBRP. KOKRS Controlling Area NVARCSTR 4 0 0 yes 31 CURR_ID_GBL TCURR-FCURR - From currency NVARCSTR 5 0 0 yes 32 CURR_ID_STATS VBRK-STWAE - Statistics currency NVARCSTR 5 0 0 yes 33 CURR_ID_TRX VBRK-WAERK - Document Currency NVARCSTR 5 0 0 yes 34 CUSTOMER_GRP_ID VBRP-KVGR1 - Customer Group 1 NVARCSTR 3 0 0 yes Rapid Mart Data Schema 20 Appendix Table Column Details CUSTOMER_ID_PAYE R CUSTOMER_ID_SOLD TO DISTRIBTN_CHANNEL _ID A 35 VBRK-KUNRG - Payer NVARCSTR 10 0 0 yes 36 VBRK-KUNAG - Sold-to Party NVARCSTR 10 0 0 yes 37 VBRK-VTWEG - Distribution Channel NVARCSTR 2 0 0 yes 38 DIVISION_ID VBRP-SPART - Division NVARCSTR 2 0 0 yes 39 DOC_CANCEL_FLAG VBRP-SHKZG - Billing document line item is cancelled if set to 1 INTEGER 4 0 0 yes 40 DOC_CATEG_ID VBRK-VBTYP - SD category NVARCSTR 1 0 0 yes 41 DOC_CATEG_ID_PRE CDNG VBRP-VGTYP - Document category of preceding SD document NVARCSTR 1 0 0 yes 42 DOC_CATEG_ID_REF VBRP-AUTYP - SD document category NVARCSTR 1 0 0 yes 43 DOC_TYPE_ID VBRK-FKART - Billing Type NVARCSTR 4 0 0 yes 44 EXCH_RATE_ACCT NG VBRK-KURRF - Exchange Rate for Financial Accounting DECIMAL 48 20 5 yes 45 EXCH_RATE_GBL TCURR-UKURS - Exchange rate DECIMAL 48 9 5 yes 46 EXCH_RATE_STATS VBRP-STCUR - Exchange rate for statistics (Exch. rate at time of creation) DECIMAL 48 9 5 yes 47 EXCH_TYPE_ID_GBL TCURR-KURST - Exchange rate type NVARCSTR 4 0 0 yes 48 FISC_PERIOD Fiscal Period in SAP INTEGER 4 0 0 yes 49 FISC_YEAR Fiscal Year in SAP INTEGER 4 0 0 yes 50 FISC_YR_VARIANT_ID Fiscal Year Variant ID in SAP NVARCSTR 2 0 0 yes 51 FROM_FACTOR_GBL TCURR-FFACT - Number of Currency for the from currency units INTEGER 4 0 0 yes 52 INTER_CMPNY_TERM 01_ID VBRK. INCO1 Incoterms (Part 1) NVARCSTR 3 0 0 yes Rapid Mart Data Schema 21 Appendix Table Column Details A 53 ITEM_CATEG_ID SD document item category NVARCSTR 4 0 0 yes 54 LOAD_DATE System date of loading DATETIME 24 0 9 yes 55 LOAD_TIME System time load NVARCSTR 8 0 0 yes 56 MATERIAL_ID VBRP-MATNR - Material Number NVARCSTR 18 0 0 yes 57 MTRL_GRP_ID VBRP. MATKL Material Group NVARCSTR 9 0 0 yes 58 PAYMNT_TERM_ID VBRK. ZTERM Terms of payment key NVARCSTR 4 0 0 yes 59 PLANT_ID VBRP-WERKS - Plant ID NVARCSTR 4 0 0 yes 60 PRICE_PROCEDURE_ ID PROCESS_STATUS_I D VBRK-KALSM - Pricing procedure for sales and distribution VBUP-GBSTA - Overall Processing Status of the SD item NVARCSTR 6 0 0 yes 61 NVARCSTR 1 0 0 yes 62 PROD_HIER_ID VBRP. PRODH Product Hierarchy NVARCSTR 18 0 0 yes 63 PROFIT_CNTR_ID VBRP. PRCTR Profit center Calculated field as QTY_INVOICED * SLS_TO_BASE_DIVISOR / SLS_TO_BASE_NUMERATOR VBRP-FKLMG - Billing Qty in StockKeeping Unit VBRP-VGBEL - Document number of the reference document NVARCSTR 10 0 0 yes 64 QTY_BILL_SLSUOM DECIMAL 48 13 3 yes 65 QTY_BILL_STOCKUO M DECIMAL 48 13 3 yes 66 REF_DOC_ID NVARCSTR 10 0 0 yes 67 REF_LINE_ITEM_ID VBRP-VGPOS - Item number of the reference NVARCSTR item 6 0 0 yes 68 RETURN_FLAG VBRP-SHKZG - Returns item NVARCSTR 1 0 0 yes 69 SALES_DOC_ID VBRP-AUBEL - Sales Document Number NVARCSTR 10 0 0 yes 70 SALES_GRP_ID VBRP-VKGRP - Sales group NVARCSTR 3 0 0 yes Rapid Mart Data Schema 22 Appendix Table Column Details A 71 SALES_LINE_ITEM_ID VBRP-AUPOS - Sales Document Item NVARCSTR 6 0 0 yes 72 SALES_OFFICE_ID VBRP-VKBUR - Sales Office NVARCSTR 4 0 0 yes 73 SALES_ORG_ID VBRK-VKORG - Sales Organization NVARCSTR 4 0 0 yes 74 SALES_TO_BASE_DIV ISOR SALES_TO_BASE_MU LTIPLR VBRP-UMVKN - Denominator (divisor) for conversion of sales qty. into SKU VBRP-UMVKZ - Numerator (factor) for conversion of sales quantity into SKU INTEGER 4 0 0 yes 75 INTEGER 4 0 0 yes 76 SHIP_POINT_ID VBRP. VSTEL Shipping Point/Receiving Point NVARCSTR 4 0 0 yes 77 STORAGE_LOCATN_I D VBRP. LGORT Storage location NVARCSTR 4 0 0 yes 78 TO_FACTOR_GBL TCURR-TFACT - Number of Currency for the units in the To-currency INTEGER 4 0 0 yes 79 UOM_ID_BASE VBRP-MEINS - Base Unit of Measure NVARCSTR 3 0 0 yes 80 UOM_ID_SALES VBRP-VRKME - Sales Unit NVARCSTR 3 0 0 yes Rapid Mart Data Schema 23 Appendix Table Column Details A CENTRAL_ADDRESS Sourced from table ADRC in SAP, Only Ship-to addresses for Sales orders are included # Column Name Key Column Desc Column Datatype Dtype Length Precision Scale Is Nullable 1 ADDRESS_ID PK Address number NVARCSTR 10 0 0 no 2 CITY City NVARCSTR 40 0 0 yes 3 COUNTRY_ID Country key NVARCSTR 3 0 0 yes 4 COUNTRY_NAME T005T. LANDX - Country Name NVARCSTR 20 0 0 yes 5 CUSTOMER_NAME_ 01 CUSTOMER_NAME_ 02 CUSTOMER_NAME_ 03 CUSTOMER_NAME_ 04 Name 1 NVARCSTR 40 0 0 yes 6 Name 2 NVARCSTR 40 0 0 yes 7 Name 3 NVARCSTR 40 0 0 yes 8 Name 4 NVARCSTR 40 0 0 yes 9 DISTRICT District NVARCSTR 40 0 0 yes 10 FAX First fax no. : dialling code+number NVARCSTR 30 0 0 yes 11 HOUSE_NUMBER House number NVARCSTR 10 0 0 yes 12 LOAD_DATE Date and Time Loaded into Rapid Mart DATETIME 24 0 9 yes 13 LOAD_TIME Time Loaded into Rapid Mart NVARCSTR 8 0 0 yes 14 PHONE First telephone no. : dialling code+number NVARCSTR 30 0 0 yes 15 REGION_ID Region (State, Province, County) NVARCSTR 3 0 0 yes 16 REGION_NAME T005U. BEZEI - Region Name (State, Province, NVARCSTR etc. ) 20 0 0 yes Rapid Mart Data Schema 24 Appendix Table Column Details A 17 STREET Street NVARCSTR 60 0 0 yes 18 ZIP City postal code NVARCSTR 10 0 0 yes Rapid Mart Data Schema 25 Appendix Table Column Details A COMPANY_CODE T001 - Company Code master # Column Name Key Column Desc Column Datatype Dtype Length Precision Scale Is Nullable 1 ADDRESS_ID Company default address identifier NVARCSTR 10 0 0 yes 2 CHART_OF_ACCT_ID Company Code chart of accounts NVARCSTR 4 0 0 yes 3 CHART_OF_ACCT_ID _COUNTRY CHART_OF_ACCT_NA ME Chart of Accounts according to country legislation NVARCSTR 4 0 0 yes 4 Chart of Accounts Name NVARCSTR 50 0 0 yes 5 CITY Company City Name NVARCSTR 40 0 0 yes 6 CMPNY_CODE_FULL_ NAME Company Code and Name NVARCSTR 120 0 0 yes 7 CMPNY_CODE_ID PK T001-BURKS - Company Code ID NVARCSTR 4 0 0 no 8 CMPNY_CODE_ID_OR IGINAL Original Key of Company Code NVARCSTR 4 0 0 yes 9 CMPNY_CODE_NAME Company Code Name NVARCSTR 40 0 0 yes 10 CMPNY_CODE_NAM E_01 CMPNY_CODE_NAM E_02 CMPNY_CODE_NAM E_03 CMPNY_CODE_NAM E_04 Name of the Company - 1st description NVARCSTR 40 0 0 yes 11 Name of the Company - 2nd description NVARCSTR 40 0 0 yes 12 Name of the Company - 3rd description NVARCSTR 40 0 0 yes 13 Name of the Company - 4th description NVARCSTR 40 0 0 yes 14 COUNTRY_ID Country Identifier NVARCSTR 3 0 0 yes 15 COUNTRY_NAME Country Name (lookup) NVARCSTR 15 0 0 yes 16 CR_CTRL_AREA_DES CR Credit Controlling Area description NVARCSTR 35 0 0 yes Rapid Mart Data Schema 26 Appendix Table Column Details A 17 CR_CTRL_AREA_ID Credit Control area NVARCSTR 4 0 0 yes 18 CURR_ID Company Code Currency ID NVARCSTR 5 0 0 yes 19 DISTRICT District of the Company NVARCSTR 40 0 0 yes 20 FAX Fax no of the Company NVARCSTR 40 0 0 yes 21 FIN_MGMT_AREA_ID Financial Management Area NVARCSTR 4 0 0 yes 22 FISC_YR_VARIANT_ID Company code fiscal year variant NVARCSTR 2 0 0 yes 23 FISC_YR_VARIANT_N AME Company code fiscal year variant name NVARCSTR 30 0 0 yes 24 HOUSE_NUMBER Company code house number NVARCSTR 10 0 0 yes 25 LANG_DESCR Company code language Description NVARCSTR 16 0 0 yes 26 LANG_ID Company Code default language NVARCSTR 1 0 0 yes 27 LOAD_DATE Date and time when the record was loaded into DATETIME Rapid Mart Time when the record was loaded into the RapidMart (string format HH24:MI:SS) 24 0 9 yes 28 LOAD_TIME NVARCSTR 8 0 0 yes 29 PHONE Company code telephone number NVARCSTR 30 0 0 yes 30 REGION_ID Company code region NVARCSTR 3 0 0 yes 31 REGION_NAME Company code region name NVARCSTR 20 0 0 yes 32 STREET Company code street name NVARCSTR 60 0 0 yes 33 TAX_JURISDIC_NUM Jurisdiction fo tax calculation - tax jurisdiction code NVARCSTR 15 0 0 yes 34 VAT_REGISTRTN_NU M VAT regulation number NVARCSTR 20 0 0 yes Rapid Mart Data Schema 27 Appendix Table Column Details A 35 ZIP Company code postal code NVARCSTR 10 0 0 yes CONTROLLING_AREA TKA01 - Controlling areas master # Column Name Key Column Desc Column Datatype Dtype Length Precision Scale Is Nullable 1 CTRL_AREA_DESCR Controlling Area Name NVARCSTR 25 0 0 yes 2 CTRL_AREA_FULL_N AME Controlling Area DI and Desc NVARCSTR 120 0 0 yes 3 CTRL_AREA_ID PK TKA01-KORKS - Controlling Area ID NVARCSTR 4 0 0 no 4 CURR_ID Currency Code for Controlling Area NVARCSTR 5 0 0 yes 5 FISC_YR_VARIANT_ID Fiscal Year Variant NVARCSTR 2 0 0 yes 6 LEDGER_ID_PROFIT_ CNTR Financial Ledger ID profit Center NVARCSTR 2 0 0 yes 7 LOAD_DATE Date and time when the record was loaded into DATETIME Rapid Mart Time when the record was loaded into the RapidMart (string format HH24:MI:SS) 24 0 9 yes 8 LOAD_TIME NVARCSTR 8 0 0 yes 9 OPERTNG_CONCER N_ID Operating Concern NVARCSTR 4 0 0 yes 10 PROFIT_CNTR_AREA Profit Center Group NVARCSTR 12 0 0 yes 11 STD_SET_HIER_COD E Standard Hierarchy for Cost Centers NVARCSTR 12 0 0 yes Rapid Mart Data Schema 28 Appendix Table Column Details A CREDIT_CONTROL_AREA T014T - Credit Control Area Names # Column Name Key Column Desc Column Datatype Dtype Length Precision Scale Is Nullable 1 CR_CTRL_AREA_DES CR CR_CTRL_AREA_FUL L_NAME T014T. KKBTX - Description of the credit control area Concatenation of Credit Ctrl Area ID and Description NVARCSTR 35 0 0 yes 2 NVARCSTR 120 0 0 yes 3 CR_CTRL_AREA_ID PK T014T. KKBER - Credit control area NVARCSTR 4 0 0 no 4 LOAD_DATE Date and Time loaded into Rapid Mart DATETIME 24 0 9 yes 5 LOAD_TIME Time Loaded into Rapid Mart NVARCSTR 8 0 0 yes CREDIT_MGMT_RISK_CLASS T691T - Credit management risk classes text # Column Name Key Column Desc Column Datatype Dtype Length Precision Scale Is Nullable 1 CR_CTRL_AREA_ID PK Credit Control Area ID NVARCSTR 4 0 0 no 2 CR_MGMT_RISK_CLA SS_DESCR CR_MGMT_RISK_CLA PK SS_ID Name of the risk class NVARCSTR 30 0 0 yes 3 Credit management: Risk Class NVARCSTR 3 0 0 no 4 LOAD_DATE Date and Time loaded into Rapid Mart DATETIME 24 0 9 yes 5 LOAD_TIME Time Loaded into Rapid Mart NVARCSTR 8 0 0 yes Rapid Mart Data Schema 29 Appendix Table Column Details A CURRENCY TCURC, TCURT # Column Name Key Column Desc Column Datatype Dtype Length Precision Scale Is Nullable 1 CURR_DECIMAL Lookup TCURX. CURRDEC - Number of decimals to display amounts in this currency. DECIMAL 48 28 0 yes 2 CURR_DESCR TCURT-LTEXT - Long Text NVARCSTR 60 0 0 yes 3 CURR_ID PK TCURC-WAERS - Currency Key NVARCSTR 5 0 0 no 4 CURR_ID_ALT TCURC-ALTWR - Alternative Key For Currencies NVARCSTR 3 0 0 yes 5 CURR_ISO_CODE TCURC-ISOCD - ISO Currency Code NVARCSTR 3 0 0 yes 6 DISPLAY_FACTOR Multiply currency amounts by this factor to display with correct number of decimals for the DECIMAL currency Date and time when the record was loaded into DATETIME Rapid Mart Time when the record was loaded into the RapidMart (string format HH24:MI:SS) TCURC-GDATU -Date Up Until Which The Currency Is Valid 48 17 14 yes 7 LOAD_DATE 24 0 9 yes 8 LOAD_TIME NVARCSTR 8 0 0 yes 9 VALID_TO_DATE DATETIME 24 0 9 yes Rapid Mart Data Schema 30 Appendix Table Column Details A CURRENCY_CONVERT_RATE TCURR and TCURW - Monetary Conversion rates # Column Name Key Column Desc Column Datatype Dtype Length Precision Scale Is Nullable 1 CURR_ID_FROM PK TCURR-FCURR - From currency NVARCSTR 5 0 0 no 2 CURR_ID_TO PK TCURR-TCURR - To-currency NVARCSTR 5 0 0 no 3 EXCH_RATE TCURR-UKURS - Exchange rate DECIMAL 48 9 5 yes 4 EXCH_TYPE_DESCR TCURW-CURVW - Exchange rate type usage NVARCSTR 40 0 0 yes 5 EXCH_TYPE_ID PK TCURR-KURST - Exchange rate type NVARCSTR 4 0 0 no 6 FROM_FACTOR TCURR-FFACT - Number of Currency for the from currency units "Y" if original value of TCURR. UKURS was negative. Otherwise "N" INTEGER 4 0 0 yes 7 INVERSE_RATE_FLA G NVARCSTR 1 0 0 yes 8 LOAD_DATE Date Time when the record was loaded DATETIME 24 0 9 yes 9 LOAD_TIME Time in HH24:MI:SS string format when the record was created TCURR-TFACT - Number of Currency for the units in the To-currency TCURR-GDATU- Date since when the exchange rate has been valid To be used by Effective Date to generate VALID_TO output NVARCSTR 8 0 0 yes 10 TO_FACTOR INTEGER 4 0 0 yes 11 VALID_FROM_DATE PK DATETIME 24 0 9 no 12 VALID_TO_DATE DATETIME 24 0 9 yes Rapid Mart Data Schema 31 Appendix Table Column Details A CUSTOMER General customer master data at the customer level (KNA1) # Column Name Key Column Desc Column Datatype Dtype Length Precision Scale Is Nullable 1 ACCT_GRP_ID KNA1-KTOKD - Customer Group Account NVARCSTR 4 0 0 yes 2 ACCT_GRP_NAME Lookup of account group name from T077X. TXT30 from KNA1. KTKOD NVARCSTR 30 0 0 yes 3 ADDRESS_ID Load date NVARCSTR 10 0 0 yes 4 AMT_ANNUAL_SALES KNA1-UMSAT - Annual sale DECIMAL 48 15 2 yes 5 AMT_ANNUAL_SALES _02 KNA1-UMSA1 - Annual Sales DECIMAL 48 15 2 yes 6 ANNUAL_SALES_YR KNA1-UMJAH - Year for which sales are given NVARCSTR 4 0 0 yes 7 CITY KNA1-ORT01 - City NVARCSTR 40 0 0 yes 8 CLASSIFCTN_CODE KNA1-KUKLA - Customer Classification Lookup of TKUKT. VTEXT for description of customer classification (size by total sales) based on KNA1. KUKLA. [. . . ]