SAP Table J_1BPOSCOUPONS
POS-Database Coupons (Brazilian)
The table J_1BPOSCOUPONS (POS-Database Coupons (Brazilian)) is a standard table in SAP ERP.
It belongs to the package J1BA.
Technical Information
Table |
J_1BPOSCOUPONS |
Short Text |
POS-Database Coupons (Brazilian) |
Package |
J1BA
|
Table Type |
Transparent Table
|
Fields for Table J_1BPOSCOUPONS
Field Name |
Key |
Description |
Data Element |
Type |
Length |
Check Table |
MANDT |
✔ |
Client |
MANDT |
CLNT |
3 |
* |
WERKS |
✔ |
Plant |
WERKS_D |
CHAR |
4 |
* |
BUDAT |
✔ |
Date on which transaction occurred at POS system |
POSVORGDAT |
DATS |
8 |
|
KSKRS |
✔ |
POS sub-network (controller) |
POSKREIS |
CHAR |
5 |
|
KASNR |
✔ |
POS ID |
POSKASSID |
CHAR |
25 |
|
BONNR |
✔ |
External reference no. (GR/I slip) |
POSREFNR |
CHAR |
15 |
|
LFDNR |
✔ |
Item of the coupons |
J_1BLFDNR |
CHAR |
6 |
|
TAXTYP |
✔ |
Tax Type |
J_1BTAXTYP |
CHAR |
4 |
J_1BAJ |
MATNR |
|
Material Number |
MATNR |
CHAR |
18 |
* |
QUANTITY |
|
Sales quantity |
J_1BQUANTITY |
QUAN |
13 |
|
UNIT |
|
Sales unit |
VRKME |
UNIT |
3 |
* |
REDUCTION |
|
Number of the reduction |
J_1BREDUCTION |
CHAR |
6 |
|
SERIENR |
|
Series of the Coupon |
J_1BSERIENR |
CHAR |
3 |
|
CURRENCY |
|
Currency Key |
WAERS |
CUKY |
5 |
* |
TAXCODE |
|
Tax code |
J_1BTAXCODE |
CHAR |
5 |
|
TAXVALUE |
|
Tax value |
J_1BTAXVAL |
CURR |
15 |
|
TAXRATE |
|
Tax Rate |
J_1BTXRATE |
DEC |
6 |
|
BASE |
|
Base amount |
J_1BBASE |
CURR |
15 |
|
EXCLBASE |
|
Excluded base amount |
J_1BEXCBAS |
CURR |
15 |
|
OTHERBASE |
|
Other base amount |
J_1BOTHBAS |
CURR |
15 |
|
DOCNUM |
|
IDoc number |
EDI_DOCNUM |
NUMC |
16 |
|
MESTYP |
|
Message Type |
EDI_MESTYP |
CHAR |
30 |
* |
MBLNR |
|
Number of Material Document |
MBLNR |
CHAR |
10 |
|
MJAHR |
|
Material Document Year |
MJAHR |
NUMC |
4 |
|
VBELN |
|
Billing Document |
VBELN_VF |
CHAR |
10 |
* |
NFNUM |
|
Document Number |
J_1BDOCNUM |
NUMC |
10 |
* |
CFOP |
|
CFOP Code and Extension |
J_1BCFOP |
CHAR |
10 |
J_1BAG |