自定义博客皮肤VIP专享

*博客头图:

格式为PNG、JPG,宽度*高度大于1920*100像素,不超过2MB,主视觉建议放在右侧,请参照线上博客头图

请上传大于1920*100像素的图片!

博客底图:

图片格式为PNG、JPG,不超过1MB,可上下左右平铺至整个背景

栏目图:

图片格式为PNG、JPG,图片宽度*高度为300*38像素,不超过0.5MB

主标题颜色:

RGB颜色,例如:#AFAFAF

Hover:

RGB颜色,例如:#AFAFAF

副标题颜色:

RGB颜色,例如:#AFAFAF

自定义博客皮肤

-+

SAP BLOG--Jack Wu

人生最要紧的是充实自己,让自己的视野更广阔,让自己的脑筋更灵活,让自己看事情更准确,让自己与别人相处更和谐,让自己对群体有越来越多的贡献.......

  • 博客(646)
  • 资源 (10)
  • 收藏
  • 关注

原创 SAP--我的blog连接整理

我的blog的文章越来越多,CSDN又没有提供很好的分类管理的方法,我自己想将相关文章进行分类连接整理,希望大家多提建议。 SAP SDNumDescription  0SD--Enterprise Structure Configuration0.1 SD--SD业务的简图1sd--关于定价技

2008-12-19 12:19:00 13883 13

原创 如何在Power BI中实现主页显示一个月,Tools显示前N个月的数据?

在主页显示当月的数据,同时要求在Tooltips中显示前六个月的趋势变化数据。

2022-03-11 08:30:37 3574 2

原创 如何在POWER BI中翻转90度显示标题?

如何在POWER BI中翻转90度显示标题?

2022-03-10 21:38:43 1778

原创 如何用RVisualization 输出X轴,y轴的双轴百分比堆积条形图

用户需求:在最近的POWER BI项目,用户的需求如下:实现在x轴按渠道的占比显示宽度,在y轴按品牌的在各个渠道的占比显示高度。Power BI有个控件可以实现改需求,但是这是一个付费控件。我们最终使用R Script Visual实现需求。实现效果:带代码摘抄:# The following code to create a dataframe and remove duplicated rows is always executed and acts as a preamb.

2021-07-28 08:33:09 549

原创 ABAP--如何使用SO_NEW_DOCUMENT_ATT_SEND_API1发送EXCEL附件

在工作中我们常常会需要将一些信息用EXCEL格式的附件发送给用户,本文就简单讲讲如何使用SO_NEW_DOCUMENT_ATT_SEND_API1发送EXCEL附件。1、提取数据;根据应用需求决定,本文以发送订单信息为例,代码略)2、生成EXCEL格式的发送内表;FORMCreate_EXCELBody.Data:ls_tvbdpaLIKEvbdpa,ls_text(18),ls_linetypestring,ls_si...

2021-03-13 11:35:53 3374

原创 ABAP-如何发送EXCEL附件

在工作中,我们常常需要将订单、出库单和发票等单据用excel的方式发给用户或者客户。网上有很多的相关的代码,但简洁已于使用的还是SAP的样例代码,请参见BCS_EXAMPLE_7sap代码我摘抄如下:reportbcs_example_7.*ThisreportprovidesanexampleforsendinganExcel*attachmentinUnicodeSystemsconstants:gc_tabtypecvaluecl_bcs_...

2021-03-12 13:27:45 1783

原创 ABAP-如何发用邮件附件的方式发送订单打印的PDF

在工作中,我们常常会遇到以邮件附件的方式发送SAP的订单,出库单或者发票等信息给客户。我这里将实现摘抄下来,供大家参考:1、设计订单打印smarfform(这就不累述了)2、设计订单打印程序:几个关键代码照抄如下:2.1 调用打印程序生成PDF*---------------------------------------------------------------------**FORMPROCESSING...

2021-03-12 13:12:25 1898

原创 ABAP如何发送带EXCEL附件的邮件代码摘抄

reportbcs_example_7.*ThisreportprovidesanexampleforsendinganExcel*attachmentinUnicodeSystemsconstants:gc_tabtypecvaluecl_bcs_convert=>gc_tab,gc_crlftypecvaluecl_bcs_convert=>gc_crlf.parameters:mailtotypead_smtpad...

2021-02-20 14:10:05 1028

原创 如何将打印报表作为PDF附件发送的代码样例

*----------------------------------------------------------------------**ReportBCS_EXAMPLE_6*----------------------------------------------------------------------**EmaildocumentsusingPDFbasedforms*----------------------------------...

2021-02-20 14:08:53 428

原创 通过ABAP程序批量修改合作伙伴

REPORT Y0000SD_KNVP_UPDATE.TYPE-POOLS: slis.TYPES: ty_tab TYPE line OCCURS 10.TYPES: BEGIN OF ty_kunnr, kunnr TYPE kunnr, END OF ty_kunnr.DATA: gv_file TYPE string.DATA: gt_tab TYPE ty_tab, gs_line TYPE line, gs_knvp TY...

2021-01-22 13:53:57 971

转载 如何设计报表读取价格条件数据?

ummaryThis post narrates the use of Runtime Type services to generate Dynamic ALV Grid Report for Pricing Condition Master Records.Author(s): Vinod Kumar T Company: NIIT Technologies LimitedCreated on: 29.10.2010Author(s) BioVinod Kumar is...

2020-10-16 11:39:04 785

转载 FAQ in Billing Cancellation

You'll be able to easily find out the answer/solution by yourself for the most frequently asked questions in SDBilling Cancellation area on this page.For an easier search, you can use Ctrl + F to f...

2020-04-09 13:52:52 823

转载 FAQ in Accounting document creation from SD (SD-FI Interface)

You'll be able to easily find out the answer/solution by yourself for the most frequently asked questions in SD-FI interface on this page.For an easier search, you can use Ctrl + F to find a specifi...

2020-04-09 13:50:44 3674

转载 FAQ in SD-BIL-IV - Processing of billing documents

You'll be able to easily find out the answer/solution by yourself for the most frequently asked questions in SDBilling documentsarea on this page.For an easier search, you can use Ctrl + F to find...

2020-04-09 13:48:22 1586

转载 930870 - Determination, valuation, and quantity adjustment of conditions

SymptomThis note explains the meaning of the terms"(Re)determination" "(Re)valuation"and"Quantity adjustment"of conditions in R/3 pricing:1. (Re)determination of conditions:In connectio...

2019-09-30 14:28:00 746

转载 900089 - Pricing: FORM XKOMV_BEWERTEN processing steps

SymptomThis SAP Note describes the following: a) The sequence in which the most important processing steps are performed during the valuation of the pricing result (FORM XKOMV_BEWERTEN, include L...

2019-09-30 14:03:20 1897

原创 SD-如何利用BTE在VKxx显示特殊文本

在SAP的价格维护中,我们经常会自定义一些字段,有时这些字段非系统标准字段,无法显示文本,但需要在维护时显示文本或者显示特殊文本。本文就给出用户输入条形码,显示对应物料名称的样例。在系统中我们会找到四个BTE和定价维护相关:00503303 Maintain conditions: Transfers 00503305 Maintain conditions: Field check ...

2019-04-01 10:24:17 751 1

转载 Note 886532 - Pricing: Displaying and rounding numbers

SymptomThis consulting note describesa) why certain data fields are displayed differently on screen than they are in the databaseandb) which effects the use of fixed point arithmetic has on ...

2019-03-12 11:46:19 459 1

原创 为什么output type condition记录已经维护,但输出不能自动创建IDOC

 今天碰到一个问题,在创建销售订单是,Output type condition记录已经维护,但输出不能自动创建Message?查看了Output type condition记录已经读取,但在NAST表中却无记录。后来查看代码,发现系统在生成NAST记录时,会做一些数据检查。如果检查发现错误,则不生成消息记录。本次问题是因为Partner Profiles的主数据没有维护,系统根据通...

2019-01-29 16:14:13 1463 1

转载 如何实现PO的输出向客户发送邮件的增强

Enhance Email – NACE – PurchasingEmailing outputs to partners is a standard out-of-the-box feature in SAP Output Control. This blog explains enhancement options available in case you want to control...

2019-01-15 09:22:42 2404

转载 如何选择正确的读取SD的数据表,提高程序性能

SD Table Access – SAP Note 185530Read SAP Note 185530 before developing new SD report or if your SD report is running slow.1. Accesses to sales orders (tables VBAK, VBAP)Search orders for custom...

2019-01-15 09:12:16 522

转载 使用函数RP_CALC_DATE_IN_INTERVAL进行日期的年月日的加减

data LV_DATE type DATS.** Add/Substract years to datecall function 'RP_CALC_DATE_IN_INTERVAL' exporting  DATE = SY-DATUM  DAYS = 0  MONTHS = 0  SIGNUM = '-' " to calculate previous date  YEARS...

2018-11-06 09:23:40 4748

转载 Retroactive Billing – VFRB Modification to add credit/debit line

Retro billing process is used to create price differences documents (credit / debit memo) after price changes in SAP.For further : https://blogs.sap.com/2013/05/07/retro-billing-sd-vfrb/OEM suppli...

2018-10-26 17:46:17 1043

转载 Realizing procurement EDI processes with ANSI ASC X12, EDIFACT, and IDocs

IntroductionMost of today’s procurement processes heavily depend on the use of electronic data interchange (EDI). Depending on the industry, different procurement concepts are applied. In the automo...

2018-10-26 17:42:36 683

原创 如何控制一些项目在ORDRSP中不输出

有些需求会要求有些项目在ORDRSP中不输出,经过查看函数IDOC_OUTPUT_ORDRSP,大家就会发现很多的CUSTOMER-FUNCTION。下面举个就以无确数量的行项目不输出为例,采用增强EXIT_SAPLVEDC_003(ZXVEDU15)代码,代码如下:  if vbak-vtweg = '11'.   Data w_BMENG like vbep-BMENG.   CLEA...

2018-09-28 14:50:08 566

原创 关于VBxxDATA单元内表记录的变化

下表简单记录了VBxxDATA的内表的变化和简单描述,供大家在做SD订单增强时使用:Table Name Description Create Change(Add,Delete,Modify) VBAK   X   *VBAK       YVBAK Old table status when changing i...

2018-09-04 13:03:54 673

原创 VBAP和VBEP的几个数量字段的说明

VBAP-KWMENG(Order Quantity)Cumulative Order Quantity in Sales UnitsThe total (rounded) order quantity for this item.UseIf there is more than one schedule line for the item, the total order qua...

2018-08-16 14:56:31 2316

原创 SD-如何读取文本订单的抬头文本

在最近一次修改订单跟踪表,用户提出需要读取抬头文本。由于用户输入文本时存在多种语言,如果根据用户的语言或者在条件界面设置语言条件来提取文本,发现都会漏取文本。后来经过思索,用先从STXH表中获取抬头文本的语言,再使用该语言传入read_text函数读取文本,这样就确保文本读取,不会出现遗漏。代码摘抄如下:  CLEAR lV_text.  select single TDSPRAS into...

2018-07-16 17:01:28 3551

转载 SD- sap 的修改日志

One of the best weapons in a support consultant’s arsenal is the ability to review document changes.  Sometimes, being able to build a precise timeline around occurrences of an issue can be crucial ...

2018-07-13 13:55:48 3903

转载 SAP SD Reference Guide: SAP Notes

The SAP Support Portal — a.k.a. Service Marketplace, a.k.a. Launchpad — contains a plethora of articles about various SAP errors, issues, and functions.  While a comprehensive catalog of such issues...

2018-07-13 13:49:12 857

转载 ABAP-BITMAP的命令参数的使用说明

Documentation on the SAPscript graphic administration is available in the system.There are two ways of accessing it:1. Create a graphic directly on the form painter page, for example, using the cont...

2018-06-28 10:24:12 739

原创 SAP定价的合计字段的代码照抄

合计字段默认累计,只有当条件类型为价格类型时,字段会重置。请大家参考LV61AA55* fill subtotal work fields      CASE xkomv-kzwiw.        WHEN ' '.        WHEN 'A'.          IF komp-mgame NE 0.            komp-cmpre = xkomv-kwert * 10 /...

2018-04-30 15:43:47 1405

转载 24832 - Pricing rules/TVCPF (定价计算的Pricing type)

SymptomDepending on the situation, the system shouldredetermine conditions ornot. For this, a differentiated control is required, for example:1. When you create orders or billing documents, the cond...

2018-04-27 15:28:18 1773

转载 SD 一些常用的参数(Parameter)

ParameterDescriptionUsageAATOrder typeSD Order Type. Populated on transactions like Create Sales Order (VA01) could be Production order also.AGTQuotation type (RV)SD Quotation Type. Populated on trans...

2018-04-17 10:35:58 1418

原创 如何动态地调用没有引用的其他程序的内存变量数据的样例?

本文ATP的增强(EXIT_SAPLATPC_002)会在订单,出库单的程序中被调用,我们可能希望读取这些程序的变量的数据,我们就可以通过FIELD-SYMBOLS来完成,具体参见下面的代码样例:TABLES: y0000ca_userexit. "allready declaredDATA: c_programm     LIKE y0000ca_userexit-yprogramm.DATA:...

2018-02-24 17:36:36 1153

原创 如何使用SE16N进行数据批量修改和输入?

如何使用SE16N进行数据批量修改和输入?

2018-01-26 16:55:21 3108

原创 SD-如何增强VF04显示交货单相关的发票金额

我们可以使用ZXV6PU08sap给我们留好了增强的出口:EXIT_SAPLV60P_008,我们可以修改 ZXV6PU08,来显示出库相关的Billing的金额。方法如下:1、在VKDFIF中添加字段YYNETWR,用于显示价格2、修改 ZXV6PU08,填写YYNETWR字段代码照抄如下:PERFORM y0000sd_0000_fill_vkdfif

2017-11-24 10:52:28 3096

原创 SD-关于单据流的创建日期的一个错误的认识

SD-关于单据流的创建日期的一个错误的认识

2017-10-31 14:41:23 918 1

转载 条件技术中需求公式的 kobed和kobev的不同之处

SD price

2017-09-13 17:31:07 1791

转载 SAP ABAP Programming Tutorials - Free Training Course

ABAP Fundamentals1 - Introduction to ABAP: Datatypes, Operators & Editor - Tutorial 2 - ABAP Data Dictionary Tutorial - Table, Lock Object, View & Structure 3 - Modularization in ABAP:

2017-05-17 10:03:13 1452

Power_BI_Modeling_and_DAX.pdf

Power_BI_Modeling_and_DAX PDF Book

2021-02-20

Mobile ASP.NET MVC 5

Mobile ASP.NET MVC 5

2014-08-08

JoineBook.Com_Apress.Pro.ASP.NET.MVC.5.Platform.Apr.2014

JoineBook.Com_Apress.Pro.ASP.NET.MVC.5.Platform.Apr.2014

2014-08-08

JoineBook.Com_Apress.Pro.ASP.NET.MVC.5.Dec.2013.pdf

JoineBook.Com_Apress.Pro.ASP.NET.MVC.5.Dec.2013.pdf

2014-08-08

Apress.Beginning.ASP.NET.MVC.4.Jul.2013

Apress.Beginning.ASP.NET.MVC.4.Jul.2013

2014-08-08

Implementing SAP ERP Sales & Distribution_2008

Implementing SAP ERP Sales & Distribution_2008

2013-06-03

Using IDOC Method in LSMW

Using IDOC Method in LSMW 但愿对大家有用!

2013-05-20

ABAP Program Tips v3.

ABAP Program Tips v3. 适合abap初级选手学习

2013-05-20

ABAP4编程宝典中文版(完整版)

ABAP4编程宝典中文版(完整版),适合abap的初级选手学习。

2013-05-20

Using Infoset Query, SAP Query and Quick Viewer

Using Infoset Query, SAP Query and Quick Viewer

2013-05-20

空空如也

TA创建的收藏夹 TA关注的收藏夹

TA关注的人

提示
确定要删除当前文章?
取消 删除