Problem in PLD

[Former Member]

Hello Everyone,

    I am trying to bring BP Address in General Ledger but it is not showing me, I have tried each and every thing.. The best I did is I brought the field and data is showing but of my first BP not linking with the BP Code in my PLD, What am i missing?? I know I am missing the link ot Relation but I can't figure out how to make it linked or related..

Thanks in advance

[former_member186712 · Accepted solution]

Hi,

Naga is right. The address is in the system variable 135.

@Naga Is there any place were we can see all system variable in PLD?

Regards,

[kothandaraman_nagarajan · Accepted solution]

Hi,

Actually I got it from my existing PLD. Not sure where to get complete list.

Thanks & Regards,

Nagarajan

[Former Member · Accepted solution]

hey Naga,

So how can I insert tel phone and mob number in it??\

Regards,

Idrees

[kothandaraman_nagarajan · Accepted solution]

Hi,

Please post as new discussion from next time. As per SCN rule, one question per thread.

Anyway,

Phone number---117

Mobile number--->Don't have in my existing PLD.

Thanks & Regards,

Nagarajan

[Former Member · Accepted solution]

Hey Naga,

   So can you ask to someone in your links that how can they figure that out... If possible..

Regards,

Idrees

[kothandaraman_nagarajan · Accepted solution]

Hi,

Ok sure....My suggestion is, add fax number (118) instead of mobile number. Since this report represents at company level not by individual person.

Have you added above fields?

Thanks & Regards,

Nagarajan

[Former Member · Accepted solution]

Hey Naga,

   Yes it works but I want mobile number and Email..

Regards,

Idrees

[KennedyT21 · Accepted solution]

Hi Idrees Mohasin , Naga & Augusto Silva

You can download the system variables using the below path need S user Id

https://websmp109.sap-ag.de/~sapidb/011000358700000449672010E/HowTo_PLD_Variables_88.zip

Hope helpful to all

Regards

Kennedy

[Former Member · Accepted solution]

Hey Kennedy,

Thanks for help but when I filter it I can't find LDG1 which is a Layout ID of General ledger. Is this file is meant for only these documents that are enlisted in it. As according to the .pdf file I have to follow some steps but I can't find the Type Code LDG1 in the .xls file..

And I find 1350 as BP Street where as I inserted 135 for BP Address and is showing me fine in General Ledger PLD.

Can you please elaborate a bit that how can I map the variables of PLD in it?? Is there any technique to do so??

Regards,

Idrees

[kothandaraman_nagarajan · Accepted solution]

Hi,

Please check with SAP notes specially for General ledger.

867048
- List of variables for designing the General Ledger layout

In that, there is no variable for mobile and email.

Thanks & Regards,

Nagarajan

[Former Member · Accepted solution]

Hey Naga,

Question still remains how they find that variables are to be included in General Ledger..Is there any way to know that??

Regards,

Idrees

[kothandaraman_nagarajan · Accepted solution]

Hi,

You can find system variable by placing cursor on the field. For example, if want know item code  and its variable, just select system information under View.

Hope helpful.

Thanks & Regards,

Nagarajan

[Former Member · Accepted solution]

Hi Idrees,

There are limited entries for system variables. If you cannot find them, chances are: they are not exist.

Thanks,

Gordon

[Former Member · Accepted solution]

Dear Idrees,

First, in General Ledger report, add the desired field by "Form Setting" and then, place the cursor on it to find the variable code on message space, at below of application window.

If you can't find your desired field on "Form Setting", you can go in PLD and (1) add a Database field in your layout and (2) find the related table in the content tab and choose it. (3) Then choose desired filed on . (4) finaly relate the field to related field in layout (like joining tables in query).

for your issue, you need add desired filed from OCRD table (Business partners table) and related it to BP code field in layout.

Please close issue if the answers are helpful.

Regards,

Kayvan

[kothandaraman_nagarajan]

Hi,

Your question (BP address) already answered in my first reply. Mr. Gordon answered for all other question which was raised by you ( Mobile number, phone number etc...).

As per forum rule, one question per discussion.

Thanks & Regards,

Nagarajan

[kothandaraman_nagarajan]

Hi,

If you got answer, please close this thread by marking correct/helpful answers.

Thanks & Regards,

Nagarajan

[kothandaraman_nagarajan]

Hi,

Possible to add BP address in General ledger PLD.

Use system variable 135 to get BP address.

Hope helpful.

Thanks & Regards,

Nagarajan

[Former Member]

hey Naga,

  Thanks but how can you figure it out can you please tell me tip of it with screenshot??

Regards,

Idrees

[kothandaraman_nagarajan]

Hi,

Please refer below screen shot:

1. Edit----> General ledger PLD

2. Create new field by using system variable

3. Enter 135 in system variable field

Hope you understand.

Thanks & Regards,

Nagarajan

[Former Member]

Hey Naga,

I know how to put it but I want to ask that How can you come to know that address has the system Variable =135..Is there any way to track that as I want telephone no and mobile number as well.

Regards,

Idrees

[former_member186712]

Hi,

I'm sorry to tell you that you can't insert the customer address in the General Ledger PLD. I was trying to do the same but I was not able to do it.

The solution is to create a report in Crystal Reports.

Regards,