MM 思爱 普(SAP)！
博客导航
博客日历
| « | 五月 2012 | » | ||||
|---|---|---|---|---|---|---|
| 一 | 二 | 三 | 四 | 五 | 六 | 日 |
| 1 | 2 | 3 | 4 | 5 | 6 | |
| 7 | 8 | 9 | 10 | 11 | 12 | 13 |
| 14 | 15 | 16 | 17 | 18 | 19 | 20 |
| 21 | 22 | 23 | 24 | 25 | 26 | 27 |
| 28 | 29 | 30 | 31 | |||
最新发表
MM配置杂记
移动硬盘小问题
来源声明
2.12
2.110分割配额安排举例(中英文)
2.11分割配额安排(中英文)
2.10分配配额（中英文）
abaper for 4.7
2.100 配额分配举例
最新评论
Shd制作使用事务変式
Shd制作使用事务変式
―――以MM03实例 标准事务変式创建
―――水平一般。简单制作。仅供参考。―――
事务変式Transaction variant可以隐藏fields，修改fields的属性，隐藏button，改变button的位置甚至通过GUIXT插入screen。Tansaction
variant是一些列screen variant的集合。可以为screen创建任意数量的variants，这些variants组成transaction variant。
分为普通的変式以及标准変式。普通変式需要唯一名称，配置TCODE 以及用户菜单使用等；标准事务変式直接在系统标准TCODE使用。
可以对事务変式单独分配用户权限；
1. 初始状态
图1
图2
目标： MM03只查看BASIC1 2 这2个tab；
Basic1 中 红框字段 不能查看
2. TCODE： SHD0
图3
输入 点击创建；进入MM03界面
图4
图5
决定此屏幕事项（屏幕是否显示 红色框――哪些字段必输、不显示等 ）
图6
图7
图8
图9
此步之前的各个 CONFIRM SCREEN ENTRY 如果不能确定 ，都默认按确定就可以，后面可以继续修改。
②.
①.
图10
说明： 此处可以修改各屏幕。如何确定了：
红色框 Screen values 0060 Program SAPLMGMM
这个可以通过MM03查看技术信息（下图11 合成图）确认。 ①是屏幕信息②是字段
②. 1 ①. 1 图11 在MM03输入物料号处 按F1
保存 并传输。（此例 不传输 本地对象 $tmp）
图12
3. 激活
返回SHD0主界面（点击BACK或者返回）。决定是否启用。activate激活＝启用。
4. 查看效果
MM配置杂记
SCPR20激活用户语言CMOD 察看开发增强
物料类型的设置：
设置物料类型属性（是否价值/数量更新）
维护公司代码（更新财务年与期间）
定义物料组（物料的不同用途分 如正车）
MRP基于消耗的计划：
激活MRP（确定工厂是否使用MRP）OMDU
维护工厂参数OMI8
MRP组的维护/MRP控制者
对库存地点定义MRP（）？
采购：
定义供应商评估的采购组织数据OMI8
设置PO价格变动的容差范围（允许价格浮动的上下范围）
定义采购组
定义批准策略（PO CLASSS）
定义批准组/批准指示器（如价值变动多少需要批准）/批准码（谁来批准）
定义采购询价/合同/申请/订单 凭证类型rfq/contract/requistion/po(类型 号码分配等)
给凭证分配供应商方案（对供应商数据的处理如发票地址等是系统带出还是手工输入是）
库存inv：
定义库存与实际（physical物理）库存管理的工厂参数（物料移动设置/实际（physical物理）库存/负库存许可等）
设置收货容差（是否允许多/少收货 范围）
允许存储位置的登记库存余额冻结(盘点 是是否允许该库存地冻结账面库存)
评估与账户分配：
为评估范围确定账户分配OMWD（科目表/评估组）
过去期间/年度价格变动的应用（按公司代码/是否应用到当前期间 previous period/year）
配置自动过帐OMWB（科目的分配确定/GL/评估组）
发票校验：
激活自动过帐到GL/物料帐（输入发票时是否自动过帐）
设置发票冻结容差OMR6（按公司代码设置容差码 ）
设置多张发票校验的检查（公司代码 参考凭证 日期等）
维护税码默认值
采购组织与标准采购组织：
定义好采购组织；分配给COM CODE工厂；然后 确定其中一个（在 多个采购组织负责一个工厂 情况下）pur org作为标准采购组织分配给工厂； 管道<一般指流水线是的作业>采购 pipeline pur寄售consignment库存转移stock transfers事务时使用的标准采购组织： 管道物料的发货业务，系统默认首先读取标准采购组织的信息纪录；货源确定、来源确定的寄售及库存转移使用标准采购组织
移动硬盘小问题
外挂硬盘或者移动硬盘错误:
我的电脑可以看到新盘符，准备进入分区拷贝数据，访问的时候报出“无法访问f:,执行页内操作时的错误”，再去磁盘管理服务内看此分区信息，此分区的状态为“良好（活动）”，硬盘分区空闲空间为100%，而文件状态这列既不是NTFS,也不是FAT32,而是什么都没有
查找网络解决: 1 盘符改一下就行了 2用XP的磁盘检测修复命令 chkdsk /f就可以解决了
－－－－
网络看到的更麻烦问题：
硬盘在窗口根本不显示－－－
在设别管理器中能否发现
不能--连接问题或者硬盘本身问题 或者电源问题;
能发现--在我的电脑--管理-存储---磁盘管理中 右键添加盘符 一般能解决
更复杂的问题 请去网络查找
－－－－
顺便说说看到的关于硬盘的容量：
硬盘大小标称是已1000的比率计算；而计算机系统中实际以1024计算，故而常见容量转换如下：
标称 1M 系统显示＝1M×1000×1000/1024/1024=0.9536M
如标称 512M内存 实际系统中为512×0.9536＝488.1M
标称 1G 系统显示＝1G×1000×1000×1000/1024/1024/1024=0.9313G
如标称 80G硬盘 实际系统中为 80G×0.9313＝74.50G
来源声明
本BLOG所有英文原文来自与SAP HELP glossary ;因少见完整条理的中文古翻译,全当系统学习!
2.12
Use You can maintain a minimum lot size, a maximum lot size and a rounding profile for each quota item. Integration The minimum lot size, maximum lot size or rounding profile that you have maintained in the quota item override the entries in the material master and are valid for the assigned sources of supply. If you have maintained the minimum or maximum lot size in the material master, the values that you have entered there are valid for all sources of supply. Features Minimum Lot Size The minimum lot size defines a minimum quantity for the procurement proposal. If a source of supply is determined on the basis of the quota arrangement logic, for which a minimum lot size has been entered and if the requirement quantity is smaller, the system creates the procurement proposal for the amount of the minimum quantity. Maximum Lot Size The maximum lot size determines the largest possible quantity for the procurement quantity. If a requirement exceeds the maximum lot size recorded for the quota item, then several procurement proposals are created for the maximum lot size until the total requirement is covered. If there is a remaining quantity that is smaller than the maximum lot size, the last procurement proposal is created to cover the amount of this rest quantity. After each procurement proposal is created, the quota arrangement is restarted, that is, the quota rating is recalculated to check which source of supply is to be used next. If the quota of a source of supply is high, then it can be used, if necessary, to create several procurement proposals for the maximum lot size. "Only Once" Indicator To avoid a situation where more than one order proposal is created per requirement for a source of supply, with the maximum lot size, you can set the Only once indicator for this particular source of supply. This source of supply is then only used once per requirement. It only makes sense to use the Only once indicator in combination with the maximum lot size. Rounding Profile If a quota item with a rounding profile is selected, then the quantity of the procurement proposal is adjusted according to the rounding profile. 
Lot Size and Rounding Profile in Quota Arrangement 
2.110分割配额安排举例(中英文)
Example for Splitting Quota Arrangement
Example Data
Minimum quantity | 400 |
Requirement | 1000 |
Lot size | Lot-for-lot order quantity |
Quota | |
Vendor A | 40 |
Vendor B | 30 |
Vendor C | 20 |
Vendor D | 10 |
Order Quantity Calculation
Vendor A receives the first order due to having the highest quota. The quantity results from the above-mentioned formula with 40* 1000 / 100 as 400 pieces.
There is a remaining quantity of 600 pieces. Vendor B receives the next order with the quantity 30 * 600 / 60 as 300 pieces. As A has already been used, that quota is not taken into account.
There is a remaining quantity of 300 pieces. As the value is smaller than the minimum quantity, the system does not split it further. The system assigns the complete remaining quantity to vendor D, as this vendor has the lowest quota rating.
2.11分割配额安排(中英文)
原文
Use
You can use the splitting quota arrangement to distribute a procurement proposal among various sources of supply, that is, split them up.
Prerequisites
In the material master (MRP 1 view), you have assigned a lot-sizing procedure with splitting quotas for the materials to be included in this procedure.
This quota arrangement logic with the splitting quota is set in Customizing per lot-sizing procedure.
Features
Order Quantity Calculation
The order quantity is calculated according to the following formula:
(Quota source of supply X * Requirement quantity) / Total of all quotas
The quota-allocated quantity of a source of supply or the quota rating is not relevant for the splitting quota.
The system splits the requirements according to the sequence that is defined by the quota, that is, the vendor with the highest quota is selected first. The sequence defined by the quotas can be overruled by priorities. This means that vendors that have been allocated priorities are always selected first. The quantity, however, is always calculated according to the formula above using the quotas.
Determining a Minimum Quantity for Splitting
The minimum quantity for the splitting quota determines that the lot has to amount to the minimum quantity (at least) before it can be split.
If a requirement is smaller than the minimum quantity, the system only selects the vendor whose turn it is according to the quota arrangement calculation, that is, it is processed on the basis of the allocation quota arrangement procedure and is not split.
If a requirement quantity has already been split and the remaining quantity causes a lot that is smaller than the minimum quantity, the system does not further split this quantity. The remaining quantity is assigned to the source of supply with the lowest quota rating.
See also:
译文 分割配额安排
你可以使用分割配额安排把一个采购建议分发到多个供应源之间，这就是分割。
前提要求（prerequisite）
在物料主数据（MRP VIEW1），你已经分配一个带分割配额的批量过程给其中的物料。
注意：带分割配额的配额安排逻辑是在客户化设置中按照批量过程处理的。
特征Features
定单数量计算
定单数量计算公式如下：
配额供应源*需求数量/配额总和
一个供应源被分配的配额数量或者比率与被分割的配额无关。
系统按照配额定义的顺序分割需求，也就是，具备最高配额的供应商最先被选择。这个配额定义的顺序可以被优先级改变。这意味着被分配最好优先级的供应商最先被选择。但是数量仍然是由上面的公式计算。
决定分割的最小数量
分割配额的最小数量决定了分割前的批的最小数量（最少的）。
如果一个需求小于最小数量，系统只选择按照配额安排计算轮到的那家供应商。也就是，系统处理是基于配额安排过程而不是分割。
如果一个需求已经分割但是剩下的数量小于最小数量，系统不会再分割，而是把它分配给获最低配额比率的供应商。
2.10分配配额（中英文）
Allocation Quota Arrangement Use Using this procedure, you assign an exact source of supply to every lot, if you have not entered a maximum lot size or maximum release quantity in the quota file. Features The assignment is determined using the quota rating. The system calculates the quota rating using the following formula: Quota rating = Quota-allocated quantity (+ quota base quantity) / Quota
The quota-allocated quantity is thereby the total quantity, which has been procured for the relevant source of supply up until then.
You can control the quota arrangement using the quota base quantity without having to change the quota,
The quota is the percentage rate that defines which part of an occurring requirement is to be taken from a source of supply.
The source of supply, which has the lowest quota rating, receives the complete lot. The quota rating determines the sequence according to which the sources of supply are chosen.
if, for example, a new source of supply is to be added to the quota arrangement .译文分配配额安排
这个流程用于没有在配额文件中输入最大批量或者最大批准数量情况下，为每个批分配一个确定的供应源。
特征Features
分配是由配额率(quota rating)来决定的。系统使用以下公式计算配额率。
配额率=分配的配额数量（+配额基准数量quota base quantity）/配额
此处的分配的配额数量是到那时为止（up until then）为相关供应源已经采购的总数量
如果，例如一个新的供应源被加到配额安排，你可以通过使用配额基准数量来控制配额安排，而不必要改变配额。
配额是个决定一个发生的需求从那个供应源获取哪个部分的百分比。
那个获得最低配额的供应源至少要收到一个完整的批。配额率决定选取供应源的顺序。
abaper for 4.7
2.100 配额分配举例
Example for Allocation Quota Arrangement The first procurement proposal is allocated to item 1, and the second procurement proposal to item 2.
2.1配额安排(中英文)
原文
Use
If a material can be obtained from various sources of supply, each individual source of supply can be allocated a quota arrangement. The quota arrangement is valid for a certain period of time and specifies exactly how the receipts are to be distributed amongst each source of supply.
You can set the quota arrangement for in-house production as well as for external procurement. Sources of supply can be:
- an individual vendor or outline agreement
- another plant, from which material should be procured
- a production version
Prerequisites
- You have maintained the quota arrangement usage for the respective material in the material master (MRP 2 view).
The quota arrangement usage determines whether a material is included in a quota arrangement and which operations lead to a quota arrangement. You can define, for example, that only purchase orders are included in quota arrangements or that procurement proposals created by the system in the planning run are also included.
You define the quota arrangement usage in Customizing for Purchasing in the IMG activity Define quota arrangement usage.
- You have maintained the quota file for the material.
You define the sequence of the sources of supply, the quotas per source of supply and numerous other parameters in the quota file.
Features
During the planning run, the system determines the sources of supply according to the quota file and assigns the procurement proposals to the sources of supply.
In external procurement, the procurement proposal is allocated to the appropriate vendor. This vendor is copied to the purchase requisition.
For every procurement proposal with a quota arrangement, the system updates the quota file, so that the quota arrangement is always based on the current situation.
Two procedures are available:
- Allocation quota arrangement: every lot is assigned to a source of supply
- Splitting quota arrangement: a lot is split among various sources of supply
Further functions are also available for controlling quota arrangements. For example, you can set a maximum release order quantity that defines the maximum delivery capacity of one particular vendor.
译文 配额安排
如果物料可以从多个供应来源获得，那么每个供应源就可以分配一个配额。配额安排在一个确定的周期生效，它精确的决定收货怎样在各个供应源之间分布。
配额设置可以同样的用于内制（in-house production）和外购（external procurement.）。供应源可以是：
单独供应商或框架协议；可以获得物料的另外一工厂；一个生产方案（version）。
前提要求（prerequisite）
l 在物料主数据中你已经从物料角度（respective）设置了维护配额安排使用率(MRP 2 view MRP视图2 ).
配额安排使用率决定了一个物料是否包含在配额安排中和那种操作要使用配额。例如，你可以定义只有采购订单被包含在配额中或者只有机化运行时系统创建的采购建议被包含。
你可以在IMG活动为采购定义配额安排使用率（Define quota arrangement usage）中客户化定制配额安排使用率。
l 你已经为物料维护了配额文件。
你可以在配额文件中定义供应源序列（sequence）、每个供应源的配额以及其他许多参数。
特征Features
在计划运行中，系统按照配额文件定义供应源并按照供应源分配采购建议。
注意：在外部采购中，采购建议直接分配给适当的供应商。这些供应商然后被复制到采购请求中。
系统根据每个采购建议的一个配额安排，更新配额文件。这样配额安排总是基于当前的情况的。
有两种流程可用：
l 分配配额安排（Allocation Quota Arrangement ）：给每个批分配一个供应源；
l 分割配额安排（Splitting Quota Arrangement）：在多个供应源间分割一个批。
此外，对控制配额安排有更进一步的功能。例如，你可以设置最大的批准订单数量来定义一个供应商的最大交货容量。
2.02 修改计划日历(中英文)
原文
Changing the Planning Calendar
- Starting from the MRP menu choose Master data ® Planning calendar ® Change periods.
The initial screen for planning calendar maintenance now appears.
- Enter the plant for which the planning calendar is to be valid.
- Choose Calendar overview or Calendar no longer valid.
Calendar overview: the system displays all the planning calendars available in the system.
Calendar no longer valid: the system displays all calendars, for which the minimum period independent of the Valid to date has been exceeded, and suggests them for reprocessing.
- Select one or more planning calendars and choose
.
The first selected planning calendar now appears. Here, you can carry out the necessary changes.
Function | Menu path | What you should know |
Calculating new periods | Change calculation rule | Proceed as described in Creating Planning Calendars with Calculation Rule. |
Adding periods | Choose New entries. | |
Inserting periods | Position the cursor on the line where you want to insert a new period. Choose Edit ® Insert and enter a new period end and a new period start. | |
Changing periods | Overwrite the From date or the To date. | |
Deleting periods | Position the cursor on the period that you want to delete. Choose Edit ® Delete. | |
Fixing periods | Select the fixing indicator for the period(s) to be protected. Fixed periods are not changed if you instruct the system to automatically calculate new periods. |
- Save your entries.
If you selected several calendars in the overview, the system now automatically displays the next planning calendar that you selected.
译文
修改计划日历
1. 从MRP菜单选择主数据—〉计划日历—〉修改周期。计划日历维护的初始屏幕就显示出来。
2. 输入需要使用计划日历的工厂。
3. 选择日历概览或者失效日历（no longer valid不再生效）。
日历概览：系统显示系统中所有可获得（available）的日历。
失效日历：系统显示所有已经超出独立于生效日期的最小周期的日
历，并建议修改。
4. 选择一个或多个计划后v（确定）。
第一个被选中的日历显示出来。这就可以做你需要的修改：
功能Function | 菜单路径Menu path | 你需要了解的东西What you should know |
计算新周期 | 修改计算规则 | 根据“使用计算规则创建计划日历”描述处理 |
添加周期 | 修改周期 | 选择新对象（entries实体对象.） |
插入周期 | 修改周期（笔样图标） | 把鼠标放在你需要插入的新周期所在行，选择编辑—〉插入，输入一个新的周期开始和结束 |
修改周期 | 修改周期 | 覆盖输入开始结束日期 |
删除周期 | 修改周期 | 把鼠标放在你需要删除的新周期所在行，选择编辑—〉删除 |
固定周期 | 修改周期 | 选择需要保护的周期标记固定周期。如果系统使用自动计算周期那么固定周期以后就不可更改 |
5. 保存你的输入对象。
如果在概览中选择了多个日历，系统就会接下来自动显示你选择的第二个日历。
2.01 不使用计算规则创建计划日历(中英文)
原文
Creating Planning Calendars without Calculation Rule
- Proceed as described in Creating Planning Calendars with Calculation Rule under points 1 to 7.
- Choose
Periods. - Enter the start and finish dates as well as the number of periods.
If you enter only start dates, the finish dates are automatically calculated by the system (except for the last finish date).
If you only enter finish dates, the system will automatically calculate the start dates.
- Save your entries.
译文
不使用计算规则创建计划日历
1. 按照使用计算规则创建计划日历过程1到7处理。
2. 选择修改周期。
3. 输入开始结束日期和周期数。
如果只输入开始日期,系统就自动计算结束日期(除了持续性结束日期last finish date);
如果只输入结束日期,系统就自动计算开始日期。
4. 保存你的输入对象。
2.00 使用计算规则创建计划日历(中英文)
原文
Creating Planning Calendars with Calculation Rule
- Starting from the MRP menu choose Master data ® Planning calendar ® Create periods.
The initial screen for planning calendar maintenance now appears.
- Enter the plant for which the planning calendar is to be valid.
- Enter a combination of numbers or letters of up to three digits in length for identifying the calendar and choose
. This entry is alphanumeric.
The screen used for maintaining the planning calendar now appears.
- Enter a short description of the planning calendar.
- Enter the minimum period.
The minimum period is used as a time limit for maintenance of a calendar that is no longer valid. You use the minimum period to define the period necessary for reprocessing the calendar. If the time limit is exceeded, the system displays the calendar for processing (see Changing the Planning Calendar), even when the Valid to date has not been reached yet. You should therefore define the minimum period so that, in the future, the system displays the planning calendar for processing on time in the future.
You define the validity period of the calendar after you have defined the planning rule.
- Specify how the system should proceed if the period start happens to fall on a day that is not defined as a workday in the factory calendar.
- Choose
.
The system displays the Select calculation rule dialog box. The calculation rule determines the calculation of the periods for the planning calendar.
- Choose the calculation rule you require:
- weeks (weekdays)
Example: period start on Monday and Wednesday every week
- months (weekdays)
Example: period start on every second Wednesday of the month
- months (workdays)
Example: period start on every fifth workday of the month
You can specify the workday/workdays of the planning calendar according to the workdays defined in the factory calendar.
- years (workdays)
Example: period start on every fifth workday of the year
You can specify the workday/workdays of the planning calendar according to the workdays defined in the factory calendar.
- workdays
Example: period start on every fifth workday from a particular start date
You can specify the workday/workdays of the planning calendar according to the workdays defined in the factory calendar.
- weekdays
Example: period start on every second Wednesday from a particular start date
- Choose
.
In the screen area Calculation rule for period specification, the system asks you to specify the parameters of the corresponding calculation rule.
- Enter data as required.
- Choose
Calculate periods.
The system displays the New dates dialog box.
The system displays a start date in the Valid from field. You can change the date here, if necessary.
In the Valid to field, the time period that results from the minimum period is displayed. Here, you enter the date up until which the system is to calculate the periods.
- Choose
.
The system then displays the calculated periods.
The number of the displayed periods is used in the stock/requirements list for the period totals display, if the display is set according to a planning calendar.
- Save your entries.
译文
使用计算规则创建计划日历
1． 从MRP菜单选择主数据—〉计划日历—〉创建周期。计划日历维护的初始屏幕就显示出来。
2． 输入需要使用计划日历的工厂。
3． 输入一个3位长的数字或者字母组合来标识该日历后选择v（对号表示确定）。这个输入是数字或字母都可用(alphanumeric)。接着维护计划日历的屏幕就出现了。
4． 为该计划日历输入描述。
5． 输入最小周期。该周期是该日历不在生效/使用(valid)的时间限制。你可以用这最小周期来定义重新处理该日历的必须时间限制。如果时间超出周期限制,系统就会显示日历需要处理(参考修改计划日历) ,即使日历有效期没到。因此,你需要定义最小周期以便以后系统准时提醒日历需要修改。
定义计划规则后,你需要定义生效日期。
6． 规定系统怎么处理周期恰好开始于一个工厂日历(factory calendar)定义的非工作日的情况。
7． 选择v(确定)。系统显示选择计算规则对话框.。计算规则决定计划日历的周期计算。
8． 选择你需要的计算规则:
周(平日weekdays,一般指周一到周五) 。例如周期开始于每周的周一和周三;
月(平日weekdays)。例如周期开始于每月的第二个周三。
月(工作日workdays)。例如周期开始于每月的第五个工作日。你可以按照工厂日历(factory calendar)定义的工作日确定该工作日。
年(工作日workdays)。例如周期开始于每年的第五个工作日。你可以按照工厂日历(factory calendar)定义的工作日确定该工作日。
工作日(workdays)。例如周期开始于每个确定日期后的第五个工作日。你可以按照工厂日历(factory calendar)定义的工作日确定该工作日。
平日(weekdays)。例如周期开始于每个确定的日期后的第二个周三。
9． 选择v(确定)。
在确定周期计算规则屏幕区域,系统要求确定相应计算规则的参数。
10． 当需要时输入数据。
11． 选择生成计算规则。系统显示新日期对话框。系统在生效开始于(valid from)字段显示一个生效日期,如果需要,你可以更改。在生效到(valid to)字段,系统显示从最小周期得到的时间, ,你可以最大更改到系统计算的周期。
12． 选择v(确定)。系统显示计算周期。
注意:如果是按照计划日历设置显示,此处显示的周期数据就是周期总量显示库存/需求清单的周期。
13． 保存你的输入对象。
查询TCCODE的有用程序(提供TCCODE、中文描述模糊查询)
REPORT ZTD .
tables: TSTC ,
TSTCT.
types:
begin of itab_tcode ,
TCODE like TSTC-TCODE, "tcode
PGMNA like TSTC-PGMNA, "program
TTEXT like TSTCT-TTEXT, "text description
end of itab_tcode.
data itab_tcode type table of itab_tcode with header line .
data prtcnt type i.
selection-screen begin of screen 100 as window title text-tcd. "1214修改
parameters:
astcd type c as checkbox. "查询方式设定
selection-screen end of screen 100 .
selection-screen begin of screen 101 as window title text-tcd. "1214修改
select-options:
s_tcode for TSTC-TCODE .
selection-screen end of screen 101 .
selection-screen begin of screen 102 as window title text-tcd. "1214修改
parameters:
p_text(20) type c .
selection-screen end of screen 102 . "1214修改
************************************************************
start-of-selection.
call selection-screen 100. "1214修改..
if astcd = 'X' .
call selection-screen 101 starting at 4 5. "..1214修改
perform fquery_tcode.
write : / '你使用Tcode查询,默认下载c:/tcode.xls'.
uline.
perform fwrite using itab_tcode[]. "输出显示不下载
perform fdown ."输出下载
else.
call selection-screen 102 starting at 4 5.
perform fquery_ttext.
write : / '你使用Tcode 文本查询 ，默认下载c:/tcode.xls'. "输出显示不下载
uline.
perform fdown ."输出下载
perform fwrite using itab_tcode[].
endif. "..1214修改
end-of-selection.
*&---------------------------------------------------------------------
*
*& Form fdown
*&---------------------------------------------------------------------
*
* text
**把TCODE查询出来 下传到本地文件
*----------------------------------------------------------------------
*
* --> p1 text
* <-- p2 text
*----------------------------------------------------------------------
*
FORM fdown .
CALL FUNCTION 'WS_DOWNLOAD' "DOWNLOAD 也有此功能 ,有对话框
EXPORTING
filename = 'C:tcode.xls'
TABLES
data_tab = itab_tcode "输出data
EXCEPTIONS
file_open_error = 2
OTHERS = 1.
ENDFORM. " fdown
*&---------------------------------------------------------------------*
*& Form fquery_tcode
*&---------------------------------------------------------------------*
* text
*----------------------------------------------------------------------*
* --> p1 text
* <-- p2 text
*----------------------------------------------------------------------*
FORM fquery_tcode .
select TCODE PGMNA from TSTC into table itab_tcode
where TCODE in s_tcode .
loop at itab_tcode.
select TTEXT from TSTCT into itab_tcode-TTEXT
where TCODE = itab_tcode-TCODE
and SPRSL = '1'.
modify itab_tcode.
endselect.
endloop.
ENDFORM. " fquery_tcode
*&---------------------------------------------------------------------*
*& Form fquery_ttext
*&---------------------------------------------------------------------*
* text
*----------------------------------------------------------------------*
* --> p1 text
* <-- p2 text
*----------------------------------------------------------------------*
FORM fquery_ttext .
data ttxt(22) type c .
ttxt = '%'.
CONCATENATE ttxt p_text ttxt into ttxt IN CHARACTER MODE .
***concatenate 一定要注意长度
select tcode TTEXT from TSTCT
INTO CORRESPONDING FIELDS OF TABLE itab_tcode
where TTEXT like ttxt .
*loop at itab_tcode.
*select Tcode from TSTCT into itab_tcode-tcode
* where TTEXT = itab_tcode-tcode .
* modify itab_tcode.
* endselect.
* endloop.
ENDFORM. " fquery_ttext
*&---------------------------------------------------------------------*
*& Form fwrite
*&---------------------------------------------------------------------*
* text
*----------------------------------------------------------------------*
* --> p1 text
* <-- p2 text
*----------------------------------------------------------------------*
FORM fwrite using
itab like itab_tcode[] . "1214 add
DATA itab_t LIKE LINE OF ITAB.
loop at itab into itab_t.
write:/ itab_t-tcode , 16 itab_t-TTEXT.
endloop.
搜索
文章归档
文章分类
浏览排行
我的链接
新闻聚合
