P_CAStRpECSalesListEntry

FI-CA reporting data for EC Sales List | view: PCASRECSLENTRY | Extraction: Not supported | Component: Contract Accounts Reporting
Tables used: DFKKKODFKKREPZMBUT000TFK001TFK001TT001TKA02
Column Name Description
CompanyCode FK Company Code
CARptgDateTypeForECSalesList Reporting Date Type for EC Sales List Show values
ECSalesListReportingDate Date for EC Sales List
BusinessPartner Business Partner Number
CADocument Document Number in Contract Accounting
CASqncNumberForECSalesList Sequence Number for Entries for EC Sales List
Column Name Description
💲 Reporting Currency (ReportingCurrency):
AmountInReportingCurrency Amount in Reporting Currency
💲 Company Code Currency (CompanyCodeCurrency):
TaxBaseAmountInCoCodeCrcy Tax Base Amount in Local Currency
💲 Reporting Currency (CountryCurrency):
TaxBaseAmountInCountryCrcy Tax Base Amount in Country/Region Currency
💲 Currency Key (DocumentCurrency):
TaxBaseAmountInTransCrcy Tax Base Amount in Document Currency
Column Name Description
Column Name Description
ECSalesListReportingDate Date for EC Sales List
ReportingDate Reporting Date
PostingDate Posting Date
DocumentDate Journal Entry Date
TaxReportingDate Tax Reporting Date
Column Name Description
CARptgDateTypeForECSalesList Reporting Date Type for EC Sales List Show values
EUTaxClassification EU Code/Code Show values
TaxType Tax Type Show values
TaxDebitCreditCode Debit/Credit Indicator Show values
IsReversal Indicator: Item is Reversing Another Item Show values
IsReversed Indicator: Item is Reversed Show values
IsOneTimeAccount Indicator: Is the account a one-time account? Show values
IsEUTriangularDeal Indicator: Triangular Deal Within the EU Show values
Column Name Description Domain name
CAReconciliationKey Reconciliation Key for General Ledger FIKEY_KK
BusinessPartnerName Business Partner Name BP_NAME_CA
TaxCode Tax on sales/purchases code MWSKZ
Debtor Customer KUNNR
CustomerName Name of Customer TEXT80
Creditor Supplier LIFNR
SupplierName Name of Supplier TEXT80
VATRegistration VAT Registration Number STCEG
TaxItemGroup Group Indicator for Tax Line Items NUM03
TaxJurisdiction Tax Jurisdiction TXJCD
DelivOfGoodsDestCountry Country/Region of Destination for Delivery of Goods LAND1
DelivOfGoodsOriginCountry Supplying Country/Region for Delivery of Goods LAND1
AccountingDocument Document Number of an Accounting Document BELNR
TransactionTypeDetermination Transaction Key CHAR3
TaxItem Number of Tax Line Item BUZEI
StatryRptCategory Report Category ID SRF_REP_CAT_ID
StatryRptRunID Report Run ID SRF_REPORT_RUN_ID
StatryRptgEntity Reporting Entity SRF_REPORTING_ENTITY
ReferenceDocumentType Reference Document Type AWTYP
Master Data Relations Join Conditions
Authorization Group
  • ?
  • Client
  • Authorization Group
  • P_CASTRPECSALESLISTENTRY.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
  • P_CASTRPECSALESLISTENTRY.MANDT == TB037.CLIENT
  • P_CASTRPECSALESLISTENTRY.AUTHORIZATIONGROUP == TB037.AUGRP
Company Code
  • Client
  • Company Code
  • P_CASTRPECSALESLISTENTRY.MANDT == T001.MANDT
  • P_CASTRPECSALESLISTENTRY.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Company Code Currency
  • Client
  • P_CASTRPECSALESLISTENTRY.COMPANYCODECURRENCY == TCURC.WAERS
  • P_CASTRPECSALESLISTENTRY.MANDT == TCURC.MANDT
Country/Region Key
  • Client
  • Country/Region Key
  • P_CASTRPECSALESLISTENTRY.MANDT == T005.MANDT
  • P_CASTRPECSALESLISTENTRY.COUNTRY == T005.LAND1
Reporting Currency
  • Client
  • Reporting Currency
  • Reporting Currency
  • P_CASTRPECSALESLISTENTRY.MANDT == TCURC.MANDT
  • P_CASTRPECSALESLISTENTRY.COUNTRYCURRENCY == TCURC.WAERS
  • P_CASTRPECSALESLISTENTRY.REPORTINGCURRENCY == TCURC.WAERS
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • P_CASTRPECSALESLISTENTRY.FISCALYEARVARIANT == T009.PERIV
  • P_CASTRPECSALESLISTENTRY.MANDT == T009.MANDT
Reporting Country/Region
  • Reporting Country/Region
  • Country/Region for Tax Report
  • Client
  • P_CASTRPECSALESLISTENTRY.REPORTINGCOUNTRY == T005.LAND1
  • P_CASTRPECSALESLISTENTRY.TAXRETURNCOUNTRY == T005.LAND1
  • P_CASTRPECSALESLISTENTRY.MANDT == T005.MANDT
Reporting Currency
  • Client
  • Reporting Currency
  • Reporting Currency
  • P_CASTRPECSALESLISTENTRY.MANDT == TCURC.MANDT
  • P_CASTRPECSALESLISTENTRY.COUNTRYCURRENCY == TCURC.WAERS
  • P_CASTRPECSALESLISTENTRY.REPORTINGCURRENCY == TCURC.WAERS
Taxes on Sales/Purchases Group
  • Client
  • Taxes on Sales/Purchases Group
  • P_CASTRPECSALESLISTENTRY.MANDT == T007F.MANDT
  • P_CASTRPECSALESLISTENTRY.TAXABLEENTITY == T007F.UMKRS
Country/Region for Tax Report
  • Reporting Country/Region
  • Country/Region for Tax Report
  • Client
  • P_CASTRPECSALESLISTENTRY.REPORTINGCOUNTRY == T005.LAND1
  • P_CASTRPECSALESLISTENTRY.TAXRETURNCOUNTRY == T005.LAND1
  • P_CASTRPECSALESLISTENTRY.MANDT == T005.MANDT