0ID_BUSINESS_PLACE_ATTR

Business Place | #ATTR | Extraction method: V | No Delta | Component: Master Data for Brazil
Tables used: J_1BBRANCH → show details
Column Name Description
BUKRS FK Company Code
BRANCH Business Place
ADDRNUMBER Address Number
DATE_FROM Valid-from date - in current Release only 00010101 possible
NATION FK Version ID for International Addresses
NAME Name
CGC_BRANCH CNPJ Business Place
STATE_INSC State Tax Number
MUNIC_INSC Municipal Tax Number
INDUSTRY Business Place CFOP Category Show values
SINGLE Nota Fiscal Printed on Single Page Show values
ADRNR Address
NFDEC Decimal Places in Price Inclusive of ICMS Show values
NAME1 Name 1
NAME2 Name 2
NAME3 Name 3
NAME4 Name 4
NAME_TEXT Converted name field (with form of address)
CITY1 City
CITY2 District
CITY_CODE FK City code for city/street file
CITYP_CODE FK District code for City and Street file
POST_CODE1 City postal code
POST_CODE2 PO Box Postal Code
POST_CODE3 Company Postal Code (for Large Customers)
PO_BOX PO Box
STREET Street
COUNTRY FK Country/Region Key
REGION FK Region (State, Province, County)
TEL_NUMBER First telephone no.: dialling code+number
TEL_EXTENS First Telephone No.: Extension
FAX_NUMBER First Fax No.: Area Code + Number
FAX_EXTENS First fax no.: extension
TAXJURCODE Tax Jurisdiction
Column Name Description
Column Name Description
Column Name Description
DATE_FROM Valid-from date - in current Release only 00010101 possible
Column Name Description
INDUSTRY Business Place CFOP Category Show values
SINGLE Nota Fiscal Printed on Single Page Show values
NFDEC Decimal Places in Price Inclusive of ICMS Show values
Column Name Description Domain name
TITLE Form-of-Address Key AD_TITLE
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • 0ID_BUSINESS_PLACE_ATTR.BUKRS == T001.BUKRS
  • 0ID_BUSINESS_PLACE_ATTR.MANDT == T001.MANDT
City code for city/street file
  • City code for city/street file
  • Country/Region Key
  • 0ID_BUSINESS_PLACE_ATTR.CITY_CODE == ADRCITY.CITY_CODE
  • 0ID_BUSINESS_PLACE_ATTR.COUNTRY == ADRCITY.COUNTRY
Country key 0ID_BUSINESS_PLACE_ATTR.COUNTRY == T005.LAND1
Version ID for International Addresses 0ID_BUSINESS_PLACE_ATTR.NATION == TSADV.NATION
Region code
  • Region (State, Province, County)
  • Country/Region Key
  • 0ID_BUSINESS_PLACE_ATTR.REGION == T005S.BLAND
  • 0ID_BUSINESS_PLACE_ATTR.COUNTRY == T005S.LAND1
Other Relations | to Master Data Relations ↑ Join Conditions
District code for City and Street file
  • District code for City and Street file
  • City code for city/street file
  • Country/Region Key
  • 0ID_BUSINESS_PLACE_ATTR.CITYP_CODE == ADRCITYPRT.CITYP_CODE
  • 0ID_BUSINESS_PLACE_ATTR.CITY_CODE == ADRCITYPRT.CITY_CODE
  • 0ID_BUSINESS_PLACE_ATTR.COUNTRY == ADRCITYPRT.COUNTRY