SAP ABAP Table ROXAX40270 (Generated Table for View V_BUSINESS_PLACE)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ FI (Application Component) Financial Accounting
     ⤷ ID-BR-NF (Package) Brazilian Legal Reporting: Nota Fiscal

Basic Data

Table Category	INTTAB	Structure
Structure	ROXAX40270	Table Relationship Diagram
Short Description	Generated Table for View V_BUSINESS_PLACE

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
3	BRANCH	☑	J_1BBRANC_	J_1BBRANCH	CHAR	4	0	Business Place	*
4	ADDRNUMBER	☑	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
5	DATE_FROM	☑	AD_DATE_FR	DATUM	DATS	8	0	Valid-from date - in current Release only 00010101 possible
6	NATION	☑	AD_NATION	AD_NATION	CHAR	1	0	Version ID for International Addresses	TSADV
7	NAME	☐	NAME1	TEXT30	CHAR	30	0	Name
8	CGC_BRANCH	☐	J_1BCGCBRA	J_1BCGCBRA	NUMC	4	0	CNPJ Business Place
9	STATE_INSC	☐	J_1BSTAINS	J_1BSTAINS	CHAR	18	0	State Tax Number
10	MUNIC_INSC	☐	J_1BMUNINS	J_1BMUNINS	CHAR	20	0	Municipal Tax Number
11	INDUSTRY	☐	J_1BINDUS2	J_1BINDUS2	CHAR	2	0	Business Place CFOP Category
12	SINGLE	☐	J_1BSINGLE	XFELD	CHAR	1	0	Nota Fiscal Printed on Single Page
13	ADRNR	☐	ADRNR	ADRNR	CHAR	10	0	Address	*
14	NFDEC	☐	J_1BNFDEC	J_1BNFDEC	NUMC	1	0	Decimal Places in Price Inclusive of ICMS
15	NAME1	☐	AD_NAME1	TEXT40	CHAR	40	0	Name 1
16	NAME2	☐	AD_NAME2	TEXT40	CHAR	40	0	Name 2
17	NAME3	☐	AD_NAME3	TEXT40	CHAR	40	0	Name 3
18	NAME4	☐	AD_NAME4	TEXT40	CHAR	40	0	Name 4
19	NAME_TEXT	☐	AD_NAMETXT	TEXT50	CHAR	50	0	Converted name field (with form of address)
20	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
21	CITY2	☐	AD_CITY2	TEXT40	CHAR	40	0	District
22	CITY_CODE	☐	AD_CITYNUM	CITY_CODE	CHAR	12	0	City code for city/street file	ADRCITY
23	CITYP_CODE	☐	AD_CITYPNM	CITYP_CODE	CHAR	8	0	District code for City and Street file	ADRCITYPRT
24	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
25	POST_CODE2	☐	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
26	POST_CODE3	☐	AD_PSTCD3	CHAR10	CHAR	10	0	Company postal code (for large customers)
27	PO_BOX	☐	AD_POBX	CHAR10	CHAR	10	0	PO Box
28	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
29	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
30	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
31	TEL_NUMBER	☐	AD_TLNMBR1	CHAR30	CHAR	30	0	First telephone no.: dialling code+number
32	TEL_EXTENS	☐	AD_TLXTNS1	CHAR10	CHAR	10	0	First Telephone No.: Extension
33	FAX_NUMBER	☐	AD_FXNMBR1	CHAR30	CHAR	30	0	First fax no.: dialling code+number
34	FAX_EXTENS	☐	AD_FXXTNS1	CHAR10	CHAR	10	0	First fax no.: extension
35	TITLE	☐	AD_TITLE	AD_TITLE	CHAR	4	0	Form-of-Address Key	*
36	TAXJURCODE	☐	AD_TXJCD	AD_TXJCD	CHAR	15	0	Tax Jurisdiction

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROXAX40270	BUKRS	T001	BUKRS	KEY	1	CN
2	ROXAX40270	CITYP_CODE	ADRCITYPRT	CITYP_CODE		C	CN
3	ROXAX40270	CITY_CODE	ADRCITY	CITY_CODE		C	CN
4	ROXAX40270	COUNTRY	T005	LAND1		1	CN
5	ROXAX40270	MANDT	T000	MANDT	KEY	1	CN
6	ROXAX40270	NATION	TSADV	NATION	KEY	1	CN
7	ROXAX40270	REGION	T005S	BLAND		C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in