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. The information contained herein may be changed without prior notice. Some software products marketed by SAP AG and its distributors contain proprietary software components of other software vendors. Trademarks All rights reserved. [. . . ] Equipment can be internal, such as machinery in your factory used to manufacture goods for sale. Equipment can also be external, such as the machine that is manufactured and sold to your customer. FUNCTIONAL LOCATION Organizational unit within Logistics that structures the maintenance objects of a company according to functional, process-oriented or spatial criteria. A functional location represents the place at which a maintenance task is to be performed. GL ACCOUNTS and HIERARCHIES General Ledger accounts are a structure that records value movements in a company code and represents the G/L account items in a chart of accounts. The Debit / Credit Flag indicates a debit or credit posting. The accounts can be organized into various hierarchies, such as those need to produce Profit & Loss or other Financial Statements. Use the Hierarchy Data Discovery Class to explore these hierarchies. Additionally these dimensions include sub-classes that facility data discovery of the GL Account Hierarchies and Financial Statement (FS) Hierarchies, without linking to any fact table. · · GL Account Hierarchy Data Discovery · · · · GL Account Discovery Hz GL Account Discovery Vr FS Hierarchy Discovery Hz FS Hierarchy Discovery Vr INTERCOMPANY TERM01 Describes when in the delivery process the receiver of goods takes physical ownerships of the those goods. INTERNAL ORDERS Production Orders, Service Orders, and associated hierarchies. Object used to monitor costs and, in some instances, revenues for an organization. Monitor the costs of short-term measures Monitor the costs and revenues related to a specific service SAP BusinessObjects Purchasing Rapid Mart XI 3. 2 for SAP solutions User Guide 193 5 Universe SAP Master Data Universe 3. 4. Monitor ongoing costs Overhead orders Capital investment orders Accrual orders Orders with revenues. Internal orders are divided into the following categories: Internal Order Status Internal Order status name and description from TKO04. JOB An organizational object that serves as a template for creating positions when you create an organizational plan. Unlike Positions that can be occupied by holders, for example, secretary in the marketing department. Jobs are a classification of functions in an enterprise, for example, secretary, defined by the tasks and characteristics assigned to them. Job descriptions apply to different positions with similar tasks and characteristics. This includes Exempt/Non-Exempt Status, Payscale, etc. LEAVE Information about the types of leave (vacation, sick leave, maternity leave, etc. ) an employee may have. Leave Type Job leave type descriptive attributes from T533T MATERIAL The Materials Master in SAP R/3 and ERP. Goods that are the subject of business activity. 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. 194 SAP BusinessObjects Purchasing Rapid Mart XI 3. 2 for SAP solutions User Guide Universe SAP Master Data Universe 5 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. [. . . ] 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. PRDHA- Lookup on Prod Hier ID NVARCSTR 18 0 0 yes 56 PURCH_DOC_ID RESG. EBELN - Purchasing document number NVARCSTR 10 0 0 yes 57 PURCH_ITEM_CATEG PK _ID PURCH_LINE_ITEM_I D RSEG. PSTYP - Item category in purchasing document RSEG. EBELP Item number of purchasing document NVARCSTR 1 0 0 yes 58 NVARCSTR 5 0 0 yes 59 PURCH_ORG_ID PK Lookup on T001W. EKORG Material group NVARCSTR 4 0 0 yes 60 QTY RSEG. MENGE - Line item invoice quantity DECIMAL 48 13 3 yes 61 QTY_PRCUOM RSEG. BPMNG - Quantity in order price unit DECIMAL 48 13 3 yes 62 SURROGATE_INVOIC E_NUM Concatenation of Fiscal Year and invoice number (for invoice count) NVARCSTR 14 0 0 yes 63 TAX_CODE RBKP. WMWST1 Tax code NVARCSTR 2 0 0 yes 64 UOM_ID PK RSEG. BSTME - Order unit (purchasing) NVARCSTR 3 0 0 yes 65 UOM_ID_PRICE RESG. BPRME - Order price unit (purchasing) NVARCSTR 3 0 0 yes 66 VALUATN_AREA_ID PK RSEG. BWKEY - Valuation area NVARCSTR 4 0 0 yes 67 VENDOR_ID PK RBKP. LIFNR- Vendors account number NVARCSTR 10 0 0 yes Rapid Mart Data Schema 25 Appendix Table Column Details A MATERIAL MARA - Material Master # Column Name Key Column Desc Column Datatype Dtype Length Precision Scale Is Nullable 1 BATCH_MGMT_FLAG XCHPF Batch management requirement indicator NVARCSTR 1 0 0 yes 2 CREATE_DATE ERSDA Date of creation DATETIME 24 0 9 yes 3 DELETE_CODE MARA-LVORM - Deletion flag for all material data (central) NVARCSTR 1 0 0 yes 4 DELETE_DATE LIQDT Deletion date DATETIME 24 0 9 yes 5 DIVISION_DESCR TSPAT. VTEXT Division Description NVARCSTR 20 0 0 yes 6 DIVISION_ID MARA. SPART Division NVARCSTR 2 0 0 yes 7 INDUSTRY_SECTOR_I D INDUSTRY_SECT_DE SCR MARA. MBRSH Industry Sector ID NVARCSTR 1 0 0 yes 8 Lookup description of MARA. MBRSH Industry sector NVARCSTR 25 0 0 yes 9 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 10 LOAD_TIME NVARCSTR 8 0 0 yes 11 LOW_LVL_CODE MARA. DISST - Low level code NVARCSTR 3 0 0 yes 12 MATERIAL_ID PK MATNR Material number NVARCSTR 18 0 0 no 13 MIN_REM_SHELF_LIF E MARA. MHDRZ Minimum remaining shelf life INTEGER 4 0 0 yes 14 MODIFIED_DATE MARA. LAEDA Date of last change DATETIME 24 0 9 yes 15 MTRL_CATEG_DES CR Category Description NVARCSTR 60 0 0 yes 16 MTRL_CATEG_ID MARA. ATTYP Material category NVARCSTR 2 0 0 yes Rapid Mart Data Schema 26 Appendix Table Column Details A 17 MTRL_DESCR MAKTX Material description NVARCSTR 40 0 0 yes 18 MTRL_FULL_NAME Material ID and Material Description NVARCSTR 64 0 0 yes 19 MTRL_GRP_DESCR WGBEZ Description of material group NVARCSTR 20 0 0 yes 20 MTRL_GRP_ID MATKL Material group NVARCSTR 9 0 0 yes 21 MTRL_ID_MANUFCTR MARA. MFRPN - Manfuacturer Part (Material) Number NVARCSTR 40 0 0 yes 22 MTRL_TYPE_DESCR Lookup description of MARA. MTART in T134T NVARCSTR 25 0 0 yes 23 MTRL_TYPE_ID MTART Material type NVARCSTR 4 0 0 yes 24 PROD_HIER_ID PK PRDHA Product hierarchy NVARCSTR 18 0 0 yes 25 PURCH_STATUS_C ODE General material status: Purchasing NVARCSTR 2 0 0 yes 26 REVISION_LVL Lookup AEOI. REVLV - Material revision level NVARCSTR 2 0 0 yes 27 SALES_STATUS_COD E TRANSPORT_GRP_ CODE MARA. MSTAV General material status: sales NVARCSTR 2 0 0 yes 28 MARA. TRAGR Transportation group NVARCSTR 4 0 0 yes 29 TTL_SHELF_LIFE MARA. MHDHB Total shelf life in days INTEGER 4 0 0 yes 30 UOM_ID_BASE MEINS Base unit of measure NVARCSTR 3 0 0 yes 31 UOM_ID_ORDER MARA. BSTME Order unit (purchasing) NVARCSTR 3 0 0 yes 32 UOM_ID_VOLUME MARA. VOLEH Volume unit NVARCSTR 3 0 0 yes 33 UOM_ID_WEIGHT MARA. GEWEI Unit of weight NVARCSTR 3 0 0 yes 34 VALID_FROM_DATE MARA. DATAB Date valid from DATETIME 24 0 9 yes Rapid Mart Data Schema 27 Appendix Table Column Details A 35 VOLUME MARA. VOLUM Volume DECIMAL 48 13 3 yes 36 WEIGHT MARA. NTGEW Net weight DECIMAL 48 13 3 yes Rapid Mart Data Schema 28 Appendix Table Column Details A MATERIAL_BY_PLANT MARA and MARC Tables - Plant Level Material attributes # Column Name Key Column Desc Column Datatype Dtype Length Precision Scale Is Nullable 1 ABC_CATEG_DESCR TMABCT. TMABC - lookup on ABC indicator descritpion NVARCSTR 30 0 0 yes 2 ABC_CATEG_ID MARC. MAABC ABC indicator NVARCSTR 1 0 0 yes 3 BASE_TO_PRODUC TN_MULTIPLR Lookup MARM. UMREZ Factor to convert from BASE UOM to PROD UOM. (PROD_QTY = INTEGER MENGE / UMREZ) Lookup MARC. XCHAR Batch management indicator (internal) MARC. XCHPF Batch management requirement indicator NVARCSTR 4 0 0 yes 4 BATCH_MGMT_FLAG 1 0 0 yes 5 BATCH_MGMT_REQ _FLAG NVARCSTR 1 0 0 yes 6 BULK_MTRL_FLAG MARC. SCHGT Indicator: bulk material NVARCSTR 1 0 0 yes 7 COUNTRY_ID_ORIGIN MARC. HERKL Materials country of origin NVARCSTR 3 0 0 yes 8 COUNTRY_NAME_O RIGIN Lookup description onT005T. LANDX for Country name NVARCSTR 15 0 0 yes 9 DAYS_PLAN_DELIV MARC. PLIFZ - Planned delivery time in days MARC. WEBAZ - Planned goods receipt processing time in days - includes inspection time MARC. WZEIT - Total replenishment lead time in days - in house production time and/or delivery lead tim MARC. DZEIT - In-house production time INTEGER 4 0 0 yes 10 DAYS_PLAN_GR INTEGER 4 0 0 yes 11 DAYS_REPLENISH INTEGER 4 0 0 yes 12 DAYS_TO_PRODUCE INTEGER 4 0 0 yes 13 DELETE_FLAG MARC. LVORM - Plant level material deletion indicator NVARCSTR 1 0 0 yes 14 DIVISION_DESCR TSPAT. VTEXT Division Description NVARCSTR 20 0 0 yes 15 DIVISION_ID MARA. SPART Division NVARCSTR 2 0 0 yes 16 INDUSTRY_SECTOR_ DESCR Lookup description of MARA. MBRSH Industry sector NVARCSTR 25 0 0 yes Rapid Mart Data Schema 29 Appendix Table Column Details INDUSTRY_SECTOR_I D A 17 MARA. MBRSH Industry Sector ID NVARCSTR 1 0 0 yes 18 LOAD_DATE Date and time loaded into RapidMart DATETIME 24 0 9 yes 19 LOAD_TIME Time loaded into RapidMart NVARCSTR 8 0 0 yes 20 MATERIAL_ID PK MARC. MATNR Material number NVARCSTR 18 0 0 no 21 MRP_CTRLLER_ID MARC. DISPO MRP controller NVARCSTR 3 0 0 yes 22 MRP_CTRLLER_NA ME T024D. DSNAM - Name of MRP controller lookup T438T. DIBEZ -Long MRP Type Description from T438T NVARCSTR 18 0 0 yes 23 MRP_TYPE_DESCR NVARCSTR 30 0 0 yes 24 MRP_TYPE_ID MARC. DISMM MRP type code NVARCSTR 2 0 0 yes 25 MTRL_CATEG_DES CR lookup on ATTYP domain in DD07T NVARCSTR 60 0 0 yes 26 MTRL_CATEG_ID MARA. ATTYP Material category NVARCSTR 2 0 0 yes 27 MTRL_DESCR MAKT. MAKTX -Material description NVARCSTR 40 0 0 yes 28 MTRL_FULL_NAME Material ID and Material Description NVARCSTR 64 0 0 yes 29 MTRL_GRP_DESCR WGBEZ Description of material group NVARCSTR 20 0 0 yes 30 MTRL_GRP_ID MATKL Material group NVARCSTR 9 0 0 yes 31 MTRL_TYPE_DESCR Lookup description of MARA. MTART in T134T NVARCSTR 25 0 0 yes 32 MTRL_TYPE_ID MTART Material type NVARCSTR 4 0 0 yes 33 PLANT_FULL_NAME Plant ID and Plant Name NVARCSTR 40 0 0 yes 34 PLANT_ID PK MARC. WERKS Plant NVARCSTR 4 0 0 no Rapid Mart Data Schema 30 Appendix Table Column Details A 35 PLANT_NAME T001W. NAME1 -Name NVARCSTR 30 0 0 yes 36 PROCUREMNT_TYP E_DESCR PROCUREMNT_TYP E_ID Lookup DD07T - Procurement type - BESKZ domain NVARCSTR 60 0 0 yes 37 MARC. BESKZ - Procurement type code NVARCSTR 20 0 0 yes 38 PROFIT_CNTR_ID MARC. PRCTR Profit center NVARCSTR 10 0 0 yes 39 PURCH_GRP_DESCR Lookup description of T024. EKNAM - Purchase NVARCSTR Group Name 30 0 0 yes 40 PURCH_GRP_ID MARC. EKGRP Purchasing group NVARCSTR 3 0 0 yes 41 QTY_REORDER_POIN T MARC. MINBE Reorder point DECIMAL 48 13 3 yes 42 QTY_SAFETY_STOCK MARC. EISBE Safety stock DECIMAL 48 13 3 yes 43 QUALITY_INSPECT_F LAG SPECL_PROCUREM NT_TYPE_DESCR SPECL_PROCUREM NT_TYPE_ID MARC. INSMK - Quality inspection indicator - X NVARCSTR is yes Lookup description of MARC. SOBSL in T460T- NVARCSTR Special procurement type 1 0 0 yes 44 30 0 0 yes 45 MARC. SOBSL - Special procurement type NVARCSTR 2 0 0 yes 46 SUPPLY_SRC_DESCR Lookup description on TMBWT. BWSCB for supply source description NVARCSTR 40 0 0 yes 47 SUPPLY_SRC_ID MARC. BWSCL Source of supply IS-R NVARCSTR 1 0 0 yes 48 UOM_CODE_BASE Lookup MARC. AUSME in T006A to get Base Unit External Code NVARCSTR 3 0 0 yes 49 UOM_CODE_ISSUE Lookup MARC. AUSME in T006A to get Unit of NVARCSTR Issue Long Description Lookup MARC. FRTME in T006A to get Production UOM External code 3 0 0 yes 50 UOM_CODE_PROD NVARCSTR 3 0 0 yes 51 UOM_ID_BASE MEINS Base unit of measure NVARCSTR 3 0 0 yes 52 UOM_ID_ISSUE MARC. AUSME - Unit of measure for goods issue NVARCSTR 3 0 0 yes Rapid Mart Data Schema 31 Appendix Table Column Details A 53 UOM_ID_PROD MARC. FRTME Production unit of measure NVARCSTR 3 0 0 yes MATERIAL_GROUP T023T - Material Group # Column Name Key Column Desc Column Datatype Dtype Length Precision Scale Is Nullable 1 LOAD_DATE Date and Time Loaded into Rapid Mart DATETIME 24 0 9 yes 2 LOAD_TIME Time Loaded into Rapid Mart NVARCSTR 8 0 0 yes 3 MTRL_GRP_DESCR Material Group Description NVARCSTR 20 0 0 yes 4 MTRL_GRP_ID PK Material Group ID NVARCSTR 9 0 0 no PAYMENT_TERM Table of explanations of payment term keys # Column Name Key Column Desc Column Datatype Dtype Length Precision Scale Is Nullable 1 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 2 LOAD_TIME NVARCSTR 8 0 0 yes 3 PAYMNT_TERM_DA Y_LIMIT PAYMNT_TERM_DE SCR PK Day limit NVARCSTR 2 0 0 no 4 Description of payment terms NVARCSTR 50 0 0 yes 5 PAYMNT_TERM_ID PK Payment terms key NVARCSTR 4 0 0 no Rapid Mart Data Schema 32 Appendix Table Column Details A PLANT Contains Plant Level Information # Column Name Key Column Desc Column Datatype Dtype Length Precision Scale Is Nullable 1 ADDRESS_ID Address ID NVARCSTR 10 0 0 yes 2 BATCH_STATUS_FLA G Batch Status Flag NVARCSTR 5 0 0 yes 3 CITY T001W. ORT01 CIty NVARCSTR 40 0 0 yes 4 CMPNY_CODE_ID Company code NVARCSTR 4 0 0 yes 5 CMPNY_CODE_NAME Company Code Name NVARCSTR 40 0 0 yes 6 COUNTRY_ID Country ID (Abbreviation) NVARCSTR 3 0 0 yes 7 COUNTRY_NAME Country Name (Full Name) NVARCSTR 15 0 0 yes 8 CTRL_AREA_ID Controlling area code NVARCSTR 4 0 0 yes 9 CTRL_AREA_NAME Control Area Name NVARCSTR 25 0 0 yes 10 DISTRICT District NVARCSTR 40 0 0 yes 11 FAX Fax Number NVARCSTR 40 0 0 yes 12 HOUSE_NUMBER House Number NVARCSTR 10 0 0 yes 13 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 14 LOAD_TIME NVARCSTR 8 0 0 yes 15 PHONE Phone NVARCSTR 30 0 0 yes 16 PLANT_FULL_NAME ID and Name NVARCSTR 120 0 0 yes Rapid Mart Data Schema 33 Appendix Table Column Details A 17 PLANT_ID PK T001W. WERKS Plant NVARCSTR 4 0 0 no 18 PLANT_NAME Plant name NVARCSTR 40 0 0 yes 19 PLANT_NAME_01 T001W. NAME1 Plant Name NVARCSTR 40 0 0 yes 20 PLANT_NAME_02 T001W. NAME2 Plant Name NVARCSTR 40 0 0 yes 21 PLANT_NAME_03 Plant name 3 NVARCSTR 40 0 0 yes 22 PLANT_NAME_04 Plant name 3 NVARCSTR 40 0 0 yes 23 PURCH_ORG_ID T001W. EKORG Purchasing Organization NVARCSTR 4 0 0 yes 24 PURCH_ORG_NAME T001W. CHAZV Batch Management Status Indicator NVARCSTR 20 0 0 yes 25 REGION_ID Region ID (Abbreviation of US State NVARCSTR 3 0 0 yes 26 REGION_NAME Region Name (Full Name of US State NVARCSTR 20 0 0 yes 27 SALES_ORG_ID T001W. VKORG Sales Organization NVARCSTR 4 0 0 yes 28 SALES_ORG_NAME Sales Organization name NVARCSTR 25 0 0 yes 29 STREET Street name NVARCSTR 60 0 0 yes 30 VALUATN_AREA_ID T001. BWKEY Valuation Area Key NVARCSTR 4 0 0 yes 31 ZIP Postal Code NVARCSTR 10 0 0 yes Rapid Mart Data Schema 34 Appendix Table Column Details A PRICING_CONDITION Pricing conditions for purchasing documents from KONH/KONP/KONM/KNOW # Column Name Key Column Desc Column Datatype Dtype Length Precision Scale Is Nullable 1 CONDITN_ID PK KONH. KNUMH Condition record number NVARCSTR 10 0 0 no 2 CONDITN_SEQ_ID PK KONP. KOPOS - Sequential number of the condition Lookup text description of KONH. KOTABNR-The name of the condition table used to determine the pricing ffor a purchasing document KONH. KOTABNR - Condition table NVARCSTR 2 0 0 no 3 CONDITN_SRC_DESC R CONDITN_TABLE_NA ME NVARCSTR 60 0 0 yes 4 NVARCSTR 4 0 0 yes 5 CONDITN_TYPE_ID KONP. KSCHL - Condition type NVARCSTR 4 0 0 yes 6 CREATE_DATE KONH. ERDAT - Date on which the record was DATETIME created 24 0 9 yes 7 CURR_ID_CONDITN KONP. KONWA - Rate unit (currency) NVARCSTR 5 0 0 yes 8 LOAD_DATE $G_LOAD_DATE DATETIME 24 0 9 yes 9 LOAD_TIME $G_LOAD_TIME NVARCSTR 8 0 0 yes 10 QTY_CONDITN_UNIT KONP. KPEIN - Condition pricing unit INTEGER 4 0 0 yes 11 RATE_CONDITN KONP. KBETR - Rate (condition amount or percentage) where no scale exists DECIMAL 48 11 3 yes 12 RATE_CONDITN_SCA LE_01 RATE_CONDITN_SCA LE_02 RATE_CONDITN_SCA LE_03 RATE_CONDITN_SCA LE_04 RATE_CONDITN_SCA LE_05 KONM-KBETR - Rate (PCT or Amount) for 1st DECIMAL teir scale KONM-KBETR - Rate (PCT or Amount) for 2nd teir scale 48 11 2 yes 13 DECIMAL 48 11 2 yes 14 KONM-KBETR - Rate (PCT or Amount) for 3rd DECIMAL teir scale KONM-KBETR - Rate (PCT or Amount) for 4th DECIMAL teir scale KONM-KBETR - Rate (PCT or Amount) for 5th DECIMAL teir scale 48 11 2 yes 15 48 11 2 yes 16 48 11 2 yes Rapid Mart Data Schema 35 Appendix Table Column Details KONP. KONWA Rate unit (currency or percentage) Lookup text for KONP. BOSTA Status of the agreement A 17 RATE_UNIT_NAME NVARCSTR 5 0 0 yes 18 STATUS_NAME NVARCSTR 60 0 0 yes 19 UOM_ID_CONDITN KONP. KMEIN - Condition unit NVARCSTR 3 0 0 yes 20 VALUE_CONDITN_SC ALE_01 VALUE_CONDITN_SC ALE_02 VALUE_CONDITN_SC ALE_03 VALUE_CONDITN_SC ALE_04 VALUE_CONDITN_SC ALE_05 KONM-KSTBWM- Condition scale QTY or AMT for the 1st teir scale KONM-KSTBWM- Condition scale QTY or AMT for the 2nd teir scale KONM-KSTBWM- Condition scale QTY or AMT for the 3rd teir scale KONM-KSTBWM- Condition scale QTY or AMT for the 4th teir scale KONM-KSTBWM- Condition scale QTY or AMT for the 5th teir scale DECIMAL 48 15 3 yes 21 DECIMAL 48 15 3 yes 22 DECIMAL 48 15 3 yes 23 DECIMAL 48 15 3 yes 24 DECIMAL 48 15 3 yes Rapid Mart Data Schema 36 Appendix Table Column Details A PRICING_PROCEDURE_HZ T683S, T683U, T683T - Pricing Procedure and Subtotal Descriptions Horizontal # Column Name Key Column Desc Column Datatype Dtype Length Precision Scale Is Nullable 1 APPLICTN_ID PK T683S-KAPPL - Application NVARCSTR 2 0 0 no 2 CONDITN_SEQ_ID T683S. ZAEHK Condition counter NVARCSTR 2 0 0 yes 3 LOAD_DATE Date and Time Loaded into Rapid Mart DATETIME 24 0 9 yes 4 LOAD_TIME Time Loaded into Rapid Mart NVARCSTR 8 0 0 yes 5 PRICE_PROCEDURE_ DESCR PRICE_PROCEDURE_ PK ID T683U-VTEXT - Description NVARCSTR 30 0 0 yes 6 T683S-KALSM - Pricing Procedure NVARCSTR 6 0 0 no 7 STEP_NUM T683S. ZAEHK Condition counter NVARCSTR 3 0 0 yes 8 SUBTTL_01_DESCR T683T. VTEXT - Subtotal Description 1 NVARCSTR 30 0 0 yes 9 SUBTTL_02_DESCR T683T. VTEXT - Subtotal Description 2 NVARCSTR 30 0 0 yes 10 SUBTTL_03_DESCR T683T. VTEXT - Subtotal Description 3 NVARCSTR 30 0 0 yes 11 SUBTTL_04_DESCR T683T. VTEXT - Subtotal Description 4 NVARCSTR 30 0 0 yes 12 SUBTTL_05_DESCR T683T. VTEXT - Subtotal Description 5 NVARCSTR 30 0 0 yes 13 SUBTTL_06_DESCR T683T. VTEXT - Subtotal Description 6 NVARCSTR 30 0 0 yes 14 USAGE_ID PK T683S-KVEWE - Usage of the Condition Table NVARCSTR 1 0 0 no Rapid Mart Data Schema 37 Appendix Table Column Details A PRICING_PROCEDURE_VR T683S, T683U, T683T - Pricing Procedure and Subtotal Descriptions Vertical # Column Name Key Column Desc Column Datatype Dtype Length Precision Scale Is Nullable 1 APPLICTN_ID PK T683S-KAPPL - Application NVARCSTR 2 0 0 no 2 CONDITN_SEQ_ID PK T683S. ZAEHK - Condition counter NVARCSTR 2 0 0 no 3 LOAD_DATE Date and Time Loaded into Rapid Mart DATETIME 24 0 9 yes 4 LOAD_TIME Time Loaded into the Rapid Mart NVARCSTR 8 0 0 yes 5 PRICE_PROCEDURE_ DESCR PRICE_PROCEDURE_ PK ID T683U-VTEXT - Description (lookup) NVARCSTR 30 0 0 yes 6 T683S-KALSM - Pricing Procedure NVARCSTR 6 0 0 no 7 STEP_NUM PK T683S. STUNR - Step number NVARCSTR 3 0 0 no 8 SUBTTL_DESCR T683T, T685T-VTEXT - Description (lookup) NVARCSTR 30 0 0 yes 9 SUBTTL_ID T683S-KZWIW - Condition Subtotal NVARCSTR 1 0 0 yes 10 USAGE_ID PK T683S-KVEWE - Usage of the Condition Table NVARCSTR 1 0 0 no Rapid Mart Data Schema 38 Appendix Table Column Details A PRODUCT_HIERARCHY T179 - Product Hierarchy dimension # Column Name Key Column Desc Column Datatype Dtype Length Precision Scale Is Nullable 1 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 2 LOAD_TIME NVARCSTR 8 0 0 yes 3 LVL_01_DESCR Level 1 description NVARCSTR 40 0 0 yes 4 LVL_02_DESCR Level 2 description NVARCSTR 40 0 0 yes 5 LVL_03_DESCR Level 3 descritpion NVARCSTR 40 0 0 yes 6 PROD_DESCR Current Node description NVARCSTR 40 0 0 yes 7 PROD_HIER_ID PK Product Hierarchy Current Node ID NVARCSTR 18 0 0 no 8 PROD_LVL Node Level depth NVARCSTR 1 0 0 yes Rapid Mart Data Schema 39 Appendix Table Column Details A PROFIT_CENTER CEPC - Profit Center attributes # Column Name Key Column Desc Column Datatype Dtype Length Precision Scale Is Nullable 1 CITY City NVARCSTR 40 0 0 yes 2 COUNTRY_ID Country key NVARCSTR 3 0 0 yes 3 COUNTRY_NAME Lookup on Country name NVARCSTR 15 0 0 yes 4 CTRL_AREA_ID PK Controlling area NVARCSTR 4 0 0 no 5 CURR_ID Currency key NVARCSTR 5 0 0 yes 6 DEPARTMENT Department NVARCSTR 12 0 0 yes 7 DISTRICT District NVARCSTR 40 0 0 yes 8 FAX Fax number NVARCSTR 40 0 0 yes 9 LANG_ID Language Key NVARCSTR 1 0 0 yes 10 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 11 LOAD_TIME NVARCSTR 8 0 0 yes 12 PERSON_IN_CHARGE Person in charge of profit center NVARCSTR 20 0 0 yes 13 PHONE First telephone number NVARCSTR 30 0 0 yes 14 PROFIT_CNTR_AREA Profit center area NVARCSTR 12 0 0 yes 15 PROFIT_CNTR_DESC R PROFIT_CNTR_FULL_ NAME Name of Profit Center NVARCSTR 40 0 0 yes 16 Profit Center Name and ID NVARCSTR 120 0 0 yes Rapid Mart Data Schema 40 Appendix Table Column Details A 17 PROFIT_CNTR_ID PK Profit center NVARCSTR 10 0 0 no 18 PROFIT_CNTR_NAME Profit Center Name NVARCSTR 20 0 0 yes 19 PROFIT_CNTR_NAME _01 PROFIT_CNTR_NAME _02 PROFIT_CNTR_NAME _03 PROFIT_CNTR_NAME _04 Name 1 NVARCSTR 40 0 0 yes 20 Name 2 NVARCSTR 40 0 0 yes 21 Name 3 NVARCSTR 40 0 0 yes 22 Name 4 NVARCSTR 40 0 0 yes 23 REGION_ID Abbreviation of Region (State) NVARCSTR 3 0 0 yes 24 REGION_NAME Name of Region (State) NVARCSTR 20 0 0 yes 25 SEGMENT_DESCR Segment Description NVARCSTR 50 0 0 yes 26 SEGMENT_ID Segment ID for Segmental Reporting NVARCSTR 10 0 0 yes 27 STREET House number and street NVARCSTR 60 0 0 yes 28 VALID_FROM_DATE Valid-from date DATETIME 24 0 9 yes 29 VALID_TO_DATE Valid to date DATETIME 24 0 9 yes 30 ZIP Postal Code NVARCSTR 10 0 0 yes Rapid Mart Data Schema 41 Appendix Table Column Details A PROFIT_CENTER_HIER CCSS-RPRCTR - Profit Center Hierarchy- cannot have primary key due to possible duplicate entries in SAP # Column Name Key Column Desc Column Datatype Dtype Length Precision Scale Is Nullable 1 CHILD_DESCR Profit Center Child Node Description NVARCSTR 64 0 0 yes 2 CHILD_ID PK Profit Center Child Node ID NVARCSTR 10 0 0 no 3 CTRL_AREA_ID PK Controlling Area ID NVARCSTR 4 0 0 no 4 LEAF_FLAG PK Node Is Leaf NVARCSTR 1 0 0 no 5 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 6 LOAD_TIME NVARCSTR 8 0 0 yes 7 PARENT_DESCR Profit Center Parent Node Descritpion NVARCSTR 64 0 0 yes 8 PARENT_ID PK Profit Center Parent Node ID NVARCSTR 10 0 0 no 9 ROOT_FLAG PK Node is Root NVARCSTR 1 0 0 no Rapid Mart Data Schema 42 Appendix Table Column Details A PROFIT_CENTER_HIER_BAD CCSS-RPRCTR - Profit Center Hierarchy table with invalid records- cannot have primary key due to possible duplicate entries in SAP # Column Name Key Column Desc Column Datatype Dtype Length Precision Scale Is Nullable 1 CHILD_DESCR Child Description NVARCSTR 64 0 0 yes 2 CHILD_ID PK Child NVARCSTR 10 0 0 no 3 CTRL_AREA_ID PK Control Area ID NVARCSTR 4 0 0 no 4 ETL_ERROR_ACTN Data Integrator Action on Error NVARCSTR 1 0 0 yes 5 ETL_ERROR_COLU MN Data Integrator Error message NVARCSTR 500 0 0 yes 6 LEAF_FLAG PK Leaf Flag NVARCSTR 1 0 0 no 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 PARENT_DESCR Parent Description NVARCSTR 64 0 0 yes 10 PARENT_ID PK Parent ID NVARCSTR 10 0 0 no 11 ROOT_FLAG PK Root Flag NVARCSTR 1 0 0 no Rapid Mart Data Schema 43 Appendix Table Column Details A PROFIT_CENTER_HIER_HZ CCSS-RPRCTR - Profit Center hierarchy horizontally flattenned- cannot have primary key due to possible duplicate entries in SAP # Column Name Key Column Desc Column Datatype Dtype Length Precision Scale Is Nullable 1 CTRL_AREA_ID PK Controlling Area ID NVARCSTR 4 0 0 no 2 LEAF_LVL Current Node level depth DECIMAL 48 10 0 no 3 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 4 LOAD_TIME NVARCSTR 8 0 0 yes 5 LVL_00_DESCR Profit Center Root node Description NVARCSTR 64 0 0 yes 6 LVL_00_FULL_NAME Profit Center ID and Description for the root NVARCSTR 120 0 0 yes 7 LVL_00_ID PK Profit Center Root node ID NVARCSTR 10 0 0 no 8 LVL_01_DESCR Profit Center Level 1 node Description NVARCSTR 64 0 0 yes 9 LVL_01_FULL_NAME Profit Center ID and Description for Level 1 NVARCSTR 120 0 0 yes 10 LVL_01_ID PK Profit Center Level 1 node ID NVARCSTR 10 0 0 no 11 LVL_02_DESCR Profit Center Level 2 node Description NVARCSTR 64 0 0 yes 12 LVL_02_FULL_NAME Prifit Center ID and Descritption for Level 2 NVARCSTR 120 0 0 yes 13 LVL_02_ID PK Profit Center Level 2 node ID NVARCSTR 10 0 0 no 14 LVL_03_DESCR Profit Center Level 3 node Description NVARCSTR 64 0 0 yes 15 LVL_03_FULL_NAME Profit Center Id and Description NVARCSTR 120 0 0 yes 16 LVL_03_ID PK Profit Center Level 3 node ID NVARCSTR 10 0 0 no Rapid Mart Data Schema 44 Appendix Table Column Details A 17 LVL_04_DESCR Profit Center Level 4 node Description NVARCSTR 64 0 0 yes 18 LVL_04_FULL_NAME Priofit Center ID and Description for Level 4 NVARCSTR 120 0 0 yes 19 LVL_04_ID PK Profit Center Level 4 node ID NVARCSTR 10 0 0 no 20 LVL_05_DESCR Profit Center Level 5 node Description NVARCSTR 64 0 0 yes 21 LVL_05_FULL_NAME Profit Center Id and Descritpion for Level 5 NVARCSTR 120 0 0 yes 22 LVL_05_ID PK Profit Center Level 5 node ID NVARCSTR 10 0 0 no 23 LVL_06_DESCR Profit Center Level 6 node Description NVARCSTR 64 0 0 yes 24 LVL_06_FULL_NAME Profit Center Id and Descripiton for Level 6 NVARCSTR 120 0 0 yes 25 LVL_06_ID PK Profit Center Level 6 node ID NVARCSTR 10 0 0 no 26 LVL_07_DESCR Profit Center Level 7 node Description NVARCSTR 64 0 0 yes 27 LVL_07_FULL_NAME Profit Center Id and Descritpion for level 7 NVARCSTR 120 0 0 yes 28 LVL_07_ID PK Profit Center Level 7 node ID NVARCSTR 10 0 0 no 29 LVL_08_DESCR Profit Center Level 8 node Description NVARCSTR 64 0 0 yes 30 LVL_08_FULL_NAME Profit Center Id and Descritpion for level 8 NVARCSTR 120 0 0 yes 31 LVL_08_ID PK Profit Center Level 8 node ID NVARCSTR 10 0 0 no 32 LVL_09_DESCR Profit Center Level 9 node Description NVARCSTR 64 0 0 yes 33 LVL_09_FULL_NAME Profit Center Id and Descritpion for Level 9 NVARCSTR 120 0 0 yes 34 LVL_09_ID PK Profit Center Level 9 node ID NVARCSTR 10 0 0 no Rapid Mart Data Schema 45 Appendix Table Column Details A 35 LVL_10_DESCR Profit Center Level 10 node Description NVARCSTR 64 0 0 yes 36 LVL_10_FULL_NAME Profit Center Id and Descritpion for Level 10 NVARCSTR 120 0 0 yes 37 LVL_10_ID PK Profit Center Level 10 node ID NVARCSTR 10 0 0 no 38 PROFIT_CNTR_ID PK Profit Center ID NVARCSTR 10 0 0 no PROFIT_CENTER_HIER_VR CCSS-RPRCTR Profit Center Hierarchy vertically flattenned- cannot have primary key due to possible duplicate entries in SAP # Column Name Key Column Desc Column Datatype Dtype Length Precision Scale Is Nullable 1 CHILD_DESCR Child Node Descritpion for Profit Center NVARCSTR 64 0 0 yes 2 CHILD_FULL_NAME Profit Center (Child) ID and Descritpion NVARCSTR 120 0 0 yes 3 CHILD_ID PK Child Node ID for Profit Center NVARCSTR 10 0 0 no 4 CTRL_AREA_ID PK Controlling Center ID NVARCSTR 4 0 0 no 5 DEPTH Current Child Node Depth INTEGER 4 0 0 yes 6 LEAF_FLAG Current Node is Leaf INTEGER 4 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 PARENT_DESCR Parent Node Descritpion for Profit Center NVARCSTR 64 0 0 yes 10 PARENT_FULL_NAME Profit Center (Parent) ID and Descritpion NVARCSTR 120 0 0 yes 11 PARENT_ID PK Parent Node ID for Profit Center NVARCSTR 10 0 0 no 12 ROOT_FLAG Current Node is Root INTEGER 4 0 0 yes Rapid Mart Data Schema 46 Appendix Table Column Details A PURCH_DOC_FACT EKKO/EKPO - Purchasing Documents details at line item (EKKO = Header, EKPO = Line items) # Column Name Key Column Desc Column Datatype Dtype Length Precision Scale Is Nullable 1 ACCT_ASSIGN_CATE PK G_ID ACKNOWLEDGE_FL AG AMT_AGREE_PLAN_T RX EKPO. KNTTP - Account assignment category NVARCSTR 1 0 0 yes 2 EKPO. KZABS - Indicator: acknowledgment required NVARCSTR 1 0 0 yes 3 EKKO. KTWRT- Cumulative planned value DECIMAL 48 28 2 yes 4 AMT_GROSS_LOC Purchase order gross value (in Local currency) DECIMAL 48 28 2 yes 5 AMT_GROSS_TRX EKPO. BRTWR - Purchase order gross value in DECIMAL order currency 48 28 2 yes 6 AMT_NET_LOC Purch. [. . . ]