SAP Table J_1BPOSCOUPONS
POS-Database Coupons (Brazilian)
Recommended Now
All-new Echo Dot Smart speaker with Alexa
This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.
Check it out on amazon.com →
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 |