J_1BPOSCOUPONS - POS-Database Coupons (Brazilian)
POS-Database Coupons (Brazilian) information is stored in SAP table J_1BPOSCOUPONS.
It is part of development package J1BA in software component FI-LOC-LO-BR. This development package consists of objects that can be grouped under "Localization Brazil".
It is part of development package J1BA in software component FI-LOC-LO-BR. This development package consists of objects that can be grouped under "Localization Brazil".
Fields for table J_1BPOSCOUPONS
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | * |
| WERKS | Plant | X | WERKS_D | CHAR | 8 | * |
| BUDAT | Date on which transaction occurred at POS system | X | POSVORGDAT | DATS | 16 | |
| KSKRS | POS Subnetwork (Controller) | X | POSKREIS | CHAR | 10 | |
| KASNR | POS ID | X | POSKASSID | CHAR | 50 | |
| BONNR | External reference no. (GR/I slip) | X | POSREFNR | CHAR | 30 | |
| LFDNR | Item of the coupons | X | J_1BLFDNR | CHAR | 12 | |
| TAXTYP | Tax Type | X | J_1BTAXTYP | CHAR | 8 | J_1BAJ |
| MATNR | Material Number | MATNR | CHAR | 80 | * | |
| QUANTITY | Sales quantity | J_1BQUANTITY | QUAN | 7 | ||
| UNIT | Sales unit | VRKME | UNIT | 6 | * | |
| REDUCTION | Number of the reduction | J_1BREDUCTION | CHAR | 12 | ||
| SERIENR | Series of the Coupon | J_1BSERIENR | CHAR | 6 | ||
| CURRENCY | Currency Key | WAERS | CUKY | 10 | * | |
| TAXCODE | Tax code | J_1BTAXCODE | CHAR | 10 | ||
| TAXVALUE | Tax value | J_1BTAXVAL | CURR | 8 | ||
| TAXRATE | Tax Rate | J_1BTXRATE | DEC | 4 | ||
| BASE | Base amount | J_1BBASE | CURR | 8 | ||
| EXCLBASE | Excluded base amount | J_1BEXCBAS | CURR | 8 | ||
| OTHERBASE | Other base amount | J_1BOTHBAS | CURR | 8 | ||
| DOCNUM | IDoc number | EDI_DOCNUM | NUMC | 32 | ||
| MESTYP | Message Type | EDI_MESTYP | CHAR | 60 | * | |
| MBLNR | Number of Material Document | MBLNR | CHAR | 20 | ||
| MJAHR | Material Document Year | MJAHR | NUMC | 8 | ||
| VBELN | Billing Document | VBELN_VF | CHAR | 20 | * | |
| NFNUM | Document Number | J_1BDOCNUM | NUMC | 20 | * | |
| CFOP | CFOP Code and Extension | J_1BCFOP | CHAR | 20 | J_1BAG |