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 |