I_CARptgDataForECSalesList

Data for EC Sales List | view: ICARDECSL | TRAN | Extraction: Not supported | Component: Contract Accounts Receivable and Payable
Tables used: DFKKREPZM
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
CADocumentNumber Number of a FI-CA Document
CASqncNumberForECSalesList Sequence Number for Entries for EC Sales List
Column Name Description
💲 Reporting Currency (CountryCurrency):
CATaxBaseAmtInCountryCrcy Tax Base Amount in National Currency
💲 Local Currency (CompanyCodeCurrency):
CATaxBaseAmtInCoCodeCrcy Tax Base Amount in Local Currency
Column Name Description
Column Name Description
ECSalesListReportingDate Date for EC Sales List
CAPostingDate Posting Date in the Document
DocumentDate Document Date in Document
CANetDueDate Due date for net payment
TaxReportingDate Tax Reporting Date
Column Name Description
CARptgDateTypeForECSalesList Reporting Date Type for EC Sales List Show values
TaxType Tax Type Show values
EUTaxClassification EU Code/Code Show values
CABusinessPartnerRefType Type of Business Partner Reference Show values
Column Name Description Domain name
TaxCode Tax on Sales/Purchases Code MWSKZ
CAReferenceDocument Reference document number XBLNR_KK
CAReversedDocumentNumber Number of Reversed Document OPBEL_KK
VATRegistration VAT Registration Number STCEG
BusinessPartnerName Name field 1 (name1/last name) BU_NAME
CABusinessPartnerRefForType Reference to a Business Partner CHAR10
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • I_CARPTGDATAFORECSALESLIST.MANDT == T001.MANDT
  • I_CARPTGDATAFORECSALESLIST.COMPANYCODE == T001.BUKRS
Local Currency
  • Client
  • Local Currency
  • I_CARPTGDATAFORECSALESLIST.MANDT == TCURC.MANDT
  • I_CARPTGDATAFORECSALESLIST.COMPANYCODECURRENCY == TCURC.WAERS
Country/Region Key
  • Client
  • Country/Region Key
  • I_CARPTGDATAFORECSALESLIST.MANDT == T005.MANDT
  • I_CARPTGDATAFORECSALESLIST.COUNTRY == T005.LAND1
Reporting Currency
  • Client
  • Reporting Currency
  • I_CARPTGDATAFORECSALESLIST.MANDT == TCURC.MANDT
  • I_CARPTGDATAFORECSALESLIST.COUNTRYCURRENCY == TCURC.WAERS
Country/Region for Tax Report
  • Client
  • Country/Region for Tax Report
  • I_CARPTGDATAFORECSALESLIST.MANDT == T005.MANDT
  • I_CARPTGDATAFORECSALESLIST.TAXRETURNCOUNTRY == T005.LAND1