FI AP

[Former Member]

Hi ,

In FIAP Extraction the cubes is taking all vendors such as employees

but we need material vendors only how to get that vendors only

[Former Member · Accepted solution]

Dear Kumar,

Use a Exit Code to Delete the data that is not with Material Vendors, There is some way of indentifying the Material Vendors probably by checking it with LFM1 TABLE entries or with the help of accout grp assignment .

Hope it Helps.

Thanks,

Krish

[Former Member]

Hi ,

I have loaded

Text , Attr , Hier master data seperately .

Buyt in Bex only Text is displayed , If select Vendor ->properties it is blank or not assigned .

How to get that . But data is available ,not comming in Bex

If i select Vendor ->Properties -> Account group -> It is blank how to bring value , Only value comes i can restrict

[Former Member]

Dear Kumar,

Your values come when you try to restrict, Just check it .

Thanks,

Krish

[Former Member]

Hi KRISH ,

Can i put this code in transfer rule / Comm stru by creatng a routine ?

[Former Member]

I would actually just restrict the queries based on Account Group - thus you have normal vendors and employee expenses in the same cube

At least then you can balance to the cent/penny back to the std R3 reports and to the Balance Sheet (without having to restrict R3 reports by criteria)

(accoutants always like that sort of thing)

You will also guarantee that in four months somebody will ask you for stats based on Employee Expenses

[Former Member]

Krish ,

Tell me steps to include that in cube , Becuase it is master data how can i include that .

Can you elobrate , I think i can restrict that in Bex also .

[Former Member]

Dear Kumar,

You can include a Code in your Update Rules for that 0CREDITOR Object .

Select Single vendor from /bic/mvendor into wa_vendor where vendor = comm_structure-CREDITOR .

if wa_vendor-acctgrp = 'EMPL'.

ABORT <> 0 .

else.

Result = Comm_structure-CREDITOR.

Endif.

This will not update any records that have a Vendor with EMPL or Employees.

Or in your query take 0Creditor, Just right Click on the Creditor,You will find the attributes ...select the Acct grp in it and then restrict the acct grp with only your selected Material Vendor Acct grps.

This is much Simple.

Thanks,

krish

*Assigning points is a way of sayin thanks in SDN

[Former Member]

So what is account grouo name for material vendors

[Former Member]

Dear Kumar ,

You might have extracted the Vendor Master Data , So in that check if you have extracted the account grp , in the for Vendors who are employee's the Act Grp will me EMPL, have join with the Infocube and Infoobject and restrict the Vendors NE EMPL Acct Grp.

This should solve the problem

Thanks,

Krish

*Assigning points is way of sayin thanks in SDN

[Former Member]

hi

Account group name will be 0VENDOR under purchasing

the field name will be KTOKK

check in r/3 account group assignemnt tables

Hope this helps

Regards

N Ganesh

[Former Member]

Hi ,

When i look cubes data model Account group is in 0CREDITOR master data . It is not loaded in cube then how can i filter ? Can i do that in BEx ?

Kumar