cancel
Showing results for 
Search instead for 
Did you mean: 

How can we transfer billing documents from SAP ERP to CRM 2007?

Former Member
0 Kudos

Hello,

CRM 2007/ ERP 2005

How can we transfer billing documents from SAP ERP to CRM 2007? Is there any adapter object (CRM Middleware) available? Billing documents should only be displayed in CRM.

Thanks in advance,

AEV

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi AEV,

I am having the same problem and i found this forum.i read it completely but i didnt get the solution for tranferring R/3 billing doccument to CRM. Can you please help me in this aspect.

Regards

prasad

Former Member
0 Kudos

Hi,

These all thngs can done by only Middleware. you have to maintain Middleare setting between CRM and R/3.

These are the standard settings and can be done perfectly in order to avoid wrong data replication.

Regards,

Amol Tambe

SAP CRM technical Consultant.

Former Member
0 Kudos

Hi Amol,

what is the relevant adapter object?

Is there any difference between setting up the replication of sales documents and setting up the data exchange for billing documents between ERP and CRM?

Thanks in advance.

Regards,

André

Former Member
0 Kudos

HI,

below are all objects which you need to replicate for the pro[er replication on you Sales order or service order from CRM to R/3 and R/3 to CRM.

Object Name Description

DNL_CUST_ACGRPB Accounting Group Business Partner

DNL_CUST_ACGRPP Account Group Product

DNL_CUST_ADDR Regional structure

DNL_CUST_BASIS Basis CRM online

DNL_CUST_BASIS2 Basis CRM online

DNL_CUST_BASIS3 Basis CRM online

DNL_CUST_BASIS5 Basis CRM online

DNL_CUST_BASIS6 Basis CRM online

DNL_CUST_BNKA Banking Master

DNL_CUST_KTOKD Business Partner: Acc. Group

DNL_CUST_PAYPL Payplan

DNL_CUST_PRICE Sales pricing and pricing item

DNL_CUST_PROD0 Material number conversions

DNL_CUST_PROD1 Product: categories

DNL_CUST_PROD3 Material: R/3 sales status

DNL_CUST_S_AREA Organizational Unit: Divisions

DNL_CUST_SALES Sales

DNL_CUST_SCE SCE varcond

DNL_CUST_SHIP Sales shipping

DNL_CUST_SPROD Sales product item

DNL_CUST_T502T Business Partner: T502T

DNL_CUST_TBRC Business Partner: Industries

DNL_CUST_TKUKL Business Partner: TKUKL, TKUKT

DNL_CUST_TNLS Business Partner: TNLS, TNLST

DNL_CUST_TPFK Business Partner: TPFK, TPFKT

DNL_CUST_TSAB Business Partner: TSAB, TSABT

DNL_CUST_TVAST Sales Document Blocking Reason

DNL_CUST_TVFS Sales Document Billing: Block

DNL_CUST_TVGF Business Partner: TVGF, TVGFT

DNL_CUST_TVIP Business Partner: TVIP, TVIPT

DNL_CUST_TVKN Business Partner: Attributes

DNL_CUST_TVLS Deliveries: Blocking Reasons/C

DNL_CUST_TVPV Business Partner: TVPV, TVPVT

DNL_PLANT Plant

You have to do initial download for all above Adapter objects throgh tranction R3AS.

After this you have to copy R/3 sales organisation to CRM form standard setting in CRM. path is as follows;

SPRO -> CRM -> master data -> organizational management -> data transfer -> copy ECC sales structure.

only after sucessful implementation of Middleware you can replicate your sales order or service order from CRM to R/3 or R/3 to CRM.

Regards,

Amol Tambe.

SAP CRM Technical Consultant.

If you need total step by step guide for Middle ware impemenatation tell me ur id so i will give you thata material.

Former Member
0 Kudos

Hi Amol,

thanks for your prompt answer.

It seems to me that we're talking at cross purposes here. What I really want to know is, what exactly do I have to do in order to replicate billing documents from ERP to CRM?

Do I have to use the adapter object salesdocument? We already have set up all settings that are necessary to replicate sales orders from ERP to CRM. And this kind of replication is working just fine. The next step is to transfer/ replicate billing documents from ERP to CRM.

Thanks for your help.

Regards,

AEV

Former Member
0 Kudos

Hi,

The DNL_CUST_TVFS is adapter object wihich need to be downloded for for your purpose.

just go to SMWP tranction code and check out that is this object properly downloaded or not ?

Regards,

Amol Tambe.

SAP CRM Technical Consultant

Former Member
0 Kudos

Hi Amol,

Customizing Object DNL_CUST_TVFS was replicated successfully from ECC OLTP to CRM. What are the next steps that I have to take in order to replicate billing documents?

Thanks,

AEV

ralf_rubel
Advisor
Advisor
0 Kudos

Hello AEV,

sorry, that will get you nowhere. There is no adapter object to replicate ERP billing documents to CRM Billing.

As of CRM 2007 there is a feature 'Transfer of External Billing Documents' in CRM Billing. Having this feature active you can pull billing documents from any billing system to CRM Billing for displaying AND using them in Dispute Management as references.

Regards

Ralf

Former Member
0 Kudos

Hi Ralf,

Can you please guide me where can I find this option ' Transfer of External Billing Documents' in CRM 2007 ???

Regards

Arup

ralf_rubel
Advisor
Advisor
0 Kudos

Hello Arup,

in SAP GUI:

-> start transaction BEA_CONFIG

-> select application 'CRMB',

-> accept warning about cross client customizing

-> check feature 'Transfer of External Billing Documents'

-> save settings

-> push 'Generate' button (will take some minutes)

Afterwards you will find function module /1BEA/CRMB_BD_O_CREATE_EXT

FUNCTION /1BEA/CRMB_BD_O_CREATE_EXT.

*"----


""Local Interface:

*" IMPORTING

*" REFERENCE(IT_BDH) TYPE /1BEA/T_CRMB_BDH_COMX

*" REFERENCE(IT_CONDITION_HD) TYPE BEAT_DLI_PRC_COM OPTIONAL

*" REFERENCE(IT_MARKETING_HD) TYPE BEAT_DLI_MKT_COM OPTIONAL

*" REFERENCE(IT_PARTNER_HD) TYPE BEAT_DLI_PAR_COM OPTIONAL

*" REFERENCE(IT_TEXTHEAD_HD) TYPE BEAT_DLI_TXT_HEAD_COM OPTIONAL

*" REFERENCE(IT_TEXTLINE_HD) TYPE BEAT_DLI_TXT_LINE_COM OPTIONAL

*" REFERENCE(IT_BDI) TYPE /1BEA/T_CRMB_BDI_COMX

*" REFERENCE(IT_UBBD) TYPE /1BEA/T_CRMB_UBBD_COM OPTIONAL

*" REFERENCE(IT_CONDITION_IT) TYPE BEAT_DLI_PRC_COM OPTIONAL

*" REFERENCE(IT_MARKETING_IT) TYPE BEAT_DLI_MKT_COM OPTIONAL

*" REFERENCE(IT_PARTNER_IT) TYPE BEAT_DLI_PAR_COM OPTIONAL

*" REFERENCE(IT_TEXTHEAD_IT) TYPE BEAT_DLI_TXT_HEAD_COM OPTIONAL

*" REFERENCE(IT_TEXTLINE_IT) TYPE BEAT_DLI_TXT_LINE_COM OPTIONAL

*" REFERENCE(IV_COMMIT_FLAG) TYPE BEF_COMMIT OPTIONAL

*" REFERENCE(IV_PROCESS_MODE) TYPE BEA_PROCESS_MODE DEFAULT 'B'

*" REFERENCE(IV_TAKEOVER_MODE) TYPE BEA_TAKEOVER_MODE OPTIONAL

*" EXPORTING

*" REFERENCE(ET_RETURN) TYPE BEAT_RETURN

which can be used to create billing documents, which later can be displayed in WebUI.

Regards

Ralf

Former Member
0 Kudos

Hi Ralf,

Thanks for your reply.

Sorry for responding late as we have started on the complaint part recently.

As you suggested in your reply

transaction BEA_CONFIG> select application 'CRMB'->accept warning about cross client customizing> check feature 'Transfer of External Billing Documents'> save settings --> push 'Generate' button and got function module /1BEA/CRMB_BD_O_CREATE_EXT.

But still the billing documents fron R3 are not displaying.

Do we need to have any process initiated for the referencing of Billing Document???

Can you share the steps for this???

Request your help on this.

Regards

Arup

ralf_rubel
Advisor
Advisor
0 Kudos

Hello Arup,

the CRM2007 WebUI supports

a) search & display of CRM Billing Documents

b) display of SD Documents (HTML GUI) via Document Flow of a CRM Sales/Service Order

In case you transfer/replicate your SD Documents to CRM Billing Documents you would be able to go for option a)

This transfer/replicate process is not officially supported. The mentioned function module /1BEA/CRMB_BD_O_CREATE_EXT is just an enabler to do so. It would require further custom development to establish a replication of invoices between SD and CRM. You could decide for a pull scenario (CRM reads SD Documents via BAPI and uses function module /1BEA/CRMB_BD_O_CREATE_EXT to save them as CRM Billing Documents) or for a push scenario (Select SD Billing Documents to be replicated and call RFC enabled copy of function module /1BEA/CRMB_BD_O_CREATE_EXT to save them as CRM Billing Documents). Both scenarios require mapping logic.

So you see it is not out-of-the box but it is also not impossible...

Regards

Ralf