Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
Skip to end of metadata
Go to start of metadata

This is the Landing Page

Page: A-AD Administration Module SQL Posted to Wiki Page: B-FN Financials Module SQL Posted to Wiki Page: C-SO Sales Opportunities Module SQL Posted to Wiki Page: D-SL Sales AR Module SQL Posted to Wiki Page: E-PU Purchasing AP Module SQL Posted to Wiki Page: F-BP Business Partner Module SQL Posted to Wiki Page: G-BK Banking Module SQL Posted to Wiki Page: H-IN Inventory Module SQL Posted to Wiki Page: I-PR Production Module SQL Posted to Wiki Page: J-MR MRP Module SQL Posted to Wiki Page: K-SR Services Module SQL Posted to Wiki Page: L-HR Human Resources Module SQL Posted to Wiki Page: SAP B1 D-SL Sales and Buy FIFO Price for Batch managed Items Page: SAP B1 D-SL Sales and Purchase FIFO Price for Non-Batch Items Page: SAP B1 SQL A-AD Alert Message AP Invoices Coming or Past Due Page: SAP B1 SQL A-AD Alert Message Negative Inventory in Stock By Warehouse and Total Page: SAP B1 SQL A-AD Alert Message Tax Code Missing From Address Page: SAP B1 SQL B-FN Debtors Aging Report by date Page: SAP B1 SQL B-FN General Ledger Report with Account Code and Date Range as Selection Criteria Page: SAP B1 SQL B-FN Journal Entry Detail by Date Range Page: SAP B1 SQL Contributors' Tips and Tricks Page: SAP B1 SQL D-SL AR Inv and CM List by Gross Profit Page: SAP B1 SQL D-SL AR Invoices and Credit Memos by Sales Person and Date Range Page: SAP B1 SQL D-SL Calculate Sales profitability based on B2B Orders Page: SAP B1 SQL D-SL Lapsed Days Order to Deliveries Order Details Ver 3 Page: SAP B1 SQL D-SL Late Sales Order by Date Range Page: SAP B1 SQL D-SL Sales Register by Invoices for Indian Localization Page: SAP B1 SQL D-SL Sales Register by Item for Indian Localization Page: SAP B1 SQL E-PU Priority Items To Be Purchased Page: SAP B1 SQL E-PU Purchase Analysis Report Page: SAP B1 SQL E-PU Purchases Register by Item for Indian Localization Page: SAP B1 SQL E-PU Supplier Open Invoices by Due Date Page: SAP B1 SQL E-PU Validation and approval when Invoice Value is more than order Page: SAP B1 SQL F-BP BP Data Check from DIE Page: SAP B1 SQL F-BP Tax Code Workstation Page: SAP B1 SQL G-BK Deposit with AR Invoices from Lockbox Page: SAP B1 SQL G-BK Incoming Payments with Payments On Account Page: SAP B1 SQL G-BK Payments by Bank Transfer within Date Range Page: SAP B1 SQL H-IN Display Item Usage in Item Master Data Screen Page: SAP B1 SQL H-IN Item Inventory Details for ST Postings During Inventory Page: SAP B1 SQL H-IN Item Inventory Opening and Closing Stock per warehouse Page: SAP B1 SQL H-IN Item Prices in Each Price List Page: SAP B1 SQL I-PR Components within Bills of Material for Any or All Page: SAP B1 SQL I-PR To Check the Components upto 6 levels deep into a BOM Page: SAP B1 SQL -Item Wise - Warehouse Wise Stock Report Page: SAP B1 SQL J-MR Minimum Data Check for MRP Completeness Page: SAP B1 SQL Links and Additional Information Page: SAP B1 SQL S-FS Autogenerate Card Code Based on Card Type Page: SAP B1 SQL S-FS Average Lapsed Days Page: SAP B1 SQL S-FS In-Stock of Specified Warehouse in Row level of marketing document Page: SAP B1 SQL S-FS Tax Code Autopopulate in BP Address Page: SAP B1 SQL Standards and Notes Page: SAP B1 SQL Suggested Standards - Basic Outline of the SQL Page: SAP B1 SQL Tips and Tricks Page: SAP B1 SQL V-MS Listing of All SQL on System Page: SAP B1-SQL Z-TS Block Receipt of Final Product without Component Issue Page: SAP B1-SQL Z-TS Block users entering duplicate reference number on Sales Purchase Order documents Page: SAP B1 SQL Z-TS Prevent Duplicate Barcodes for Item Page: SAP B1 SQL Z-TS Restrict Documents without Base Documents Page: SAP B1 SQL Z-TS Restrict negative balance for Cash account in Outgoing Payment Page: SAP B1 SQL Z-TS Setting Mandatory Field Page: S-FS Formatted Searches SQL Posted to Wiki Page: V-MS Micellaneous Items SQL Posted to Wiki Page: Y-SP Stored Procedures for SQL Posted to Wiki Page: Z-TS Transaction Notification SQL Scripts Posted to Wiki

1 Comment

  1. Guest

    My comment is actually a question and I'm not sure if this is the right place to post this. If we are using SQL Server 2008 R2, why can't we use, in a query

    the line, for example, sum(T1.[Quantity]) OVER (PARTITION BY T2.[FrgnName] ORDER BY T1.[ItemCode] Running_Total. The error that comes up is:

    1.) [Microsoft][SQL Server Native Client 10.0] [SQL Server]Incorrect syntax near 'order'.

    2). [Microsot][SWQL Server Native Client 10.0][SQL Server] Statement 'User-Defined Values' (CSHS) (s) could not be prepared.

    I am attempting to run a 'Running Total' on certain items that have been ordered for a certain 'CreateDate' period without having the running_total repeating on

    everyline like it does now. Thank you.