J_1BPOSCOUPONS

POS-Database Coupons (Brazilian) | #transactional | Component: Logistics Brazil
Column Name Description
MANDT Client
WERKS Plant
BUDAT Date on which transaction occurred at POS system
KSKRS POS Subnetwork (Controller)
KASNR POS ID
BONNR External reference no. (GR/I slip)
LFDNR Item of the coupons
TAXTYP FK Tax Type
Column Name Description
💲 Currency Key (CURRENCY):
TAXVALUE Tax value
BASE Base amount
EXCLBASE Excluded base amount
OTHERBASE Other base amount
Column Name Description
📏 Sales unit (UNIT):
QUANTITY Sales quantity
Column Name Description
BUDAT Date on which transaction occurred at POS system
Column Name Description
Column Name Description Domain name
MATNR Material Number MATNR
REDUCTION Number of the reduction CHAR06
SERIENR Series of the Coupon CHAR03
TAXCODE Tax code CHAR005
TAXRATE Tax Rate J_1BTXRATE
DOCNUM IDoc number EDI_DOCNUM
MESTYP Message Type EDI_MESTYP
MBLNR Number of Material Document BELNR
MJAHR Material Document Year GJAHR
VBELN Billing Document VBELN
NFNUM Document Number J_1BDOCNUM
Master Data Relations Join Conditions
CFOP Code and Extension
  • CFOP Code and Extension
  • Client
  • J_1BPOSCOUPONS.CFOP == J_1BAG.CFOP
  • J_1BPOSCOUPONS.MANDT == J_1BAG.MANDT
Tax Type
  • Tax Type
  • Client
  • J_1BPOSCOUPONS.TAXTYP == J_1BAJ.TAXTYP
  • J_1BPOSCOUPONS.MANDT == J_1BAJ.MANDT