![]() WHERE T1."RefDate" >= and T1."RefDate" = and T2."CardCode" <= and T2."CardType"='C' Note that you must use deep insert requests (a header plus the following entities: header partner, header pricing element, header text, header related object, item. Stam Tables 25, /DSD/SLTCSTAMAP, DSD Route Settlement:Document Ctrl.Customer Sales Trans.Type 26, /DSD/SLTCSTAMV, Generated Table for View /DSD/SLTCstamV. You will get more details about each transaction code by clicking on the tcode name. LEFT OUTER JOIN OCRG T4 ON T2."GroupCode" = T4."GroupCode" You can read entire sales quotations or only parts of the data, using the provided filters. Here is a list of possible Sales order quotation related transaction codes in SAP. 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) ,SUM(IFNULL(T0."Debit",0) - IFNULL(T0."Credit",0)) as "Amount(LC)" SAP Customer Relationship Management 7.0 EHP2. 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. You can read entire sales quotations or only parts of the data, using the provided filters. ![]() 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" This document should provide some answers to frequently asked question around sales quote processing in SAP Cloud for Customer. 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. 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. Overview on Sales Quotes in SAP Cloud for Customer.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |