Query regarding Business Partner Address in SAP B1?
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
Henry Nordström replied
There are a total of 14 companies with this problem in the OEC Computer demo database:
C40001 Earthshaker Corp.
C40002 Bees Computers
C40005 Mashina Corp.
C50003 ADA Technologies
V1010 Far East Imports
V29304 Binat Tech.
V3890 Blockies Corp
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.