J_1BPOSREDUCTION

POS-Database Reduction (Brazilian) | #transactional | Component: Logistics Brazil
Column Name Description
MANDT FK Client
WERKS FK Plant
BUDAT Date on which transaction occurred at POS system
KSKRS POS Subnetwork (Controller)
KASNR POS ID
Column Name Description
💲 Currency Key (CURRENCY):
AMOUNTBEG Accumulated Amount of POS at the Start of the Day
AMOUNTEND Accumulated Amount of POS at the End of the Day
TAXVALUE Tax value
BASE Base amount
EXCLBASE Excluded base amount
OTHERBASE Other base amount
Column Name Description
Column Name Description
BUDAT Date on which transaction occurred at POS system
Column Name Description
Column Name Description Domain name
SERIALNR Serial number of POS CHAR15
COUNTBEG Number of counter of POS in the beginning of the day NUMC06
COUNTEND Number of counter of POS at the end of the day NUMC06
NRCOUPON Number of coupon of reduction Z NUMC6
SERIENR Series of the Coupon CHAR03
CANCELS Cancels NUMC16
DISCOUNTS Discounts NUMC16
TAXCODE Tax code CHAR005
MAPNUMBER Number of MAP of POS CHAR06
DOCNUM IDoc number EDI_DOCNUM
MESTYP Message Type EDI_MESTYP
NFNUM Document Number J_1BDOCNUM
Master Data Relations Join Conditions
Client J_1BPOSREDUCTION.MANDT == T000.MANDT
Nota Fiscal Type
  • Nota Fiscal Type
  • Client
  • J_1BPOSREDUCTION.NFTYPE == J_1BAA.NFTYPE
  • J_1BPOSREDUCTION.MANDT == J_1BAA.MANDT
Tax Type
  • Tax Type
  • Client
  • J_1BPOSREDUCTION.TAXTYP == J_1BAJ.TAXTYP
  • J_1BPOSREDUCTION.MANDT == J_1BAJ.MANDT
Plant
  • J_1BPOSREDUCTION.MANDT == T001W.MANDT
  • J_1BPOSREDUCTION.WERKS == T001W.WERKS