Sunday, January 29, 2012

Infoset - Join Conditions

Info Set is a Virtual Provider. Info Sets allow you to analyze the data in several Info Providers by using combinations of master data-bearing characteristics, Info Cubes and Data Store objects. The system collects information from the tables of the relevant Info Providers. If you are joining large sets of data from the master data or from DSO objects, SAP recommends that you use an Info Set. This improves performance as fewer temporary tables are required and the join is executed in the database itself.

Joins are 4 types

: 1) Left outer Join

2) Right outer Join.

3) Temporary Join...based on any Date field.

4) Equal Join


Inner Join:

In case of inner join there should be an entry in all the tables use in the view.


Outer Join:

With the use of outer join you can join the tables even there is no entry in all the tables used in the view. Inner join between table 1 and table 2, where column D in both tables in the join condition is set the same:

Table 1 Table 2
Inner Join
---- ---- ---- ---- ---- ---- ---- ---- ----
A B C D D E F G H
---- ---- ---- ---- ---- ---- ---- ---- ----
a1 b1 c1 1 1 e1 f1 g1 h1
a2 b2 c2 1 1 e1 f1 g1 h1
a4 b4 c4 3 3 e2 f2 g2 h2
---- ---- ---- ---- ---- ---- ---- ---- ----

Left outer join between table 1 and table 2 where column D in both tables set the join condition: Table 1 Table 2
A B C D D E F G H
a1 b1 c1 1 1 e1 f1 g1 h1

a2 b2 c2 1 3 e2 f2 g2 h2

a3 b3 c3 2 4 e3 f3 g3 h3
a4 b4 c4 3 --- ---- ------------

Left Outer Join

A B C D D E F G H
a1 b1 c1 1 1 e1 f1 g1 h1
a2 b2 c2 1 3 e2 f2 g2 h2
a3 b3 c3 2 4 e3 f3 g3 h3
a4 b4 c4 3 --- ---- ------------

-----------------------------------------------------
A B C D D E F G H
------------------------------------------------------
a1 b1 c1 1 1 e1 f1 g1 h1

a2 b2 c2 1 1 e1 f1 g1 h1
a3 b3 C3 2 NULLNULLNULLNULLNULL
a4 b4 c4 3 3 e2 f2 g2 h2

What makes difference between Inner Join & Left Outer Join

Inner join returns only the matching records from both tables.Left outer join returns complete details of left table which are matching with right table and non matching records also.

The data that can be selected with a view depends primarily on whether the view implements an inner join or an outer join. With an inner join, you only get the records of the cross-product for which there is an entry in all tables used in the view. With an outer join, records are also selected for which there is no entry in some of the tables used in the view.

The set of hits determined by an inner join can therefore be a subset of the hits determined with an outer join.

Database views implement an inner join. The database therefore only provides those records for which there is an entry in all the tables used in the view. Help views and maintenance views, however, implement an outer join.Temporal Join

Join containing at least one time-dependent characteristic For example, a join contains the following time-dependent Info Objects (in addition to other objects that are not time-dependent).

InfoObjects in the join Valid from Valid to
Cost center (0COSTCENTER) 01.01.2009 31.05.2009
Profit center (0PROFIT_CTR) 01.06.2009 31.09.2009

Where the two time-intervals overlap, means the validity area that the Info Objects have in common, is known as the valid time-interval of the temporal join.

Temporal join Valid from Valid to


Valid time-interval 01.03.2009 31.05.2009

You define an Info Set via the characteristic PROFIT Center, which contains the responsible person (RESP) as the time-dependent attribute and the characteristic COSTCENTER that also contains person responsible as a time-dependent attribute.

These characteristics contain the following records:


Profit Center Responsible Person DATEFROM* DATETO*
BI A 01.01.2009 30.06.2009
BI B 01.07.2009 31.12.9999

Cost Center Profit Center Responsible Person DATEFROM* DATETO*
4711 BI X 01.01.2009 31.05.2009
4711 BI Y 01.06.2009 31.12.2009
4711 BI Z 01.01.2009 31.12.9999

If both characteristics are used in a join and connected via PROFITCENTRE, it is not true that all six possible combinations are valid for the above records. Instead only the following four:


PROFITC RESP Cost Center Profit Center Responsible Person
BI A 4711 BI X (01.01.2009-31.05.2009)
BI A 4711 BI Y (01.06.2009-30.06.2009)
BI B 4711 BI Y (01.07.2009-31.12.2009)
BI B 4711 BI Z (01.01.2009-31.12.9999)

Equal Join

A join condition determines the combination of records from the individual objects that are included in the resulting set. Before an Info Set can be activated, the join conditions have to be defined in such a way (as equal join condition) that all the available objects are connected to one another either directly or indirectly.

An Equal Join is possible only with Same Values Technical Requirement is such way that both the Values has same Data Type & Length for Equal Join.

Equal Join

Table1 Table 2

Equal Join
X ------------------- X

Saturday, January 21, 2012

MM Tables and Relationship

Materials Management Tables






EINA Purchasing Info Record- General Data
EINE Purchasing Info Record- Purchasing Organization Data
MAKT Material Descriptions
MARA General Material Data
MARC Plant Data for Material
MARD Storage Location Data for Material
MAST Material to BOM Link
MBEW Material Valuation
MKPF Header- Material Document
MSEG Document Segment- Material
MVER Material Consumption
MVKE Sales Data for materials
RKPF Document Header- Reservation
T023 Mat. groups
T024 Purchasing Groups
T156 Movement Type
T157H Help Texts for Movement Types
MOFF Lists what views have not been created

Purchasing Tables








A501 Plant/Material
EBAN Purchase Requisition
EBKN Purchase Requisition Account Assignment
EKAB Release Documentation
EKBE History per Purchasing Document
EKET Scheduling Agreement Schedule Lines
EKKN Account Assignment in Purchasing Document
EKKO Purchasing Document Header
EKPO Purchasing Document Item
IKPF Header- Physical Inventory Document
ISEG Physical Inventory Document Items
LFA1 Vendor Master (General section)
LFB1 Vendor Master (Company Code)
NRIV Number range intervals
RESB Reservation/dependent requirements
T161T Texts for Purchasing Document Types

Movement Type Concept

What Is a Movement Type?When you enter a goods movement in the system, you must enter a movement type to differentiate between the various goods movements. A movement type is a three-digit identification key for a goods movement. The following table contains examples of movement types.

Description of Movement Types

Below you will find a short description of the standard movement types. The reversal movement type is the movement type + 1 (reversal of 101 = 102).
101 Goods receipt for purchase order or order
If the purchase order or order has not been assigned to an account, a stock type (unrestricted-use stock, stock in quality inspection, blocked stock) can be entered during goods receipt.
If the purchase order or order has been assigned to an account, the goods receipt is not posted to the warehouse, but to consumption.
In the case of non-valuated materials, the goods receipt is posted to the warehouse, although the purchase order has not been assigned to an account.
Possible special stock indicators:
• K Goods receipt for purchase order to consignment stock
• O Goods receipt for purchase order to stock of material provided to vendor
• E GR for purchase order or order to sales order stock
• Q GR for purchase order or order to project stock.
Goods receipt for
subcontract order: at goods receipt, the consumption of the components is posted at the same time (see movement type 543)
Goods receipt for
stock transport order: at goods receipt the transported quantity is posted in the receiving plant from stock in transit into unrestricted-use stock (stock in quality inspection or blocked stock).
103 Goods receipt for purchase order into GR blocked stock
You cannot receive goods into goods receipt blocked stock for stock transport orders.
Possible special stock indicators:
K, O, E, Q
105 Release from GR blocked stock for purchase order
Movement type 105 has the same effects as 101.
Possible special stock indicators:
K, O, E, Q
121 Subsequent adjustment for subcontracting
This movement type cannot be entered manually.
With a subsequent adjustment for a subcontract order it is possible to correct the consumption of components. In this case, the material produced by the supplier is credited with the excess consumption / under-consumption. For this reason, if there is a subsequent adjustment, an item is generated for the produced material using movement movement type 121.
Movement type 121 does not have a reversal movement type.
Possible special stock indicators:
O, E, Q
122 Return delivery to supplier or to production
Using movement type 122, you can distinguish real return deliveries for a purchase order or order from cancellations (102).
In the standard version, you must enter a reason for the return delivery if you are using movement type 122. This enables you to carry out evaluations for return deliveries.
The effects of movement type 122 correspond to a cancellation of movement type 101.
Possible special stock indicators:
K, O, E, Q
123 Reversal of return delivery
If you returned a goods receipt using movement type 122, you can reverse the return delivery using movement type 123. This movement type has the same effects as movement type 101.
Possible special stock indicators:
K, O, E, Q
124 Return delivery to vendor from GR blocked stock
Using movement type 124, you can return a goods receipt to GR blocked stock ( 103).
Movement type 124 has the same effects as movement type 104.
Possible special stock indicators:
K, O, E, Q
125 Return delivery from GR blocked stock - reversal
If you returned a goods receipt to GR blocked stock using movement type 124 , you can reverse the return delivery using movement type 125.
Movement type 125 has the same effects as movement type 103.
Possible special stock indicators:
K, O, E, Q
131 Goods receipt for run schedule header
This movement type cannot be entered manually. It is generated automatically at notification of goods receipt for a run schedule header.
Possible special stock indicators:
E, Q
141 Goods receipt for subsequent adjustment for active ingredient
This movement type cannot be entered manually. It is generated automatically upon subsequent adjustment for a proportion/product unit . Subsequent adjustment is necessary if the system finds that there has been excess consumption or under-consumption after a goods receipt posting.
Possible special stock indicators:
K, O, E, Q
161 Return for purchase order
If a purchase order item is marked as a returns item, the returns to vendor are posted using movement type 161 when the goods receipt for purchase order ( 101) is posted.
Movement type 161 has the same effects as movement type 122.
Possible special stock indicators:
K, O, E, Q
201 Goods issue for a cost center
The goods can only be withdrawn from unrestricted-use stock.
Possible special stock indicators:
• K: Goods withdrawal from consignment stock
• P: Goods withdrawal from the pipeline
If you have withdrawals from consignment stock and from pipeline, payables to suppliers ensue.
221 Goods issue for a project
The goods can only be withdrawn from unrestricted-use stock.
Possible special stock indicators:
K, Q
231 Goods issue for a customer order (without Shipping)
You use this movement type if you want to process the delivery without Shipping.
The goods can only be withdrawn from unrestricted-use stock.
Possible special stock indicators:
E, K, Q
241 Goods issue for an asset
The goods can only be withdrawn from unrestricted-use stock.
Possible special stock indicators:
K
251 Goods issue for sales (without customer order)
Use this movement type if you have not entered a customer order in SD. In the standard system, the movement is assigned to a cost center.
The goods can only be withdrawn from unrestricted-use stock.
Possible special stock indicators:
K
261 Goods issue for an order
This refers to all withdrawals for orders (for example, DS:GLOS.3526C388AFAB52B9E10000009B38F974>production orders, maintenance orders), with the exception of customer orders.
Possible special stock indicators:
E, K, P, Q, W
The goods issue can be posted manually in Inventory Management or automatically when an order is confirmed or via a delivery in Shipping.
281 Goods issue for a network
The goods can only be withdrawn from unrestricted-use stock.
The goods issue can also be posted via a delivery in Shipping.
Possible special stock indicators:
E, K, P, Q
291 Goods issue for any arbitrary account assignment
With this movement type, all account assignment fields are ready for input. You can assign the movement to any arbitrary account assignment object.
The goods can only be withdrawn from unrestricted-use stock.
Possible special stock indicators:
E, K, P, Q
301 Transfer posting plant to plant in one step
The quantity is transferred from unrestricted-use stock in the issuing plant to unrestricted-use stock in the receiving plant.
Possible special stock indicators:
E, O, Q, V, W
303 Transfer posting plant to plant in two steps - removal from storage
The quantity is transferred from unrestricted-use stock of the issuing plant tostock in transfer in the receiving plant.
For technical reasons, you cannot carry out transfer postings from plant to plant in two steps for split valuation materials.
Removal from storage can be posted with movement type 603 via Shipping.
Possible special stock indicators:
None
305 Transfer posting plant to plant in two steps - placement in storage
The quantity is posted from stock in transfer to unrestricted-use stock in the receiving plant. The movement is not valuated.
You can use movement type 605 in Shipping to post the goods receipt with reference to the delivery.
Possible special stock indicators:
None
309 Transfer posting material to material
The quantity is posted from unrestricted-use stock of the issuing material into unrestricted-use stock in the receiving material.
Prerequisite: both materials have the same stockkeeping unit.
Possible special stock indicators:
E, O, Q, V, W
311 Transfer posting storage location to storage location in one step
The quantity is transferred from unrestricted-use stock of the issuing storage location to unrestricted use in the receiving storage location.
Possible special stock indicators:
E, K, M, Q
See also 321, 343, 349, and 455 for other stock types
313 Stock transfer storage location to storage location in two steps - removal from storage
The quantity is transferred from unrestricted-use stock of the issuing storage location to stock in transfer in the receiving storage location.
Possible special stock indicators:
None
315 Transfer posting storage location to storage location in two steps - placement in storage
In the receiving storage location, the quantity is transferred from the stock in transfer to the unrestricted-use stock.
Possible special stock indicators:
None
317 Creation of a structured material from constituent components (Retail)
A material split into its components using movement type 319 can be rejoined using movement type 317.
Movement type 317 has the same effect as a cancellation of movement type 319.
Possible special stock indicators:
None
319 Split structured material into components (Retail)
You can enter the splitting of a structured material manually using movement type 319.
You can configure Customizing so that a structured material (for example, aset, prepack, or display is automatically split into its components at goods receipt. The system posts the split using movement type 319. In this process, the BOM header material is posted and each of the component stocks are increased. You can also use this function if you use the Warehouse Management System (LE-WM).
Possible special stock indicators:
None
Example:
A box of the structured material S contains 3 pieces of the component K1 and 4 pieces of the component K2. The following material document items result after the material is split at goods receipt:
Qty Unit Material Movement type
1 box S 101 +
1 box S 319 -
4 piece K1 319 +
5 piece K2 319 +

321 Transfer posting stock in quality inspection - unrestricted-use stock
The quantity is transferred from stock in quality inspection into unrestricted-use stock. Here you can post the quantity to another storage location.
You cannot use this movement type for QM-managed materials since transfer posting for these materials takes place via the usage decision.
Possible special stock indicators:
E, K, O, Q, V, W
323 Transfer posting storage location to storage location - stock in quality inspection
The quantity is transferred from stock in quality inspection in the issuing storage location into stock in quality inspection in the receiving storage location.
Possible special stock indicators:
E, K, Q
325 Transfer posting storage location to storage location - blocked stock
The quantity is transferred from blocked stock in the issuing storage location into blocked stock in the receiving storage location.
Possible special stock indicators:
E, K, Q
331 Withdrawal of sample from stock in quality inspection
The sample is destructive, that is, the withdrawal has the same effects asscrapping.
Possible special stock indicators:
E, K, Q, V, W
333 Withdrawal of sample from unrestricted-use stock
The sample is destructive, that is, the withdrawal has the same effects asscrapping.
Possible special stock indicators:
E, K, Q, V, W
335 Withdrawal of sample from blocked stock
The sample is destructive, that is, the withdrawal has the same effects asscrapping.
Possible special stock indicators:
E, K, Q
340 Revaluation of batch
Using this movement type, you can change a batch's valuation type. The system automatically calls up this movement type when you want to revaluate a batch by choosing Logistics -> Central Functions -> Batch Management -> Batch -> Change (transaction code MSC2N). There is no reversal movement type.
Possible special stock indicators:
E, Q
341 Change in status of a batch (available to unavailable)
This goods movement is automatically created when there is a change in thestatus of a batch and it is also used to transfer the unrestricted-use stock into restricted-use stock.
Possible special stock indicators:
E, K, M, O, Q, V, W
343 Transfer posting blocked stock - unrestricted-use stock
The quantity is transferred from blocked stock to unrestricted-use stock. You can also post the quantity to another storage location.
Possible special stock indicators:
E, K, Q
349 Transfer posting from blocked stock to stock in quality inspection
The quantity is transferred from blocked stock to stock in quality inspection. Here you can transfer the quantity to another storage location.
Possible special stock indicators:
E, K, Q
351 Goods issue for a stock transport order (without Shipping)
The quantity is transferred from unrestricted-use stock in the issuing plant tostock in transit in the receiving plant.
Movement type 351 is only used if the goods issue is posted without a delivery in Shipping. A goods issue for a stock transport order with delivery in Shipping is posted using movement types 641, 643, 645, or 647.
The transfer posting is also possible for materials with split valuation.
The goods issue for a stock transport order takes place using movement type 101.
Possible special stock indicators:
E, Q
For special stock indicators E and Q and for purchase orders assigned to an account, ensure that the quantity is not posted to the stock in transit in the receiving plant.
411 Transfer posting of special stocks E, K, and Q to company's own stock
The quantity is transferred from unrestricted-use special stock E (sales order stock), unrestricted-use stock K ( consignment stock) and unrestricted-use special stock Q (project stock) to unrestricted-use storage location stock. The corresponding special stock indicator is required for this movement.
If you do not use the special stock indicator, the system uses this movement type and movement type 311.
For sales order stock, you can change the material number for this movement if you manage the material in your company's own stock under a different material number (for example, for configurable materials).
Consignment stock is transferred to valuated stock, thus resulting in a vendor liability.
413 Transfer posting to sales order stock
You can use this movement type to carry out a transfer posting from your own unrestricted-use stock, other sales order stock, consignment stock, and project stock to a sales order stock.
Possible special stock indicators:
E, K, Q
415 Transfer posting to project stock
You can use this movement type to carry out a transfer posting from your own unrestricted-use stock, consignment stock, and other project stock to a project stock.
Possible special stock indicators:
E, K, Q
441 Transfer posting non-tied to tied empties
Part of the stock of an "empties" material assigned to a full product is managed in the stock type "tied empties".
Empties stock not assigned to a full product forms part of the stock type "unrestricted-use".
Using movement type 441, you can make a transfer posting for an empties material from the stock type "unrestricted-use" to the stock type "tied empties". Movement type 442 reverses this transaction.
Example:
The full product "beer" has a stock of 15 cases. Part of the empties components "bottle" and "case" is tied empties stock.
Material unrestricted-use tied empties
Beer 15
Bottle 240 360
case 10 15

451 Returns from customer (without Shipping)
Using movement type 451, you post customer returns without a returns delivery in Shipping into blocked stock returns.
Possible special stock indicators:
None
See also: 453, 651, 653
453 Transfer posting blocked stock returns to unrestricted-use stock
The quantity is transferred from blocked stock returns to unrestricted-use stock and thereby transferred to valuated stock.
With this movement you can transfer the quantity to another storage location at the same time.
Possible special stock indicators:
None
455 Transfer posting storage location to storage location - blocked stock returns
The quantity is transferred from blocked stock returns of the issuing storage location to blocked stock returns of the receiving storage location.
Possible special stock indicators:
None
457 Transfer posting blocked stock returns to quality inspection stock
The quantity is transferred from blocked stock returns to quality inspection stock and thereby transferred to valuated stock.
With this movement you can transfer the quantity to another storage location at the same time.
Possible special stock indicators:
None
459 Transfer posting blocked stock returns to blocked stock
The quantity is transferred from blocked stock returns to blocked stock and thereby transferred to valuated stock.
With this movement you can transfer the quantity to another storage location at the same time.
Possible special stock indicators:
None
501 Goods receipt without purchase order - unrestricted-use stock
This movement type is used for deliveries from vendors that are not based on a purchase order. Invoice verification is not possible for these goods receipts.
For a goods receipt for purchase order (
101), the receipt of returnable transport packaging can be entered using movement type 501 and special stock indicator M.
Possible special stock indicators:
E, K, M, Q
503 Goods receipt without purchase order - stock in quality inspection
This movement type is used for deliveries from vendors that are not based on a purchase order. Invoice verification is not possible for these goods receipts.
Possible special stock indicators:
E, K, Q
505 Goods receipt without purchase order - blocked stock
This movement type is used for deliveries from vendors that are not based on a purchase order. Invoice verification is not possible for these goods receipts.
Possible special stock indicators:
E, K, Q
511 Free-of-charge delivery from vendor
The quantity is posted to unrestricted-use stock. If there is a material with moving average price, the moving average price is reduced accordingly.
Possible special stock indicators:
None
521 Goods receipt without order - unrestricted-use stock
This movement type is used for deliveries from production that are not based on an order.
Possible special stock indicators:
E, Q
523 Goods receipt without order - stock in quality inspection
This movement type is used for deliveries from production that are not based on an order.
Possible special stock indicators:
E, Q
525 Goods receipt without order - blocked stock
This movement type is used for deliveries from production that are not based on an order.
Possible special stock indicators:
E, Q
531 Goods receipt from by-product from the order
The goods receipt of a by-product usually refers to an order, but it can be entered without a reference.
If a component is entered with a negative quantity in the order, a reservation item is created with 531 (instead of 261 ). The receipt of a by-product can be entered when the component for the order is withdrawn from stock or it can be entered as an 'other goods receipt'.
Possible special stock indicators:
E, Q
See also: 545 and 581
541 Transfer posting unrestricted-use stock - stock of material provided to vendor
With this movement type you provide the subcontractor with the components required for subcontract orders. The quantity is posted into unrestricted-use stock of material provided to vendor.
If there is a goods receipt for a subcontract order ( 101 ) consumption of components is posted from this stock.
The transfer posting can be posted via a delivery in Shipping.
Possible special stock indicators:
None
543 Consumption from stock of material provided to vendor
This movement cannot be entered manually.
The consumption of components for a subcontract order is posted using goods receipt for purchase order ( 101). It can be corrected by means of a subsequent adjustment.
For special stock indicators E and Q, you must ensure that the quantity is not posted to the stock of material provided to vendor, but to the unrestricted-use sales order or project stock.
Possible special stock indicators:
E, O, Q
545 Goods receipt from by-product from subcontracting
If a component is entered with a negative quantity for the subcontract order, the receipt of the by-product is posted to stock provided to vendor during goods receipt for purchase order or during the subsequent adjustment.
For special stock indicators E and Q, you must ensure that the quantity is not posted to the stock of material provided to vendor, but to the unrestricted-use sales order or project stock.
Possible special stock indicators:
E, O, Q
551 Scrapping from unrestricted-use stock
Possible special stock indicators:
E, K, O, Q, V, W
553 Scrapping from stock in quality inspection
Possible special stock indicators:
E, K, O, Q, V, W
555 Scrapping from blocked stock
Possible special stock indicators:
E, K, Q
561 Initial entry of stock - unrestricted-use stock
During
initial entry of stock balances, when the R/3 system is active, you enter the physical warehouse stock figures or the book inventory from your old system into the R/3 Materials Management component. This data entry usually takes place by means of batch input.
Possible special stock indicators:
E, K, M, O, Q, V, W
563 Initial entry of stock - quality inspection
During
initial entry of stock balances, when the R/3 system is active, you enter the physical warehouse stock figures or the book inventory from your old system into the R/3 Materials Management component. This data entry usually takes place by means of batch input.
Possible special stock indicators:
E, K, O, Q, V, W
565 Initial entry of stock - blocked stock
During
initial entry of stock balances, when the R/3 system is active, you enter the physical warehouse stock figures or the book inventory from your old system into the R/3 Materials Management component. This data entry usually takes place by means of batch input.
Possible special stock indicators:
E, K, Q
571 Goods receipt for assembly order to unrestricted-use
This movement cannot be entered in Inventory Management. It can only be entered in repetitive manufacturing using the Goods receipt for sales order function.
Possible special stock indicators:
E, Q
573 Goods receipt for assembly order to quality inspection
This movement cannot be entered in Inventory Management. It can only be entered in repetitive manufacturing using the Goods receipt for sales order function.
Possible special stock indicators:
E, Q
575 Goods receipt for assembly order to blocked stock
This movement cannot be entered in Inventory Management. It can only be entered in repetitive manufacturing using the Goods receipt for sales order function.
Possible special stock indicators:
E, Q
581 Goods receipt of a by-product from the network
The goods receipt of a by-product usually refers to anetwork, but can be entered without reference.
If a component is entered with a negative quantity in the network, a reservation is created with 581 (instead of 281 ). The receipt of a by-product can be entered during the withdrawal for the network or as an 'other goods receipt'.
Possible special stock indicators:
E, Q
601 Goods issue for delivery (Shipping)
In Shipping, this movement type is created automatically with the Goods issue for delivery function.
The quantity is taken from unrestricted-use stock.
Possible special stock indicators:
E, K, Q
603 Goods issue for stock transport order (Shipping) with additional
item
If you issue goods for a stock transport order in Shipping using movement type 641, you can use this movement type to assign an extra item to the order.
The ordered material is transferred to the stock in transit of the receiving plant. The material for the additional item is transferred from unrestricted-use stock in the issuing plant to stock in transfer in the receiving plant.
You can also use this movement type without referencing a purchase order.
Possible special stock indicators:
None
See also: 303, 641
605 Goods receipt for a stock transport order (Shipping) with
additional item
You can use this movement type to transfer into unrestricted-use stock the material you posted into stock in transfer in the receiving plant using movement type 603. You post the goods movement with reference to the purchase order (if available) or the delivery.
Possible special stock indicators:
None
See also: 305 and 641
621 Transfer posting unrestricted-use - returnable packaging (Shipping)
The quantity is transferred from unrestricted-use stock to the returnable packaging stock at customer.
Possible special stock indicators:
none
623 Goods issue from returnable packaging stock at customer (Shipping)
This quantity is withdrawn from unrestricted-use returnable packaging stock at the customer.
Possible special stock indicators:
V
631 Transfer posting unrestricted use - customer consignment stock (Shipping)
The quantity is transferred from unrestricted-use stock to consignment stock at customer.
Possible special stock indicators:
E, Q
633 Goods issue from customer consignment (Shipping)
The quantity is withdrawn from unrestricted-use consignment stock at the customer.
Possible special stock indicators:
W
641 Goods issue for a stock transport order (Shipping)
The quantity is transferred using a delivery in Shipping from unrestricted-use stock of the issuing plant to stock in transit of the receiving plant.
The goods receipt for the stock transport order takes place using movement type 101 and can, if required, refer to the purchase order or to the delivery. If a purchase order item is flagged as a returns item in the stock transport order, you can post the goods receipt of the returns in the issuing plant with movment type 671.
Possible special stock indicators:
E, Q
For the special stock indicators E and Q and for purchase orders assigned to an account, you must ensure that the quantity is not posted to the stock in transit of the receiving plant.
See also: 351, 643, 671
643 Goods issue for a cross-company
stock transport order (Shipping)
It is used only for cross-company stock transport orders with SD billing and invoice. The quantity is withdrawn from the unrestricted-use stock of the issuing plant. No stock in transit is created here. In the second step, the goods receipt must be entered in the receiving plant. If a purchase order item is flagged as a returns item in the stock transport order, you can post the goods receipt of the returns in the issuing plant with movment type 673.
Possible special stock indicators:
E
See also: 351, 641, 673
645 Goods issue for a cross-company
stock transport order in one step (Shipping)
Unlike movement type 643 when a goods issue is posted using movement type 645, a goods receipt line is generated automatically 101). If a purchase order item is flagged as a returns item in the stock transport order, you can post the goods receipt of the returns in the issuing plant with movment type 675.
Possible special stock indicators:
E
See also: 675
647 Goods issue for a stock transport order in one step
(Shipping)
Unlike movement type 641 when a goods issue is posted using movement type 647, a goods receipt line (movement type 101) is generated automatically in the receiving plant. If a purchase order item is flagged as a returns item in the stock transport order, you can post the goods receipt of the returns in the issuing plant with movement type 677.
Possible special stock indicators:
E, Q
See also: 677
651 Returns from customer (Shipping)
Using movement type 651, you post returns from a customer with a return delivery in Shipping to blocked stock returns.
Possible special stock indicators:
None
See also: 451, 453, 653
653 Returns from customer (Shipping) to unrestricted-use stock
With this movement type you post returns from the customer with returns delivery via Shipping directly to the valuated stock.
Possible special stock indicators:
E
See also: 451, 453, 651
655 Returns from customer (Shipping) to stock in quality inspection
With this movement type you post returns from the customer with returns delivery via Shipping directly to the valuated stock.
Possible special stock indicators:
E
See also: 451, 453, 651
657 Returns from customer (Shipping) to blocked stock
With this movement type you post returns from the customer with returns delivery via Shipping directly to the valuated stock.
Possible special stock indicators:
E
See also: 451, 453, 651
661 Returns to vendor via Shipping
As with movement type 502, a return delivery to the vendor is entered without reference to the purchase order, but the goods issue is posted via a delivery in Shipping.
Possible special stock indicators:
E
671 Returns for stock transport order via Shipping
If a purchase order item is marked as a returns item in a stock transport order using movement type 641 when a goods receipt for a stock transport order ( 101) is posted, the return is posted to stock in transit using movement type 161. When the return arrives, the issuing plant posts the goods receipt for the return using movement type 671. Movement type 671 (like movement types 352 and 642) reduces the receiving plant's stock in transit and increases the issuing plant's unrestricted-use stock.
Possible special stock indicators:
E, Q
673 Returns for cross-company stock transport order
(Shipping)
If you post a goods issue for a cross-company stock transport order with returns items using movement type 643 via Shipping, the returns are transferred to unrestricted-use stock in the issuing plant in a second step using movement type 673.
Possible special stock indicators:
None
See also: 643
675 Returns for cross-company stock transport order
(Shipping) in one step
If you use movement type 645 to post a goods issue for a cross-company stock transport order with returns items in one step, the returns are transferred to unrestricted-use stock in the issuing plant using movement type 161 in the receiving plant and movement type 675 in the issuing plant.
Possible special stock indicators:
None
See also: 645
677 Returns for stock transport order in one step (Shipping)
If you use movement type 647 to post a goods issue for a stock transport order with returns items in one step, the returns are transferred to unrestricted-use stock in the issuing plant using movement type 161 in the receiving plant and movement type 677 in the issuing plant.
Possible special stock indicators:
E, Q
See also: 647
701 Inventory differences in unrestricted-use stock (MM-IM)
This movement is generated automatically during inventory difference posting in Inventory Management.
Possible special stock indicators:
E, K, M, O, Q, V, W
703 Inventory differences in quality inspection stock (MM-IM)
This movement is generated automatically during inventory difference posting in Inventory Management.
Possible special stock indicators:
E, K, M, O, Q, V, W
707 Inventory differences in blocked stock (MM-IM)
This movement is generated automatically during inventory difference posting in Inventory Management.
Possible special stock indicators:
E, K, M, Q
711 Inventory differences in unrestricted-use stock (LE-WM)
This movement is generated automatically when you post inventory differences in the Warehouse Management System.
Possible special stock indicators:
E, K, M, Q
713 Inventory differences in quality inspection stock (LE-WM)
This movement is generated automatically when you post inventory differences in the Warehouse Management System.
Possible special stock indicators:
E, K, M, Q
715 Inventory differences in blocked stock returns (LE-WM)
This movement is generated automatically when you post inventory differences in the Warehouse Management System.
Possible special stock indicators:
None
717 Inventory differences in blocked stock (LE-WM)
This movement is generated automatically when you post inventory differences in the Warehouse Management System.
Possible special stock indicators:
E, K, M, Q
721 - Sales value receipt - not affecting margins (Retail)
The movement is generated automatically when the sales price of a value-only material is changed (total sales price revaluation on the posting date).
Possible special stock indicators:
None
731 - Sales value receipt - affecting margins (Retail)
The movement is generated automatically when the sales price of a value-only material is changed (partial sales price revaluation on the posting date).
Possible special stock indicators:
None

MM Data Flow

The dataflow as functional process below are the points:
1) Purchasing Requsition -> sent by inventory dept to purcharsing dept
2) Request for Quotation(RFQ)-> Purchasing Dept shall ask the vendors to give the quotation for the requested materials by inventory.
3) Quotation -> Quotation is sent by vendors to the company
4) Purchase order-> Based on all paramers of a quotation sent by vendors. Vendors are selected from whom the material has to be obtained. The company gives purchase order to the vendor.
5) Good's receipt -> vendors sends the goods to the company with goods receipt
6) Invoice verification -> this done based on good's receipt. this means that the ordered goods have reached or not.
7) Payment -> payment is done based on invoice verification. this is (FI/CO) *--


Full MM Transaction Codes Flow:

RFQ to Vendor - ME41
Raising Quotation - ME47
Comparison of Price - ME49
Creation of PO - ME21N
Goods Receipt - MIGO
Invoice (Bill PAssing) - MIRO
Goods Issue - MB1A
Physical Inventory - MI01( Create doc)
MI04 (Enter Count)
MI07 (Post)

The FI - MM integration:

First you define the g/l master records.
1) Inventry raw material a/c
2) GR/IR clearing a/c
3) Raw material consumption a/c
Above like this you define all required g/l accounts then you will go to T.CODE - OBYC
Double click BSX (this is transaction key)
" GBB
" WRX
" PRD
These are transaction keys important.
Then you go to T CODE - OMSY (this is also important) then
Material creation T Code MM01
then
1) Purchase order T.code ME21N
2) Goods received " MIGO
3) Invoice verification " MIRO

Bill Of Material

Bill of material (BOM)
A list of all of the items that make up a product or assembly. The list is complete for its given purpose, has a formal structure, and states the name, quantity, and unit of measure for each component. A comprehensive PLM solution should offer support for the following categories of BOM: feature and requirements structures, material BOM, document structure, equipment BOM, functional location BOM, sales order BOM, and work breakdown structure BOM.
BOM Transaction codesCS00 BOM Menu
CS01 Create Material BOM
CS02 Change Material BOM
CS03 Display Material BOM
CS05 Change Material BOM Group
CS06 Display Material BOM Group
CS07 Allocate Material BOM to Plant
CS08 Change Material BOM - Plant Alloc.
CS09 Display Allocations to Plant
CS11 Display BOM Level by Level
CS12 Multilevel BOM
CS13 Summarized BOM
CS14 BOM Comparison
CS15 Single-Level Where-Used List
CS20 Mass Change: Initial Screen
CS21 Mass Material Change: Initial Screen
CS22 Mass Document Change: Initial Screen
CS23 Mass Class Change: Initial Screen
CS25 Archiving for BOMs
CS26 BOM deletion
CS27 Retrieval of BOMs
CS28 Archiving for BOMs
CS31 Create class BOM
CS32 Change class BOM
CS33 Display class BOM
CS40 Create Link to Configurable Material
CS41 Change Material Config. Allocation
CS42 Display Material Config. Assignment
CS51 Create standard BOM
CS52 Change standard BOM
CS53 Display standard BOM
CS61 Create Order BOM
CS62 Change Order BOM
CS63 Display Order BOM
CS71 Create WBS BOM
CS72 Change WBS BOM
CS73 Display WBS BOM
CS74 Create multi-level WBS BOM
CS75 Change multi-level WBS BOM
CS76 Display multi-level WBS BOM
CS80 Change Documents for Material BOM
CS81 Change Documents for Standard BOM
CS82 Change documents for sales order BOM
CS83 Change documents for WBS BOM
CS84 Change documents for class BOM
CS90 Material BOM Number Ranges
CS91 Number Ranges for Standard BOMs
CS92 Number Ranges for Sales Order BOMs

SAP PP Master Data Tables

MASTER DATA
Engineering Change Management
AENR Customer and priority
AEOI Revision Numbers

Work Center
CRHD Workcenter Header Data
CRCA Workcenter Capacity Allocation
CRCO Workcenter Cost Center Assignment
CRHH Hierarchy Header
CRHS Hierarchy Structure
CRTX Workcenter Text
KAKO Capacity Header
KAZY Intervals of Capacity

Routing
PLPO Routing Operation Details
PLKO Routing Header Details
MAPL Routing Link to Material
PLAB Relationships - Standard Network
PLAS Task List - Selection of Operations
PLMZ Component Allocation
PLPH CAPP Sub-operations
PLFH PRT Allocation
PLWP Maintenance Package Allocation
PLMK Inspection Characteristics

Bill of Material
STPO BOM Item Details
STPU BOM Sub Items (designators)
STKO BOM Header Details
MAST BOM Group to Material
STZU BOM History Records
STAS BOM Item Selection
STPF BOM Explosion Structure

Line Design

LDLH Line Hierarchy Header
LDLP Line Hierarchy Items
LDLT Line Hierarchy Takt Times
LDLBC Takts/No. Individual Capacities per Line
LDLBH Line Balance Header
LDLBP Line Balance Items
LDLBT Line Hierarchy Entry and Exit Takts

PRT's

CRFH PRT Master Data
CRVD_A Link of PRT to Document
CRVD_B Link of Document to PRT
CRVE_A Assignment of PRT data to Equipment
CRVE_B Assignment of equipment to PRT data
CRVM_A Link of PRT data to Material
CRVM_B Link of Material to PRT data
CRVS_A Link of PRT Internal number to PRT External number
CRVS_B Link of PRT External number to PRT Internal number

Thursday, January 12, 2012

Error Stack & Error DTP

Error Stack &Error DTP Definition

A request-based table (PSA table) into which erroneous data records from a data transfer process are written. Theerror stack is based on the data source, that is, records from the source are written to the error stack.
Use
At runtime, erroneous data records are written to an error stack if the error handling for the data transfer process isactivated. You use the error stack to update the data to the target destination once the error is resolved.
Integration
In the monitor for the data transfer process, you can navigate to the PSA maintenance by choosing
Error Stack
inthe toolbar, and display and edit erroneous records in the error stack.With an error DTP, you can update the data records to the target manually or by means of a process chain. Oncethe data records have been successfully updated, they are deleted from the error stack. If there are any erroneousdata records, they are written to the error stack again in a new error DTP request.When a DTP request is deleted, the corresponding data records are also deleted from the error stack.
Introduction
Error Stack is a request-based table (PSA table) into which erroneous data records from a data transfer process(DTP) are written. The error stack is based on the data source (PSA, DSO or Info Cube), that is, records from thesource are written to the error stack.For a data transfer process (DTP), you can specify how you want the system to respond when data recordscontain errors. If you activate error handling, the records with errors are written to the error stack. You can use aspecial data transfer process, the error DTP, to update the records to the target.

 
 
 
 
 
 
Settings for Error Handling
For a data transfer process (DTP), you can specify how you want the system to respond when data recordscontain errors. If you activate error handling, the records with errors are written to a request-based database table(PSA table). This is the error stack. You can use a special data transfer process, the error DTP, to update therecords to the target.Temporary storage is available after each processing step of the DTP request. This allows you to find out whichprocessing step the error occurred in.
Step 1: Analyze Erroneous Records
Go to the Update tab of the DTP of the target where there are erroneous records. Error Stack is availableafter each processing step of the DTP request. This allows you to find out which processing step the error occurred in.
Examples of Incorrect Data Records
1.Field contains invalid characters or lowercase characters
2.Error during conversion 
3.Characteristic value is not found for master data
4.Duplicate data records with relation to keys
5.If no SID exists for the characteristic value
6.If no SID exists for the value of the navigation attribute
7.A routine returns a return code <> 0

Step 3:Enable Error Stack
Change the DTP to Edit Mode and on the Update tab of DTP; select the Error Handling mechanism based on howyou want system to respond to data records with errors.The various error handling mechanisms are explained as below:-
a).No update, no reporting (default) - If errors occur, the system terminates the update of the entiredata package. The request is not released for reporting. The system continues checking the recordshowever.
b).Update valid records, no reporting (request red) - This option allows you to update valid data.This data is only released for reporting after the administrator checks the incorrect records that havenot been updated and manually releases the request by setting the overall status on the
Status tabpage in the monitor (QM action).
c).Update valid records, reporting possible - Valid records can be reported immediately. Automaticfollow-up actions, such as adjusting the aggregates, are also carried out. 
 
Note: Specify the maximum number of incorrect data records allowed before the system terminates the transfer process. If you leave this blank, handling for incorrect data records is not activated, and the update is terminatedas soon as the first error occurs.
 
Step 4: Define Semantic Groups
Go to Extraction tab of the DTP and click on Semantic Groups to define the Semantic Groups to define the keyfields of error stack.This setting is only relevant if you are transferring data to Data Store objects (DSO) with data fields that areoverwritten. If errors occur, all subsequent data records with the same key are written to the error stack along withthe incorrect data record.This guarantees the serialization of the data records, and consistent data processing. The serialization of the datarecords and thus the explicit definition of key fields for the error stack are not relevant for targets that are notupdated by overwriting like Info Cube.The fields in the source can be enabled in the semantic group definition as per the below rules:
 
By default, all fields in the source that are uniquely assigned to a key field of the target DSO in thetransformation are checked in the semantic group screen.
The fields whose assignment is not unique are not checked by default, but can be enabled.
The fields in source which are assigned to the data field in the target DSO cannot be checked.
 
 
Step5:Settings for Error Stack
Also the DTP Error Stack settings can be modified by clicking on the Goto Settings for DTP Temporary Storageof the DTP.The various options available in the Settings for Temporary Storage are as given below:1. Delete Temporary Storage ± To delete the records in the Error Stack as per below conditions:-
With Request Status Green
With Request Status Red
 
After days2. Level of Detail - you specify how you want to track the transformation.3. Fill Temporary Storage - you specify the processing steps after which you want the system totemporarily store the DTP request (such as extraction, filtering, removing new records with the same key and transformation)
 
transformation)
 
Step 5:Execute the DTP load
Save and activate the DTP after the settings are completed. Execute the DTP to load the data from the PSA to thedata target. If there are erroneous records in the data load, they are collected in the error stack.You can access the error stack by clicking on the error stack on top of DTP.
Step6: Validate Erroneous records in Error Stack
In the monitor for the data transfer process, you can navigate to the PSA maintenance by choosing Error Stack in the toolbar, and display and edit erroneous records in the error stack.Validate and correct the erroneous records similar to editing the PSA and save the records.
 
 
 
Step 7: Create and execute the Error DTP
Click on the Creating Error DTP on the Update tab of DTP to move data from error stack to the target. With anerror DTP, you can update the data records to the target manually or by means of a process chain. The error DTPuses the full update mode to extract data from the error stackOnce the data records have been successfully updated, they are deleted from the error stack. If there are anyerroneous data records, they are written to the error stack again in a new error DTP request.When a DTP request is deleted, the corresponding data records are also deleted from the error stack.
Execute the Normal DTP  From the below screen shot you can check that 4 records having incorrect data went into ERROR STACK and 2records got updated to DSO.
 
Check the Manage screen
Check theERROR STACK  data
Below are the 4 erroneous records.
Correct the ERROR STACK data.
 
 
 
records.Correct the ERROR STACK data.
Execute ERROR DTP Load the corrected data from ERROT STACK to Data Target through executing ERROR DTP.
7. Activate the Request.
The two requests are available in manage of DSO one from Normal DTP, other with ERROR DTP.
Error DTP in the Administrator Workbench
Result:
You can use the data transfer process to update the data to the target destination once the error is resolved.
 
 

How To Group Records in a Data Package (DTP) in SAP Netweaver BW (BI)



How To Group Records in a Data Package (DTP) in SAP Netweaver BW (BI)
Here is an example where I wanted to specify how the records are read and formed when data is loaded in BW. That is, I wanted to ensure certain groups of data are logically packaged in one data package (DTP) and not sprinkled across two different data packages.
In this example, I have created a custom data model that shows the related serial number(s) for a given delivery number, item, and material number. When loading the infocube, I want to ensure that all serial numbers for a given delivery number, item, and material are contained within the same data transfer package (DTP).
However, the settings for Semantic Groups are unavailable by default (as seen below)
Fig. 1 Semantic Group is disabled by default.
Before you can specify the Semantic Grouping, you will need to decide how error records are handled.
Navigate to the ‘Update’ tab and click on the ‘Error Handling’ window to see the four options:
  • Deactivated
  • No Update, No Reporting (default)
  • Valid Records Update, No Reporting (Request Red)
  • Valid Records Update, Reporting Possible (Request Green)
To learn more about error handling, please visit the following page. http://help.sap.com/saphelp_nw70/helpdata/en/42/fbd598481e1a61e10000000a422035/content.htm


Error Stack Setting in SAP Netweaver BW (BI)
Fig. 2 Default Error Stack Setting
In my scenario, I want to be alerted when errors occur and I want process the errors before the records are sent to the data target.
Selecting the option “Valid Records Update, No Reporting (Request Red)” will leave the error records in the error stack and set the QM status for this request to Red. Now that I have chosen my error handing option, I can set Semantic Group.
Error Stack Setting in SAP Netweaver BW (BI)
Fig 3. Custom Error Package Setting
Navigate to the ‘Extraction’ tab and confirm that a Green checkmark appears next to the ‘Semantic Group’ button. This indicates that a selection has been made.
Click on the ‘Semantic Group’ button and confirm that a ‘Selection of Key Fields for Error Stack’ window appears.
Now, you can determine how the system groups the records when reading from the data source. Unselect the unnecessary fields. Leave the key fields for your logical group as checked.
Semantic Group via DTP in SAP Netweaver BW (BI)
Fig. 4 Semantic Grouping is now available
Update (1/14/2011):
Recently, I had to implement my own version of the obsolete ABAP construct “ON CHANGE OF” event block and found the following to be true: While records may be grouped in a DTP as shown above, you cannot assume that they are sorted by the DSO keys as defined.
You will need to perform an explicit “SORT” on the source/result package as required by your start/end routine logic if you are performing custom comparison operations. Be diligent! =D

Monday, January 9, 2012

Process Chain Scheduling

While Scheduling a Process Chain, there are two options :

The start process is set to Direct scheduling.:

  • BI_PROCESS_TRIGGER is released with configured start options.
  • Subsequent application processes are scheduled and released as event

triggered jobs.

The start process is set to Start Using Meta Chain or API :

  • No BI_PROCESS_TRIGGER is scheduled or released. You have to start

the process chain via another process chain or API (Function module:

RSPC_API_CHAIN_START). This provides flexibility to schedule process

chains with the help of a driver ABAP program.

  • Subsequent application processes are scheduled and released as event

triggered jobs.

  • In this case Change Selection option will not be there.



Scheduling scenario for Direct scheduling :



Scheduling a Process Chain on a particular day of every Month

Suppose we want to schedule a Process chain on 1st of every month....

Open the Chain in Planning mode ( RSPC or RSPC1) >> Right click on the Start Process >> Display variant >> Change Selections >> Click on Date/Time tab >> there click on Periodic Values Tab



image"



There Click on Other Period >> there in the Day(S) field enter 1.....



image



Then Check and Save >> Again Check and Save .........

Then in the Scheduled start field give the date when the Chain is going to run for the first time.............and Enter the time in the Time field....

Then the Process chain will run on 1st of every Month...

Or U can do it in another way....

Click on Periodic Values Tab >> There click on Monthly.....Check and Save.

In the Schedule Start date field enter 1st .Then the chain will run on first of every month.



image



Schedule a process chain at different times during the day

Suppose we need to run a Process Chain twice a day daily.........at two different timings......X and Y.....

Open the Chain in Planning mode ( RSPC or RSPC1) >> Right click on the Start Process >> Display variant >> Change Selections >> Click on Date/Time tab ....

There in the Scheduled start field give the date when the Chain is going to run for the first time.............and Enter the time in the Time field.......X

Then click on the Periodic value tab and Click on Daily.......



image



Then Check and Save ..............again Check and save.......

Activate and Schedule the Chain......

Now right Click on the Start Process >> Display Scheduled Jobs >> there u will find one Release Job (BI_PROCESS_TRIGGER) >> Select the Job >> In the top JOB tab >> Click on it and select Repeat Scheduling



image

image



There Click on Date/Time tab.................maintain the date and enter time Y......Select Periodic Job Check Box >> Check and save ...................then come out...........

Then u will find that the Start Process is in red color.........it means that the Process chain is scheduled for multiple times..........i.e. it has more than one Release Job.......

Suppose u want to run the chain 5 or 6 times a day........

You can do it in this way........or you can do it in another way......

Create an Event in SM62............

Then go to SM36 Give a Job name >> Then click on Steps >> Click on ABAP Program >>Give the Program name BTC_EVENT_RAISE >> In the Variant Field Enter the Event created in SM62 >> Check and Save.....



image



Then click on the Start Condition >> Click on Date/Time tab >> Give the date and give the First time......

In this way create 5 different Jobs by giving 5 different timings......

Maintain this Event in the Start condition of the Process chain.

Note : BTC_EVENT_RAISE is available in BI 7.0.............for BW 3.X..........create a Program using function module "BP_EVENT_RAISE" and pass the event name as parameter. Save this as variant.

Check SAP Note : 919458 for Documentation.



Schedule a Process Chain to run only for X number of days of a month



Suppose we need to run a Process chain every first 15 days and Last two days of every month.....

In this case..........Create a Factory Calendar using Tcode SCAL.......there declare first 15 days and Last two days as Working days and rest all as Holidays....

Right click on the Start Process >> Display variant >> Change Selections >> Click on Date/Time tab >> Click on the Restriction tab (F6) >> there maintain the Calendar id and Select Do not Execute on Sundays or Holid.........>> Then Check and Transfer........... Then in the Scheduled start field give the date when the Chain is going to run for the first time............

Then the Process chain will only run as per the above requirement.....



image



Trigger Event at R/3 to BW side

Suppose we want to Schedule a Process chain as event based.This event will be trigger from R/3 to BW :

In BW System:


1. Create New Z-Program with Parameters Event Id, Event Parameter and In the Code Use BP_EVENT_RAISE Function raise Event With Parameter. Create Transaction ZEVENT for this Program.
2. Create Process Chain to Load Data from R/3 to BW.
3. Schedule this process chain after the Event and parameter. Activate and Schedule this process Chain.
4. Now Run SHDB to Create BDC code for this Transaction'ZEVENT' with Parameters of Event and Event parameters.
Now BW is Ready to Load after

In R/3 System :


1. Call Function RFC_CALL_TRANSACTION with 'ZEVENT' Transaction and BDC Table with Correct Event and Parameter. Use Destination as your BW System.
2. Check SM59 for BW Connection.
This Function Execute the Transaction in BW system. That will Raise the Trigger Required and that will Start the Process Chain and Load the Data.