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. 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. [. . . ] Financial Record Category - Categorization for a financial document. 238 SAP BusinessObjects Sales Rapid Mart XI 3. 2 for SAP solutions User Guide Universe SAP Master Data Universe 5 · · · · Financial Record Type - Special Ledger Record Types (Domain RRCTY) from table DD07T and Cost/Plant Maintenance value types from CO_WRTTP domain of DD07T table Financial Version - Special Ledger Version (T894T table in SAP solutions) Ledger Group - A combination of ledgers for the purpose of applying the functions and processes of general ledger accounting to the group as a whole. Payment Block - An indicator that allows you (by entering a payment block) to block an account or individual items for payment. The payment blocking indicator is placed in the customer or vendor's master record, or in the line item. from table T008T - indicates any Holds preventing payment to a vendor. Payment Reason - From table T053S - Classification of Payment Differences (Texts) Payment Term - Relevant only for Financial Documents, describes when payments to a vendor or from a customer are due. Also describes any discounts associated with early payment. Posting Key Type -The posting key defines if it is a debit or credit posting, and which account type (customer or vendor) is posted. The posting keys for special G/L transactions must be indicated as such. Reference Procedure - Object Type Names for Accounting (TTYPT). Segment - A division of a company that can create its own financial statements for external reporting. A segment can be entered in the master record of a profit center. The segment is then derived from the assigned profit center during posting. It is available in New GL only (release ECC 5. 0 or higher). Special GL Indicators - Special G/L transactions are special transactions in accounts receivable and accounts payable that are displayed separately in the general ledger and the subledger. This is achieved by posting to alternative reconciliation accounts, instead of posting to the reconciliation accounts for receivables and payables. Special Ledger Master - Identifies the Standard or Special Ledger used. · · · · · · · SAP BusinessObjects Sales Rapid Mart XI 3. 2 for SAP solutions User Guide 239 5 Universe SAP Master Data Universe · Transaction Type - Transaction type of the Financial Document from table T856T. Account Assignment Category - A key indicating whether an item is to be assigned to an auxiliary account (such as a cost center). The account assignment category determines which account assignment details are required for the item (for example, cost center or account number). Condition Type - Identification that defines characteristics, attributes, and business meaning of a condition. The system can, for example, contain different condition types for freegoods, sales-based rebate, or gross price discount. Every condition type has its own access sequences, condition tables, and condition records. Purchase Document Price History - A series of prices charged or quoted by a vendor for a material or service over a certain period up to the present. [. . . ] A positive number indicates an early delivery. A negative INTEGER number indicates a late delivery. Line) NVARCSTR 4 0 0 yes 13 DELIV_BLOCK_ID 2 0 0 yes 14 DELIV_BLOCK_ID_HD R VBAK-LIFSK - Delivery block (document header) NVARCSTR 2 0 0 yes 15 DELIV_ID PK LIPS-VBELN - Delivery NVARCSTR 10 0 0 no 16 DELIV_LINE_ITEM_ID PK LIPS-POSNR - Delivery Item NVARCSTR 6 0 0 no Rapid Mart Data Schema 55 Appendix Table Column Details A 17 DELIV_STATUS_FLAG Is this Delivery On Time, Early, or Late? NVARCSTR 10 0 0 yes 18 DISTRIBTN_CHANNEL PK _ID VBAK-VTWEG - Distribution Channel NVARCSTR 2 0 0 yes 19 DISTRICT_SHIPTO District NVARCSTR 40 0 0 yes 20 DIVISION_ID VBAK-SPART - Division NVARCSTR 2 0 0 yes 21 HOUSE_NUM_SHIPTO House number NVARCSTR 10 0 0 yes 22 INTER_CMPNY_TERM PK 01_ID INTER_CMPNY_TERM 02_NAME VBKD. INCO1 - IncoTerms Part 1 NVARCSTR 3 0 0 yes 23 VBKD. INCO2 - IncoTerms Part 2 NVARCSTR 28 0 0 yes 24 LOAD_DATE Date and Time Extracted from SAP DATETIME 24 0 9 yes 25 LOAD_TIME Time when the record was loaded into the target database NVARCSTR 8 0 0 yes 26 MATERIAL_ID PK VBAP-MATNR - Material Number NVARCSTR 18 0 0 yes 27 NAME_01_SHIPTO Name 1 NVARCSTR 40 0 0 yes 28 NAME_02_SHIPTO Name 2 NVARCSTR 40 0 0 yes 29 NAME_03_SHIPTO Name 3 NVARCSTR 40 0 0 yes 30 NAME_04_SHIPTO Name 4 NVARCSTR 40 0 0 yes 31 PHONE_SHIPTO First telephone no. : dialling code+number NVARCSTR 30 0 0 yes 32 PLANT_ID PK VBAP-WERKS -- Plant NVARCSTR 4 0 0 yes 33 PROD_HIER_ID VBAP. PRODH Product Hierarchy NVARCSTR 18 0 0 yes 34 QTY_ALLOCTN_SLSU OM Sched Line Qty allocated to the Delivery DECIMAL 48 13 3 yes Rapid Mart Data Schema 56 Appendix Table Column Details LIPS-LFIMG - Actual Qties Delivered (in Sales DECIMAL Units) VBAP- KWMENG - Cumulative Order Quantity DECIMAL in Sales Units A 35 QTY_DELIV_SLSUOM 48 13 3 yes 36 QTY_ORDER_SLSU OM QTY_SCHED_CONFIR M_SLSUOM 48 15 3 yes 37 Schdeule line confirmed quantity DECIMAL 48 13 3 yes 38 REGION_ID_SHIPTO Region (State, Province, County) ID NVARCSTR 3 0 0 yes 39 REGION_NAME_SHIP TO Region (State, Province, County) Name NVARCSTR 20 0 0 yes 40 SALES_DOC_ID PK Sales Order Number NVARCSTR 10 0 0 no 41 SALES_LINE_ITEM_ID PK Sales Order Item number NVARCSTR 6 0 0 no 42 SALES_OFFICE_ID PK VBAK-VKBUR - Sales office NVARCSTR 4 0 0 yes 43 SALES_ORG_ID PK VBAK-VKORG - Sales Organization NVARCSTR 4 0 0 yes 44 SALES_PERSON_ID PK VBPA-PERNR - Sales person ID NVARCSTR 8 0 0 yes 45 SCHED_GI_DATE Schedule line goods issue date DATETIME 24 0 9 yes 46 SCHED_LINE_ITEM_I D PK Schedule line number NVARCSTR 4 0 0 no 47 STREET_SHIPTO Street NVARCSTR 60 0 0 yes 48 ZIP_SHIPTO City Postal Code NVARCSTR 10 0 0 yes Rapid Mart Data Schema 57 Appendix Table Column Details A ONTIME_DELIVERY_HISTORY History table for On Time Delivery - Contains Previous snapshots # Column Name Key Column Desc Column Datatype Dtype Length Precision Scale Is Nullable 1 ACTL_GI_DATE PK LIKP. WADAT_IST - Actual Goods Issue Date DATETIME 24 0 9 yes 2 AMT_NET_PRICE_GB L AMT_NET_PRICE_TR X CHANGE_STATUS_FL AG VBAP-NETPR - Net Price DECIMAL 48 11 2 yes 3 VBAP-NETPR - Net Price DECIMAL 48 11 2 yes 4 Is this a New, Changed, or Deleted Record? NVARCSTR 10 0 0 yes 5 CITY_SHIPTO City NVARCSTR 40 0 0 yes 6 COUNTRY_ID_SHIPT O COUNTRY_NAME_SHI PTO Country ID NVARCSTR 3 0 0 yes 7 Country Name NVARCSTR 20 0 0 yes 8 CURR_ID_GBL PK Global currency code NVARCSTR 5 0 0 yes 9 CURR_ID_TRX PK Sales order currency code (document) NVARCSTR 5 0 0 yes 10 CUSTOMER_ID_SHIP TO VBPA-KUNNR - Customer Number (lookup) NVARCSTR 10 0 0 yes 11 CUSTOMER_PO_NUM VBAK-BSTNK - Customer purchase order number NVARCSTR 20 0 0 yes 12 DAYS_EARLY_LATE Difference between Sched. Goods Issue Date and Actual Goods Issue Date. [. . . ]