I_CAStRpECSalesListDoc

DDL: I_CASTRPECSALESLISTDOC Type: view_entity BASIC
33 Fields 1 Data Sources 6 Associations

Statutory Reporting EC Sales List Doc

I_CAStRpECSalesListDoc is a Basic CDS View that provides data about "Statutory Reporting EC Sales List Doc" in SAP S/4HANA. It reads from 1 data source (dfkkrepzm) and exposes 33 fields with key fields CompanyCode, CARptgDateTypeForECSalesList, ECSalesListReportingDate, BusinessPartner, CADocumentNumber. It has 6 associations to related views.

Data Sources (1)

SourceAliasJoin Type
dfkkrepzm dfkkrepzm from

Associations (6)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartner _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner
[1..1] I_CADocument _CADocument $projection.CADocumentNumber = _CADocument.CADocumentNumber
[1..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[0..1] I_Currency _CompanyCodeCurrency $projection.CompanyCodeCurrency = _CompanyCodeCurrency.Currency
[1..1] I_Currency _CountryCurrency $projection.CountryCurrency = _CountryCurrency.Currency
[0..1] I_TaxType _TaxType $projection.TaxType = _TaxType.TaxType

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Statutory Reporting EC Sales List Doc view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode bukrs Value
KEY CARptgDateTypeForECSalesList datty Reporting Date
KEY ECSalesListReportingDate datum Valid to
KEY BusinessPartner gpart Tech. BPartner
KEY CADocumentNumber opbel Reopen
KEY CASqncNumberForECSalesList lfdnr Tax sequence
TaxCode mwskz Tax Code
TaxType mwart Tax Type
EUTaxClassification egrkz EU Code/Code
CountryCurrency lwaer Reporting Crcy
CompanyCodeCurrency hwaer Local Currency
CATaxBaseAmtInCountryCrcy lwbas NC Basis
CATaxBaseAmtInCoCodeCrcy hwbas LC Base Amt
TaxReturnCountry lstml Reporting C/R
CAReferenceDocument xblnr Reference
CAPostingDate budat Posting Date
DocumentDate bldat Journal Entry Date
CANetDueDate faedn Net Due Date
TaxReportingDate vatdate Valid From
CAReversedDocumentNumber stbel Reversed Doc.
VATRegistration stceg VAT Reg. No.
Country land1 Trip Ctry/Reg
BusinessPartnerName name1 PA text
CABusinessPartnerRefType gprtp Reference Type
CABusinessPartnerRefForType gpref Reference
ContrAcctgECSalesListRefDoc ref_opbel
ECSalesListReferenceDate ref_date
_BusinessPartner _BusinessPartner
_CADocument _CADocument
_CompanyCode _CompanyCode
_CompanyCodeCurrency _CompanyCodeCurrency
_CountryCurrency _CountryCurrency
_TaxType _TaxType

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_CAStRpECSalesListDoc.
-- 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.

CREATE VIEW I_CAStRpECSalesListDoc AS
SELECT
  bukrs AS CompanyCode,
  datty AS CARptgDateTypeForECSalesList,
  datum AS ECSalesListReportingDate,
  gpart AS BusinessPartner,
  opbel AS CADocumentNumber,
  lfdnr AS CASqncNumberForECSalesList,
  mwskz AS TaxCode,
  mwart AS TaxType,
  egrkz AS EUTaxClassification,
  lwaer AS CountryCurrency,
  hwaer AS CompanyCodeCurrency,
  lwbas AS CATaxBaseAmtInCountryCrcy,
  hwbas AS CATaxBaseAmtInCoCodeCrcy,
  lstml AS TaxReturnCountry,
  xblnr AS CAReferenceDocument,
  budat AS CAPostingDate,
  bldat AS DocumentDate,
  faedn AS CANetDueDate,
  vatdate AS TaxReportingDate,
  stbel AS CAReversedDocumentNumber,
  stceg AS VATRegistration,
  land1 AS Country,
  name1 AS BusinessPartnerName,
  gprtp AS CABusinessPartnerRefType,
  gpref AS CABusinessPartnerRefForType,
  ref_opbel AS ContrAcctgECSalesListRefDoc,
  ref_date AS ECSalesListReferenceDate
FROM dfkkrepzm
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_CADocument AS _CADocument ON CADocumentNumber = _CADocument.CADocumentNumber  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CountryCurrency ON CountryCurrency = _CountryCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_TaxType AS _TaxType ON TaxType = _TaxType.TaxType  -- association [0..1]
;

Learn More