P_BE_DomesticSalesList10

Domestic Sales List for Belgium (Helper) | view: PBEDOMSLSLST10 | Extraction: Not supported | Component: Financials Belgium
Tables used: BKPFBSECBKPFBSEGBSETBUT000T001TKA02T005KNA1CVI_CUST_LINKLFA1CVI_VEND_LINKT007AT001T014T007B
Column Name Description
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Document Number of an Accounting Document
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
TransactionTypeDetermination Transaction Key CHAR3
TaxReturnCountry Country/Region for Tax Report LAND1
TaxCountry Tax Reporting Country/Region LAND1
BusinessPartnerUUID null
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
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • P_BE_DOMESTICSALESLIST10.MANDT == T001.MANDT
  • P_BE_DOMESTICSALESLIST10.COMPANYCODE == T001.BUKRS
Country/Region Key
  • Client
  • Country/Region Key
  • P_BE_DOMESTICSALESLIST10.MANDT == T005.MANDT
  • P_BE_DOMESTICSALESLIST10.COMPANYCODECOUNTRY == T005.LAND1
Supplier
  • Supplier
  • Client
  • P_BE_DOMESTICSALESLIST10.CREDITOR == LFA1.LIFNR
  • P_BE_DOMESTICSALESLIST10.MANDT == LFA1.MANDT
Customer
  • Client
  • Customer
  • P_BE_DOMESTICSALESLIST10.MANDT == KNA1.MANDT
  • P_BE_DOMESTICSALESLIST10.DEBTOR == KNA1.KUNNR
Tax on sales/purchases code
  • Client
  • Tax on sales/purchases code
  • ?
  • P_BE_DOMESTICSALESLIST10.MANDT == T007A.MANDT
  • P_BE_DOMESTICSALESLIST10.TAXCODE == T007A.MWSKZ
  • P_BE_DOMESTICSALESLIST10.[column in domain "KALSM_D"] == T007A.KALSM