SAP ABAP Table J_1BPOSCOUPONS (POS-Database Coupons (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_1BPOSCOUPONS	Table Relationship Diagram
Short Description	POS-Database Coupons (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	*
2	WERKS	☑	WERKS_D	WERKS	CHAR	4	0	Plant	*
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	BONNR	☑	POSREFNR	CHAR15	CHAR	15	0	External reference no. (GR/I slip)
7	LFDNR	☑	J_1BLFDNR	CHAR06	CHAR	6	0	Item of the coupons
8	TAXTYP	☑	J_1BTAXTYP	J_1BTAXTYP	CHAR	4	0	Tax Type	J_1BAJ
9	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
10	QUANTITY	☐	J_1BQUANTITY	MENG13	QUAN	13	3	Sales quantity
11	UNIT	☐	VRKME	MEINS	UNIT	3	0	Sales unit	*
12	REDUCTION	☐	J_1BREDUCTION	CHAR06	CHAR	6	0	Number of the reduction
13	SERIENR	☐	J_1BSERIENR	CHAR03	CHAR	3	0	Series of the Coupon
14	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
15	TAXCODE	☐	J_1BTAXCODE	CHAR005	CHAR	5	0	Tax code
16	TAXVALUE	☐	J_1BTAXVAL	J_1BTAXVAL	CURR	15	2	Tax value
17	TAXRATE	☐	J_1BTXRATE	J_1BTXRATE	DEC	6	2	Tax Rate
18	BASE	☐	J_1BBASE	J_1BBASE	CURR	15	2	Base amount
19	EXCLBASE	☐	J_1BEXCBAS	J_1BEXCBAS	CURR	15	2	Excluded base amount
20	OTHERBASE	☐	J_1BOTHBAS	J_1BOTHBAS	CURR	15	2	Other base amount
21	DOCNUM	☐	EDI_DOCNUM	EDI_DOCNUM	NUMC	16	0	IDoc number
22	MESTYP	☐	EDI_MESTYP	EDI_MESTYP	CHAR	30	0	Message Type	*
23	MBLNR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
24	MJAHR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
25	VBELN	☐	VBELN_VF	VBELN	CHAR	10	0	Billing document	*
26	NFNUM	☐	J_1BDOCNUM	J_1BDOCNUM	NUMC	10	0	Document Number	*
27	CFOP	☐	J_1BCFOP	J_1BCFOP	CHAR	10	0	CFOP code and extension	J_1BAG

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	J_1BPOSCOUPONS	CFOP	J_1BAG	CFOP
2	J_1BPOSCOUPONS	TAXTYP	J_1BAJ	TAXTYP

History

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