欢迎投稿

今日深度:

销售订单行上行号LINE_SHIPMENT_OPTION_NUMBER,shipmen

销售订单行上行号LINE_SHIPMENT_OPTION_NUMBER,shipmentnumber


 销售订单行上行号:LINE_SHIPMENT_OPTION_NUMBER 取值:
 1 Line块的块级触发器POST-QUERY调用: OE_LINE.Post_Query;(来自于库OEXOELIN)

 2) 库OEXOELIN里Line_Shipment_Option_Number赋值代码:     OE_CONCAT_VALUES.LINE_SHIPMENT_OPTION                                         (                                          Name_in('Line.Line_Number' ),                                          Name_In('Line.Shipment_Number' ),                                          Name_In('Line.Option_Number' ),                                          x_concat_values,                                          Name_In('Line.Component_Number' ),                                          Name_In('Line.Service_Number' )                                          );
    COPY(x_concat_values, 'Line.Line_Shipment_Option_Number' );         ( 3) OE_CONCAT_VALUES包代码: PACKAGE BODY oe_concat_values IS   PROCEDURE line_shipment_option(line_number      IN NUMBER ,                                  shipment_number  IN NUMBER ,                                  option_number    IN NUMBER ,                                  p_concat_value   OUT VARCHAR2 ,                                  component_number IN NUMBER DEFAULT NULL ,                                  service_number   IN NUMBER DEFAULT NULL ) IS   BEGIN       --=========================================     -- Added for identifying Service Lines     --=========================================     IF service_number IS NOT NULL THEN       IF option_number IS NOT NULL THEN         IF component_number IS NOT NULL THEN           p_concat_value := line_number || '.' || shipment_number || '.' ||                             option_number || '.' || component_number || '.' ||                             service_number;         ELSE           p_concat_value := line_number || '.' || shipment_number || '.' ||                             option_number || '..' || service_number;         END IF ;              --- if a option is not attached       ELSE         IF component_number IS NOT NULL THEN           p_concat_value := line_number || '.' || shipment_number || '..' ||                             component_number || '.' || service_number;         ELSE           p_concat_value := line_number || '.' || shipment_number || '...' ||                             service_number;         END IF ;            END IF ; /* if option number is not null */          -- if the service number is null     ELSE       IF option_number IS NOT NULL THEN         IF component_number IS NOT NULL THEN           p_concat_value := line_number || '.' || shipment_number || '.' ||                             option_number || '.' || component_number;         ELSE           p_concat_value := line_number || '.' || shipment_number || '.' ||                             option_number;         END IF ;              --- if a option is not attached       ELSE         IF component_number IS NOT NULL THEN           p_concat_value := line_number || '.' || shipment_number || '..' ||                             component_number;         ELSE           /*Bug2848734 - Added IF condition */           IF (line_number IS NULL AND shipment_number IS NULL) THEN             p_concat_value := NULL ;           ELSE             p_concat_value := line_number || '.' || shipment_number;           END IF ;         END IF ;            END IF ; /* if option number is not null */        END IF ; /* if service number is not null */     END line_shipment_option;
END oe_concat_values;

SELECT ool.line_id       ,to_char(ool.line_number) ||        decode (ool.shipment_number,               NULL ,               NULL ,               '.' || to_char(ool.shipment_number)) ||        decode (ool.option_number,               NULL ,               NULL ,               '.' || to_char(ool.option_number)) ||        decode (ool.component_number,               NULL ,               NULL ,               decode (ool.option_number, NULL , '.', NULL ) || '.' ||               to_char(ool.component_number)) ||        decode (ool.service_number,               NULL ,               NULL ,               decode (ool.component_number, NULL , '.', NULL ) ||               decode (ool.option_number, NULL , '.', NULL ) || '.' ||               to_char(ool.service_number)) line_num       ,msi.segment1 item_number       ,ool.ordered_quantity   FROM oe_order_lines_all ool, mtl_system_items msi WHERE ool.header_id = &header_id    AND ool.ship_from_org_id = msi.organization_id(+)    AND ool.inventory_item_id = msi.inventory_item_id(+)    AND ool.item_type_code <> 'INCLUDED' ;

sales order number 与sales order line number是啥

销售订单号和销售订单行号,尤其是订单行号,一般是针对一个订单有多个产品的情况下,分不同的行的;

可以举个例子,比如订单号码是1000,这个订单下面有2个不同型号的产品,则对应的订单行号就是1000-1、1000-2;这个只是个例子,具体的编码规则可以由各个企业自行制定。
 

SAP销售订单(Sales Order)中,同一个行项目,使用多个Schedule Line categories,怎解决?

首先确认两件事:
1,启用了ATP check
2,配置了可产生PR的计划行,计划行类别里有个设置,自己能看懂的
操作时:
1,默认情况下自动确认计划行50数量
2,手工添加计划行的第二行,计划行类别为你设定好的计划行类别
 

www.htsjk.Com true http://www.htsjk.com/shujukunews/3957.html NewsArticle 销售订单行上行号LINE_SHIPMENT_OPTION_NUMBER,shipmentnumber 销售订单行上行号:LINE_SHIPMENT_OPTION_NUMBER 取: ( 1 ) Line块的块级触发器POST-QUERY调用: OE_LINE.Post_Query;(来自于库OEXOELIN) ( 2 ) 库...
评论暂时关闭