SAP ABAP Table J_1BPOSREDUCTION (POS-Database Reduction (Brazilian))

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-LOC-BR (Application Component) Brazil
     ⤷ J1BA (Package) Localization Brazil

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	J_1BPOSREDUCTION	Table Relationship Diagram
Short Description	POS-Database Reduction (Brazilian)

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	WERKS	☑	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
3	BUDAT	☑	POSVORGDAT		DATS	8	0	Date on which transaction occurred at POS system
4	KSKRS	☑	POSKREIS	CHAR5	CHAR	5	0	POS sub-network (controller)
5	KASNR	☑	POSKASSID	CHAR25	CHAR	25	0	POS ID
6	NFTYPE	☐	J_1BNFTYPE	J_1BNFTYPE	CHAR	2	0	Nota Fiscal Type	J_1BAA
7	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
8	SERIALNR	☐	J_1BSERIALNR	CHAR15	CHAR	15	0	Serial number of POS
9	COUNTBEG	☐	J_1BCOUNTBEG	NUMC06	NUMC	6	0	Number of counter of POS in the beginning of the day
10	COUNTEND	☐	J_BCOUNTEND	NUMC06	NUMC	6	0	Number of counter of POS at the end of the day
11	NRCOUPON	☐	J_1BNRCOUPON	NUMC6	NUMC	6	0	Number of coupon of reduction Z
12	SERIENR	☐	J_1BSERIENR	CHAR03	CHAR	3	0	Series of the Coupon
13	AMOUNTBEG	☐	J_1BAMOUNTBEG	J_1BBASE	CURR	15	2	Accumulated Amount of POS at the Start of the Day
14	AMOUNTEND	☐	J_1BAOUMNTEND	J_1BBASE	CURR	15	2	Accumulated Amount of POS at the End of the Day
15	CANCELS	☐	J_1BCANCELS	NUMC16	NUMC	16	0	Cancels
16	DISCOUNTS	☐	J_1BDISCOUNTS	NUMC16	NUMC	16	0	Discounts
17	TAXTYP	☐	J_1BTAXTYP	J_1BTAXTYP	CHAR	4	0	Tax Type	J_1BAJ
18	TAXCODE	☐	J_1BTAXCODE	CHAR005	CHAR	5	0	Tax code
19	TAXVALUE	☐	J_1BTAXVAL	J_1BTAXVAL	CURR	15	2	Tax value
20	BASE	☐	J_1BBASE	J_1BBASE	CURR	15	2	Base amount
21	EXCLBASE	☐	J_1BEXCBAS	J_1BEXCBAS	CURR	15	2	Excluded base amount
22	OTHERBASE	☐	J_1BOTHBAS	J_1BOTHBAS	CURR	15	2	Other base amount
23	MAPNUMBER	☐	J_1BMAPNUMBER	CHAR06	CHAR	6	0	Number of MAP of POS
24	DOCNUM	☐	EDI_DOCNUM	EDI_DOCNUM	NUMC	16	0	IDoc number
25	MESTYP	☐	EDI_MESTYP	EDI_MESTYP	CHAR	30	0	Message Type	*
26	NFNUM	☐	J_1BDOCNUM	J_1BDOCNUM	NUMC	10	0	Document Number	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	J_1BPOSREDUCTION	MANDT	T000	MANDT
2	J_1BPOSREDUCTION	NFTYPE	J_1BAA	NFTYPE
3	J_1BPOSREDUCTION	TAXTYP	J_1BAJ	TAXTYP
4	J_1BPOSREDUCTION	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20020506
SAP Release Created in	470