Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Query regarding Business Partner Address in SAP B1?

Hi Friends,

WHile i extract SAP datas for my ETL Product,I found some issues..Hereby i m telling the steps to reproduce that in Demo database of OEC Computers..

1.Open SAP B1 Business Partner data

2.Open C40001 Business partner data..

3.Open Addresses tab of that Business partner

4.Click Bill to Address..And u can c no datas is present for that BP 'C40001'.

5.And Open OCRD in Sql Server.. And u can c Address as '208 Hollywood Av'and ZipCode as '28989'.And it's present in XML of that Business Partner data but not shown in UI in Address tab..

6.Where these datas are present in Business Partner UI..How can i view those in UI?

Please give me a clear information for that..

Thanks in Advance



Former Member
Former Member replied


There are a total of 14 companies with this problem in the OEC Computer demo database:

C23900 Parametechnology

C30009 Microchips

C40001 Earthshaker Corp.

C40002 Bees Computers

C40003 Stone

C40005 Mashina Corp.

C50003 ADA Technologies

V1010 Far East Imports

V1011 HB

V20000 Lasercom

V29304 Binat Tech.

V3890 Blockies Corp

V4894 Lumarx

V80090 SMD technologies

All the addresses in CRD1 had type 'S' so there are no billing addresses at all. It seems like someone (accidentally or for some some kinky reason) ran a query such as "update crd1 set adrestype='S'" on it.


0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question