SAP ABAP Table ROXAX40275 (Generated Table for View V_NFCPD)

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	ROXAX40275	Table Relationship Diagram
Short Description	Generated Table for View V_NFCPD

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	PSTDAT	☑	J_1BPSTDAT	DATUM	DATS	8	0	Posting date
3	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
4	BRANCH	☑	J_1BBRANC_	J_1BBRANCH	CHAR	4	0	Business Place	J_1BBRANCH
5	DOCNUM	☑	J_1BDOCNUM	J_1BDOCNUM	NUMC	10	0	Document Number	J_1BNFDOC
6	PARVW	☑	J_1BPARVW	J_1BPARVW	CHAR	2	0	Nota Fiscal Partner Function	J_1BAD
7	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
8	NAME2	☐	NAME2_GP	NAME	CHAR	35	0	Name 2
9	NAME3	☐	NAME3_GP	NAME	CHAR	35	0	Name 3
10	NAME4	☐	NAME4_GP	NAME	CHAR	35	0	Name 4
11	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
12	ORT01	☐	ORT01_GP	TEXT35	CHAR	35	0	City
13	LAND1	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	T005
14	STRAS	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
15	PFACH	☐	PFACH	PFACH	CHAR	10	0	PO Box
16	PSTL2	☐	PSTL2	PSTLZ	CHAR	10	0	P.O. Box Postal Code
17	PSKTO	☐	PSKTO	PSKTO	CHAR	16	0	Account Number of Bank Account At Post Office
18	BANKN	☐	BANKN	BANKN	CHAR	18	0	Bank account number
19	BANKL	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
20	BANKS	☐	BANKS	LAND1	CHAR	3	0	Bank country key	T005
21	STCD1	☐	STCD1	STCD1	CHAR	16	0	Tax Number 1
22	STCD2	☐	STCD2	STCD2	CHAR	11	0	Tax Number 2
23	STKZU	☐	STKZU	XFELD	CHAR	1	0	Liable for VAT
24	STKZA	☐	STKZA	STKZA	CHAR	1	0	Indicator: Business Partner Subject to Equalization Tax?
25	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
26	BKONT	☐	BKONT	BKONT	CHAR	2	0	Bank Control Key
27	DTAWS	☐	DTAWS	DTAWS	CHAR	2	0	Instruction key for data medium exchange	T015W
28	DTAMS	☐	DTAMS	DTAMS	CHAR	1	0	Report key for data medium exchange
29	XCPDK	☐	XCPDK	XFELD	CHAR	1	0	Indicator: Is the account a one-time account?
30	EMPFG	☐	EMPFG	EMPFG	CHAR	16	0	Payee code
31	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
32	STKZN	☐	STKZN	STKZN	CHAR	1	0	Natural Person
33	J_1BSTAINS	☐	J_1BSTAINS	J_1BSTAINS	CHAR	18	0	State Tax Number
34	J_1BMUNINS	☐	J_1BMUNINS	J_1BMUNINS	CHAR	20	0	Municipal Tax Number

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROXAX40275	BANKS	T005	LAND1	KEY	1	CN
2	ROXAX40275	BRANCH	J_1BBRANCH	BRANCH	KEY	1	CN
3	ROXAX40275	BUKRS	T001	BUKRS	KEY	1	CN
4	ROXAX40275	DOCNUM	J_1BNFDOC	DOCNUM	KEY	1	CN
5	ROXAX40275	DTAWS	T015W	DTAWS
6	ROXAX40275	LAND1	T005	LAND1	KEY	1	CN
7	ROXAX40275	MANDT	T000	MANDT	KEY	1	CN
8	ROXAX40275	PARVW	J_1BAD	PARVW	KEY	1	CN
9	ROXAX40275	REGIO	T005S	BLAND	KEY	1	CN
10	ROXAX40275	SPRAS	T002	SPRAS	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in