Skip to Content

SXDA+LSMW from heaven to hell

Hi folks,

I'm creating BP via SXDA+LSMW and until I needed to create various segments of the same type from one single row of a file I thought this combinations is really cool, but now is a completly pain. So I'm open to hear your opinions, any help will be very welcome 😊

I have a plane file with 2 telephones and what I understood (Note 634300 - XIF: Loading Multiple Text Lines From LSMW) is that you need to split this in items, for example:

Header: BP 1|

Item: BP 1 | Phone 1|

item: BP 1 | Phone 2|

Before, I tryied a lot of things in the END_OF_RECORD but the system doesn't save the PSGNUM so when the SAVE is performed only stores one telephone. DoI really need to create a custom program to change the file from a plane file to a hierarchical file? I can't belive it 😔

But I have a better scenario, the same process but instead adding phones from a file, you want assign the same two phone numbers to all the BPs via constants.

I really don't want to create custom programs for this, but I SXDA+LSWM is starting to be a pain!!

Cheers!

Luis

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Apr 10, 2013 at 02:53 PM

    Hi,

    Regarding the phones, the idoc structure is:

    E102BUS_EI_TEL_DATA - Min Segments 1 / Max Segments 1

    E102S_EI_BUPA_TELEPHONE_CON - Min Segments 1 / Max Segments 999999

    E102BUS_EI_STRUC_TEL_DATA - Min Segments 1 / Max Segments 1

    What I did is a transfer_record at the END_OF_RECORD event for each segment, so the system saved something like:

    E102BUS_EI_TEL_DATA

    E102S_EI_BUPA_TELEPHONE_CON

    E102S_EI_BUPA_TELEPHONE_CON

    E102BUS_EI_STRUC_TEL_DATA

    E102BUS_EI_STRUC_TEL_DATA

    But the right order is:

    E102BUS_EI_TEL_DATA

    E102S_EI_BUPA_TELEPHONE_CON

    E102BUS_EI_STRUC_TEL_DATA

    E102S_EI_BUPA_TELEPHONE_CON

    E102BUS_EI_STRUC_TEL_DATA

    I tried to map the right PSGNUM but looks like it doesn't take it into account, so the physcal order is more important than the logical order.

    I imagine If I put all the code in the event END_OF_RECORD of the segment E102S_EI_BUPA_TELEPHONE_CON will work, I said I imagine, because I didn't tried, I prefer to do what the note said, it's a little of excel work but at least the mapping is more clean.

    But in other hand I also needed to add marketing attributes, and this is more easy/clean to do it in the END_OF_RECORD event. First I enhanced the BP interface according to the notes:

    609236 - Import of Business Partner Marketing Attributes

    1081545 - Extending note 609236 for CRM version above 4.0

    1239018 - XIF:errors not captured in FM ZCRM_MKTBP_CRMOU_WRITE

    569723 - Export of Business Partner Marketing Attributes

    947715 - Problems after implementing note 569723

    1710612 - Attribute set could not be saved

    1791266 - Upload of marketing attribute in LSMW create inconsistencies

    Z101ZCRM_MKTBP_PROFILE - Min Segments 1 / Max Segments 1

    Z101MKTPFCHR_ATTRIBUTE_LINE - Min Segments 1 / Max Segments 999999

    I mapped via normal mapping COL1 to the segment Z101MKTPFCHR_ATTRIBUTE_LINE and I put some code on the END_OF_RECORD (all atributes belong to the same set)

    transfer_record.

    Z101MKTPFCHR_ATTRIBUTE_LINE-ATNAME = 'XXXXXXXX'.

    Z101MKTPFCHR_ATTRIBUTE_LINE-ATVALUE = FILE-COL2.

    transfer_record.

    Z101MKTPFCHR_ATTRIBUTE_LINE-ATNAME = 'YYYYYYY'.

    Z101MKTPFCHR_ATTRIBUTE_LINE-ATVALUE = FILE-COL3.

    transfer_record.

    I hope this post/miniblog save you some troubles!

    Luis

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.