P_BE_DomesticSalesListUnion

Domestic Sales List Union for FI and FICA | view: PBEDOMSLSLSTUN | Extraction: Not supported | Component: Financials Belgium
Column Name Description
CompanyCode FK Company Code
FiscalYear Fiscal Year
CADocumentNumber Number of a FI-CA Document
AccountingDocument Journal Entry
TaxItem Number of Tax Line Item
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
TaxBaseAmountInCoCodeCrcy null
TaxAmountInCoCodeCrcy null
💲 Reporting Currency (CountryCurrency):
TaxBaseAmountInCountryCrcy null
TaxAmountInCountryCrcy null
Column Name Description
Column Name Description
PostingDate Posting Date
TaxReportingDate Tax Reporting Date
ReportingDate Reporting Date
Column Name Description
stgrp Tax type Show values
TaxType Tax Type Show values
Column Name Description Domain name
BusinessPartner Business Partner Number BU_PARTNER
TransactionTypeDetermination Transaction Key CHAR3
TaxReturnCountry Country/Region for Tax Report LAND1
TaxCountry Tax Reporting Country/Region LAND1
Country Country/Region Key LAND1
IsOneTimeAccount null
VATRegistrationFromLineItem VAT Registration Number STCEG
VATRegistration VAT Registration Number STCEG
VATRegistrationLineItemCountry null
VATRegistrationCountry null
TaxNumber2 Tax Number 2 STCD2
DOCSource null
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • P_BE_DOMESTICSALESLISTUNION.MANDT == T001.MANDT
  • P_BE_DOMESTICSALESLISTUNION.COMPANYCODE == T001.BUKRS
Country/Region Key
  • Client
  • Country/Region Key
  • P_BE_DOMESTICSALESLISTUNION.MANDT == T005.MANDT
  • P_BE_DOMESTICSALESLISTUNION.COMPANYCODECOUNTRY == T005.LAND1
Supplier
  • Client
  • Supplier
  • P_BE_DOMESTICSALESLISTUNION.MANDT == LFA1.MANDT
  • P_BE_DOMESTICSALESLISTUNION.CREDITOR == LFA1.LIFNR
Customer
  • Client
  • Customer
  • P_BE_DOMESTICSALESLISTUNION.MANDT == KNA1.MANDT
  • P_BE_DOMESTICSALESLISTUNION.DEBTOR == KNA1.KUNNR
Tax on sales/purchases code
  • Client
  • ?
  • Tax on sales/purchases code
  • P_BE_DOMESTICSALESLISTUNION.MANDT == T007A.MANDT
  • P_BE_DOMESTICSALESLISTUNION.[column in domain "KALSM_D"] == T007A.KALSM
  • P_BE_DOMESTICSALESLISTUNION.TAXCODE == T007A.MWSKZ