Customer sends his Order forecast, From Interface it comes to SAP System through IDocs SO will be generated,that SO triggers purchase requistion and we have a batch job runs every hour to create purchase orders for Vendor. When the Vendor Sends goods to Customer and the same has notified to the Company, based on that we create Inbound Deliveries(VL31N) and Goods Receipt(MIGO or VL32N PGR) in our SAP System.
We have batch jobs running every hour to create Goods Receipt for inbound deliveries and Billing due(RV60SBAT) list to generate Billing documents.This Billing is created based on the sales order quantity(Since it is Order Related Billing).Now the Customer wants billing based on the delivery quantity they received from vendor.Here we are not doing any Outbound Delivery.
We used one Data Transfer Routine from Order to Billing in item category TAS at data VBRK/VBRP level(We copied the standard routine 003 and done modifications to get the inbound delivery no) This routine navigates from the sales document table(vbep) to the Purchase Requisition table(eban) to the Purchase Order history table (ekbe) and to the Material Document no to obtain Inbound Delivey Number
We are successful to some extent in creation of billing document.but the problem is when there are 3 inbound deliveries for one purchase order, it is creating only one invoice for 1 of 3 inbound deliveries.but we need 3 different invoices for 3 inbound deliveries.
Previous scenario: SO quantity is 100. Delivey quantity is say 20,30,50. Billing Quantity is 100
Present scenario : SO quantity is 100. Delivey quantity is say 20,30,50. Billing Quantity is 20,30,50
Customer wants billing for the quantitiies 20,30,50 not for 100