![]() ![]() This is a preview of a SAP Knowledge Base Article. KBA, LOD-LE-CQP, Customer Quote Processing, How To. SAP Cloud for Customer add-ins all versions. GROUP BY T0."ShortName",T2."CardName",T3."IndDesc",T4."GroupName", T0."FCCurrency",T5."MainCurncy",T0. This document should provide some answers to frequently asked question around sales quote processing in SAP Cloud for Customer. WHERE T1."RefDate" >= and T1."RefDate" = and T2."CardCode" <= and T2."CardType"='C' LEFT OUTER JOIN OCRG T4 ON T2."GroupCode" = T4."GroupCode" LEFT OUTER JOIN OOND T3 ON T2."Industr圜" = T3."IndCode" LEFT OUTER JOIN OCRD T2 ON T2."CardCode" = T0."ShortName" LEFT OUTER JOIN OJDT T1 ON T1."TransId" = T0."TransId" and T0."TransType" IN (13,14) Transaction code: CKAPP03 with the SAP program: SAPRCKAPP03 (Sales Order Item. SAP Knowledge Base Article - Public 3137214-In the sales quotation the field WBS Element cannot be used Symptom The following error message is displayed while processing a sales quotation: E: You cannot assign this WBS element to this sales document type. solutions for SQL query problems, and is full of concrete real-world examples to help you create and troubleshoot your SQL queries in SAP Business One. ,SUM(IFNULL(T0."Debit",0) - IFNULL(T0."Credit",0)) as "Amount(LC)" Sales and Distribution (SD) The sales and distribution logistics module handles the entire process from order to delivery. SELECT T0."ShortName" as "Customer Code", T2."CardName" as "Customer Name",T3."IndDesc",T4."GroupName",Ĭase when T0."FCCurrency" is null then T5."MainCurncy" else "FCCurrency" end as "Currency" We are using SAP HANA and SAP B1 version 9.0. ![]() Amount pulled out was gross of GST/VAT but should be exclusive of GST/VAT. CASE WHEN T0.TransType 13 THEN 'A/R Invoices' WHEN T0.TransType 14 THEN 'A/R Credit Memos' WHEN T0.TransType 15 THEN 'Deliveries' WHEN T0.TransType 16 THEN 'Returns' WHEN T0.TransType 18 THEN 'A/P Invoices' WHEN T0.TransType 19 THEN 'A/P Credit Memos' WHEN T0.TransType 20 THEN 'Goods Receipt PO' WHEN T0.TransType 21 THEN 'A/P Ret. I am trying to recreate the SAP Business One Sales Analysis Report by customer as there are additional fields that need to be presented in the report. ![]()
0 Comments
Leave a Reply. |