Saturday, April 18, 2015

Vendor Partner Function Determination

Vendor Partner Function Determination

1- Define Partner Schemas :

SPRO / Materials Management / Purchasing / Partner Determination / Partner Settings in Purchasing Documents / Define Partner Schemas

     No change indicator : If you want to prevent changes in partner defined in the vendor master record and prevent deleting partner roles, it is set.

      Mandatory indicator : Whether a partner role is mandatory in a vendor master or PO.

      Higher level indicator : If partner role does not been found in plant or sub-range level, sap looks for partner role at purchasing organization level. Hpwever, higher level is used process of automatic creation PO.

     End indicator : If it is set , partner role is defaulted from vendor master when document is saved or checked. It is useful when different data is added in the vendor at the plant/vendor subrange. Whether all items contain same plant or subrange. Invoicing parties are not determinated until end of document process PO so end incator might change it.

2- Define Settings for Vendor Master Records :
SPRO / Logistics - General / Business Partner / Vendors / Control / Define Account Groups and Field Selection (Vendor)


4- Allowed partner roles

You can do with Account group : Field reference , Permitted partner roles


After that specify partner role VN is allowed for account group ZVMU.


SPRO / Materials Management / Purchasing / Partner Determination / Partner Roles / Define Permissible Partner Roles per Account Group

Tuesday, March 17, 2015

TABU Transport Request for cases like OBYC update

OBYC transports will by default transport the whole table, e.g. for GBB the whole list.
If you were to transport only selected ones, follow the following steps. These are useful in the event that multiple projects are going on, and you do not want to overwrite each other.
1. SE10
2. Create a Workbench TR
3. Click on the Task, then select Change Type to change it from Unclassified to Development/Correction
4. Enter the following details in the TR
Remember, to update the Table value, double click on the White Table key space and you will get a popup to enter the table values
5. NOTE* For Rules e.g. Debit / Credit, Object T030R is required.



For the case of Factory Calendar


ZY in the screen below is the Factory Calendar




ZYE is the Factory Calendar plus English Language Key




Thursday, March 5, 2015

EWM Outbound Delivery Order (ODO) Issue where Goods are issued but no Outbound Delivery (OD) document generated

EWM Outbound Delivery Order (ODO) Issue where Goods are issued but no Outbound Delivery (OD) document generated

From time to time, check the list of Outbound Delivery Orders on whether they have been Post Goods Issued completely. Completely in this matter means, Outbound Delivery (OD) are subsequently created and PPF Action "Send Message to ERP" exists. If these are not available, this means that the Goods Issued done in EWM, will stay in EWM and not communicated back to ECC.

1. Go to /n/scwm/MON
2. Get the list of Outbound Delivery Orders which have been Post Goods Issued
3. Refer to OD table /SCDL/DB_DLVI_O
4. Enter the Outbound Delivery Order number @ the REFDOCNO field. The OD document should appear in the DOCNO Field.

Tuesday, March 3, 2015

Excel Date convert from dd.mm.yy from CSV to mm-dd-yy


Excel Date convert from dd.mm.yy from CSV to mm-dd-yy


=(MID(A1,4,2)&"/"&LEFT(A1,2)&"/"&RIGHT(A1,2))



suppose in my regions it is entered as in A1 
15.11.2012 which you want to mean 15th November 2012 

such entry will not be date but only a string 
to convert in B1 (any empty cell) enter this formula 

=(MID(A1,4,2)&"/"&LEFT(A1,2)&"/"&RIGHT(A1,2))+0 
unquote 

you entered date asz 15.11.2012(15th november 2012) whereas you should have entered as 11/15/12 

having entered as 15.11.12 which is a string at least in my computer 
I have to convert to date as 15th november 2012 

so I take first mid(a1,4,2) 
take the fourth item and the lengthof 2 
fourth item is 1 and length2 menas 11 
then I add a slash "/" 
and then add left two items that is 15 and the a slash 
and then last four items that is 2013. 
so it will be 11/15/2012 
but as you used mid left etc the final result that is 11/15/12 is also a string 
something like '1234 
to make it a date i have to add a zero to the whole text 
then you get a date normally as a five figure number 

dates are always taken as a number in excel 
so you to format as date in any format 
dd-mmm-yyyyy that 15-nov-2012