I_CAStRpECSalesListEntry

DDL: I_CASTRPECSALESLISTENTRY SQL: ICASRECSLENTRY Type: view COMPOSITE
54 Fields 1 Data Sources 2 Associations

FI-CA reporting data for EC Sales List

I_CAStRpECSalesListEntry is a Composite CDS View that provides data about "FI-CA reporting data for EC Sales List" in SAP S/4HANA. It reads from 1 data source (P_CAStRpECSalesListEntry) and exposes 54 fields with key fields CompanyCode, CARptgDateTypeForECSalesList, ECSalesListReportingDate, BusinessPartner, CADocument. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_CAStRpECSalesListEntry FICAData from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Currency _ReportingCurrency $projection.ReportingCurrency = _ReportingCurrency.Currency
[0..*] I_OneTimeAccountBP _OneTimeAccount _OneTimeAccount.CompanyCode = $projection.CompanyCode and _OneTimeAccount.AccountingDocument = $projection.AccountingDocument and _OneTimeAccount.FiscalYear = $projection.FiscalYear

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ICASRECSLENTRY view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
Metadata.allowExtensions false view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label FI-CA reporting data for EC Sales List view

Fields (54)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_CAStRpECSalesListEntry CompanyCode Receiver Company Code
KEY CARptgDateTypeForECSalesList P_CAStRpECSalesListEntry CARptgDateTypeForECSalesList Reporting Date
KEY ECSalesListReportingDate P_CAStRpECSalesListEntry ECSalesListReportingDate Date
KEY BusinessPartner P_CAStRpECSalesListEntry BusinessPartner Issuing Authority
KEY CADocument P_CAStRpECSalesListEntry CADocument CA Document No.
KEY CASqncNumberForECSalesList P_CAStRpECSalesListEntry CASqncNumberForECSalesList Sequence Number
KEY AccountingDocument AccountingDocument Journal Entry
KEY FiscalYear FiscalCalendarDate FiscalYear G/L Fiscal Year
KEY TaxCode TaxCode Tax Code
KEY TransactionTypeDetermination TransactionTypeDetermination Transaction Key
KEY TaxItem TaxItem Tax Item
KEY StatryRptCategory ReportedItemsLog StatryRptCategory Report ID
KEY StatryRptRunID ReportedItemsLog StatryRptRunID Report Run ID
KEY StatryRptgEntity ReportedItemsLog StatryRptgEntity Reporting Entity
Debtor Debtor Debtor
CustomerName CustomerName Name of Customer
Creditor Creditor Supplier
SupplierName SupplierName Supplier Name
VATRegistration VATRegistration VAT Registration No.
IsOneTimeAccount IsOneTimeAccount One-time acct
AuthorizationGroup AuthorizationGroup AuthorizGroup
TaxItemGroup TaxItemGroup Tax doc. item number
TaxJurisdiction TaxJurisdiction Tax Jurisdiction
Country Country Venue: Ctry/Reg
AmountInReportingCurrency AmountInReportingCurrency
ReportingCurrency ReportingCurrency Currency
ReportingCountry ReportingCountry
TaxReturnCountry TaxReturnCountry Reporting C/R
ReportingDate ReportingDate
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy TxBaseAmt CoCodeCrcy
CompanyCodeCurrency CompanyCodeCurrency Local Currency
TaxBaseAmountInTransCrcy TaxBaseAmountInTransCrcy Value-Added Tax
DocumentCurrency DocumentCurrency Document Currency
TaxBaseAmountInCountryCrcy TaxBaseAmountInCountryCrcy Base Amount
CountryCurrency CountryCurrency Currency
IsReversal IsReversal Reversal doc.
IsReversed IsReversed Reversed?
TaxableEntity TaxableEntity
PostingDate PostingDate Posting Date for GR
DocumentDate DocumentDate Journal Entry Date
TaxReportingDate TaxReportingDate Tax Reporting Date
IsEUTriangularDeal IsEUTriangularDeal Is EU Triangular Deal
DelivOfGoodsDestCountry DelivOfGoodsDestCountry Dest. C/R
DelivOfGoodsOriginCountry DelivOfGoodsOriginCountry
EUTaxClassification EUTaxClassification
TaxType TaxType Tax Type
TaxDebitCreditCode TaxDebitCreditCode
ReferenceDocumentType ReferenceDocumentType Reference Document Type
BusinessPartnerName P_CAStRpECSalesListEntry BusinessPartnerName Extracted Customer Name
CAReconciliationKey CAReconciliationKey Reconcil. Key
_ReportingCurrency _ReportingCurrency
_OneTimeAccount _OneTimeAccount
_CompCode _CompCode
_BusinessPartner _BusinessPartner

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_CAStRpECSalesListEntry.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ICASRECSLENTRY

CREATE VIEW I_CAStRpECSalesListEntry AS
SELECT
  FICAData.CompanyCode AS CompanyCode,
  FICAData.CARptgDateTypeForECSalesList AS CARptgDateTypeForECSalesList,
  FICAData.ECSalesListReportingDate AS ECSalesListReportingDate,
  FICAData.BusinessPartner AS BusinessPartner,
  FICAData.CADocument AS CADocument,
  FICAData.CASqncNumberForECSalesList AS CASqncNumberForECSalesList,
  AccountingDocument,
  FiscalCalendarDate.FiscalYear AS FiscalYear,
  TaxCode,
  TransactionTypeDetermination,
  TaxItem,
  ReportedItemsLog.StatryRptCategory AS StatryRptCategory,
  ReportedItemsLog.StatryRptRunID AS StatryRptRunID,
  ReportedItemsLog.StatryRptgEntity AS StatryRptgEntity,
  Debtor,
  CustomerName,
  Creditor,
  SupplierName,
  VATRegistration,
  IsOneTimeAccount,
  AuthorizationGroup,
  TaxItemGroup,
  TaxJurisdiction,
  Country,
  AmountInReportingCurrency,
  ReportingCurrency,
  ReportingCountry,
  TaxReturnCountry,
  ReportingDate,
  TaxBaseAmountInCoCodeCrcy,
  CompanyCodeCurrency,
  TaxBaseAmountInTransCrcy,
  DocumentCurrency,
  TaxBaseAmountInCountryCrcy,
  CountryCurrency,
  IsReversal,
  IsReversed,
  TaxableEntity,
  PostingDate,
  DocumentDate,
  TaxReportingDate,
  IsEUTriangularDeal,
  DelivOfGoodsDestCountry,
  DelivOfGoodsOriginCountry,
  EUTaxClassification,
  TaxType,
  TaxDebitCreditCode,
  ReferenceDocumentType,
  FICAData.BusinessPartnerName AS BusinessPartnerName,
  CAReconciliationKey
FROM P_CAStRpECSalesListEntry AS FICAData
LEFT OUTER JOIN I_Currency AS _ReportingCurrency ON ReportingCurrency = _ReportingCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_OneTimeAccountBP AS _OneTimeAccount ON _OneTimeAccount.CompanyCode = CompanyCode AND _OneTimeAccount.AccountingDocument = AccountingDocument AND _OneTimeAccount.FiscalYear = FiscalYear  -- association [0..*]
;

Learn More