SNVOICE

Invoice | #transactional | Component: Training and Demo
Column Name Description
MANDT FK Client
CARRID FK Airline Code
CONNID FK Flight Connection Number
FLDATE FK Flight date
BOOKID Booking number
CUSTOMID FK Customer Number
INSTNO (Partial) invoice number
Column Name Description
💲 Local currency of airline (CURRENCY):
AMOUNT Price of booking in local currency of airline
Column Name Description
Column Name Description
FLDATE FK Flight date
Column Name Description
Column Name Description Domain name
PAYMETH Payment method CHAR1
ARCHIVE_ Internal SAP use NUMC4
Master Data Relations Join Conditions
Check Against Airline
  • Client
  • Airline Code
  • SNVOICE.MANDT == SCARR.MANDT
  • SNVOICE.CARRID == SCARR.CARRID
Check Against Flight Connection
  • Flight Connection Number
  • Airline Code
  • Client
  • SNVOICE.CONNID == SPFLI.CONNID
  • SNVOICE.CARRID == SPFLI.CARRID
  • SNVOICE.MANDT == SPFLI.MANDT
Check against customer table
  • Customer Number
  • Client
Client SNVOICE.MANDT == T000.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Check Currency SNVOICE.CURRENCY == SCURX.CURRKEY