Monthly Archives: June 2014

Attribute View Validation failed, insufficient privilege, not authorized to create view DDL statement (SAP HANA SPS6)

Issue: During the creation & activation of attribute view I received error message as below   Solution: Double click on user account “_SYS_REPO” Go to “Object Privileges” Tab Click on “+”     Search and select “SYSTEM” schema.   Assign

Posted in SAP HANA

Import Data from excel to HANA Database (SAP HANA SPS6)

Open SAP HANA Studio (Version: 1.0.68) Use Menu File and click on “Import”   Select “Data from Local File” and click “Next”   Select Target system and click Next   Fill all the required information and click Next   Map

Posted in SAP, SAP HANA

Add New System to HAHA Studio (SAP HANA SPS6)

Launch HANA Studio¬†(Version: 1.0.68) Right Click and select “Add System‚Ķ”     Add Host Name, Instance Number etc. and Click “Next”   Provide User Name and Password     Leave as default and click “Finish”   System Created Successfully

Posted in SAP, SAP HANA

Stock overview: MMBE

Use TCode: MMBE Enter Material code, Plant, Storage Location and Press <Execute>   System Will Display Stock overview as below

Posted in MM, SAP

Goods Receipts: MB1C

Use TCode MB1C Select Movement Type Select Plant   When I enter Plant code and Hit <Enter> receive warning message. Click on warning   Click on “Plant Parameters”     Click on         Copy for other plant

Posted in MM, SAP

Fld selectn for mvmt type 561 / acct 399999 differs for Ext. GA amount in LC (023)

Use TCode: SE38 to execute the Program “RM07CUFA” Enter Program name and press <Execute>   Enter Movement Type , Company Code and G/L Account and Press <Execute>   Compare the result. Click on “+” and “-” to compare the screen

Posted in MM, SAP

Create Material: MM01

Use TCode: MM01 Select Industry Sector and Material Type Click on “Select view(s)” Select Basic data 1, Purchasing, General Plant Data / Storage 1 and Accounting 1. Click on “Organizational levels”   Select Plant, Storage Location and Click on “Default

Posted in MM, SAP