a month ago
Dear all,
I am facing error while add the new Business Partner master data via DTW.
Error : 1250000126 - No state found for ship-to address 'Ship To'; on the "Addresses" tab, define state information [CRD1.State]
I have attached below data for CRD1 template. I have mentioned state and also create this state into SAP as well. I am trying to add one bill to and one ship to address as per below details.
ParentKey | LineNum | AddressName | Street | Block | ZipCode | City | Country | State | FederalTaxID | TaxCode | BuildingFloorRoom | AddressType | AddressName2 | AddressName3 | TypeOfAddress | StreetNo |
CardCode | LineNum | Address | Street | Block | ZipCode | City | Country | State | LicTradNum | TaxCode | Building | AdresType | Address2 | Address3 | AddrType | StreetNo |
C221 | 0 | A22 | ABC | 15 | 390019 | Vasad | IN | GJ | B503 | bo_BillTo | 55 | |||||
C221 | 0 | A23 | ABC | 16 | 390019 | Vasad | IN | GJ | B503 | bo_ShipTo | 55 |
Kind regards,
Nikunj Mehta
Hi,
Please check if the following query gives any result:
select "DataSource","MailCountr",* from OCRD o
where "MailCountr" = 'IN' and not exists (select 1 from CRD1 where "CardCode" = o."CardCode" and "AdresType" = 'S')
Kr,
Jitin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
108 | |
12 | |
11 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.