P_BE_DomesticSalesListFica

Domestic Sales List FICA view for BE | view: PBEDOMSLSFICA | Extraction: Not supported | Component: Financials Belgium
Tables used: BKPF, DFKKOP, DFKKOPK, DFKKKO, BUT000, DFKKBPTAXNUM, TFK001, TFK001T, T001, TKA02, T005, T007A, T007B, FINSC_FISC_DATE
Column Name Description
CompanyCode Company Code
FiscalYear Fiscal Year
CADocumentNumber Number of a FI-CA Document
TaxItem Number of Tax Line Item
Column Name Description
💲 Currency Key (DocumentCurrency):
TaxBaseAmountInCoCodeCrcy Amount Subject to Tax in Local Currency (Tax Base Amount)
TaxAmountInCoCodeCrcy Amount In Local Currency With +/- Signs
TaxBaseAmountInCountryCrcy Amount Subject to Tax in Local Currency (Tax Base Amount)
TaxAmountInCountryCrcy Amount Subject to Tax in Local Currency (Tax Base Amount)
TaxAmount Tax Amount in Transaction Currency with +/- Sign
TaxBaseAmountInTransCrcy Amount Subject to Tax in Transaction Currency (Tax Base Amt)
Column Name Description
Column Name Description
DocumentDate Journal Entry Date
PostingDate Posting Date in the Document
TaxReportingDate Tax Reporting Date
ReportingDate Posting Date in the Document
Column Name Description
TransactionTypeDetermination Transaction key for account determination Show values
TaxType Tax Type Show values
EUTaxClassification EU Code/Code Show values
IsOneTimeAccount Indicator: Is the account a one-time account? Show values
stgrp Tax type Show values
stazf Indicator: Tax not deductible Show values
Column Name Description Domain name
AccountingDocument Journal Entry BELNR
TaxCode Tax on Sales/Purchases Code MWSKZ
AccountingDocumentType Document Type BLART_KK
FiscalPeriod Fiscal Period POPER
Debtor Customer KUNNR
Creditor Supplier LIFNR
OrganizationBPName1 Name 1 of organization BU_NAME
OrganizationBPName2 Name 2 of organization BU_NAME
VATRegistration VAT Registration Number STCEG
TaxNumber2 Business Partner Tax Number BPTAXNUM
VATRegistrationFromLineItem Business Partner Tax Number BPTAXNUM
VATRegistrationLineItemCountry null
VATRegistrationCountry null
BusinessPartner Business Partner Number BU_PARTNER
Master Data Relations Join Conditions
Country/Region Key
  • Client
  • Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • P_BE_DOMESTICSALESLISTFICA.MANDT == T005.MANDT
  • P_BE_DOMESTICSALESLISTFICA.COUNTRY == T005.LAND1
  • P_BE_DOMESTICSALESLISTFICA.TAXRETURNCOUNTRY == T005.LAND1
  • P_BE_DOMESTICSALESLISTFICA.COMPANYCODECOUNTRY == T005.LAND1
  • P_BE_DOMESTICSALESLISTFICA.TAXCOUNTRY == T005.LAND1
Currency Key
  • Client
  • Currency Key
  • Currency Key
  • Reporting Currency
  • P_BE_DOMESTICSALESLISTFICA.MANDT == TCURC.MANDT
  • P_BE_DOMESTICSALESLISTFICA.COMPANYCODECURRENCY == TCURC.WAERS
  • P_BE_DOMESTICSALESLISTFICA.DOCUMENTCURRENCY == TCURC.WAERS
  • P_BE_DOMESTICSALESLISTFICA.COUNTRYCURRENCY == TCURC.WAERS
Country/Region Key
  • Client
  • Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • P_BE_DOMESTICSALESLISTFICA.MANDT == T005.MANDT
  • P_BE_DOMESTICSALESLISTFICA.COUNTRY == T005.LAND1
  • P_BE_DOMESTICSALESLISTFICA.TAXRETURNCOUNTRY == T005.LAND1
  • P_BE_DOMESTICSALESLISTFICA.COMPANYCODECOUNTRY == T005.LAND1
  • P_BE_DOMESTICSALESLISTFICA.TAXCOUNTRY == T005.LAND1
Reporting Currency
  • Client
  • Currency Key
  • Currency Key
  • Reporting Currency
  • P_BE_DOMESTICSALESLISTFICA.MANDT == TCURC.MANDT
  • P_BE_DOMESTICSALESLISTFICA.COMPANYCODECURRENCY == TCURC.WAERS
  • P_BE_DOMESTICSALESLISTFICA.DOCUMENTCURRENCY == TCURC.WAERS
  • P_BE_DOMESTICSALESLISTFICA.COUNTRYCURRENCY == TCURC.WAERS
Currency Key
  • Client
  • Currency Key
  • Currency Key
  • Reporting Currency
  • P_BE_DOMESTICSALESLISTFICA.MANDT == TCURC.MANDT
  • P_BE_DOMESTICSALESLISTFICA.COMPANYCODECURRENCY == TCURC.WAERS
  • P_BE_DOMESTICSALESLISTFICA.DOCUMENTCURRENCY == TCURC.WAERS
  • P_BE_DOMESTICSALESLISTFICA.COUNTRYCURRENCY == TCURC.WAERS
Value Help for Target Tax Code
  • Client
  • ?
  • Target Tax Code for Deferred EU Acquisition Tax, Output Tax
  • P_BE_DOMESTICSALESLISTFICA.MANDT == T007A.MANDT
  • P_BE_DOMESTICSALESLISTFICA.[column in domain "KALSM_D"] == T007A.KALSM
  • P_BE_DOMESTICSALESLISTFICA.EUACQNINPUTTAXCODE == T007A.MWSKZ
Foreign Key Tax Code
  • Client
  • Target Tax Code for Deferred EU Acquisition Tax, Input Tax
  • ?
  • P_BE_DOMESTICSALESLISTFICA.MANDT == T007A.MANDT
  • P_BE_DOMESTICSALESLISTFICA.EUACQNOUTPUTTAXCODE == T007A.MWSKZ
  • P_BE_DOMESTICSALESLISTFICA.[column in domain "KALSM_D"] == T007A.KALSM
Tax Code
  • Target Tax Code (for Deferred Tax)
  • Client
  • ?
  • P_BE_DOMESTICSALESLISTFICA.TARGETTAXCODE == T007A.MWSKZ
  • P_BE_DOMESTICSALESLISTFICA.MANDT == T007A.MANDT
  • P_BE_DOMESTICSALESLISTFICA.[column in domain "KALSM_D"] == T007A.KALSM
Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Client
  • ?
  • ?
  • P_BE_DOMESTICSALESLISTFICA.TAXCALCULATIONPROCEDURE == T683.KALSM
  • P_BE_DOMESTICSALESLISTFICA.MANDT == T683.MANDT
  • P_BE_DOMESTICSALESLISTFICA.[column in domain "KVEWE"] == T683.KVEWE
  • P_BE_DOMESTICSALESLISTFICA.[column in domain "KAPPL"] == T683.KAPPL
Country/Region Key
  • Client
  • Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • P_BE_DOMESTICSALESLISTFICA.MANDT == T005.MANDT
  • P_BE_DOMESTICSALESLISTFICA.COUNTRY == T005.LAND1
  • P_BE_DOMESTICSALESLISTFICA.TAXRETURNCOUNTRY == T005.LAND1
  • P_BE_DOMESTICSALESLISTFICA.COMPANYCODECOUNTRY == T005.LAND1
  • P_BE_DOMESTICSALESLISTFICA.TAXCOUNTRY == T005.LAND1
Country/Region Key
  • Client
  • Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • P_BE_DOMESTICSALESLISTFICA.MANDT == T005.MANDT
  • P_BE_DOMESTICSALESLISTFICA.COUNTRY == T005.LAND1
  • P_BE_DOMESTICSALESLISTFICA.TAXRETURNCOUNTRY == T005.LAND1
  • P_BE_DOMESTICSALESLISTFICA.COMPANYCODECOUNTRY == T005.LAND1
  • P_BE_DOMESTICSALESLISTFICA.TAXCOUNTRY == T005.LAND1