P_KR_StrpNoRptdNdedItemDetai02

DDL: P_KR_STRPNORPTDNDEDITEMDETAI02 SQL: PKRNORPTDNEDIT02 Type: view COMPOSITE
14 Fields 1 Data Sources 1 Associations

ACR Non Deduc Item Detail No Reported

P_KR_StrpNoRptdNdedItemDetai02 is a Composite CDS View that provides data about "ACR Non Deduc Item Detail No Reported" in SAP S/4HANA. It reads from 1 data source (I_KR_NonDcblVATItemDetail) and exposes 14 fields with key fields CompanyCode, AccountingDocument, FiscalYear, TaxItem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_KR_NonDcblVATItemDetail NonDcbVATItemDetail from

Associations (1)

CardinalityTargetAliasCondition
[0..1] P_KR_StrpRptdNdedItemDetail _Reporteditem $projection.CompanyCode = _Reporteditem.CompanyCode and $projection.AccountingDocument = _Reporteditem.AccountingDocument and $projection.FiscalYear = _Reporteditem.FiscalYear and $projection.TaxItem = _Reporteditem.TaxItem and $projection.DeclarationPeriodNumber = _Reporteditem.DeclarationPeriodNumber

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PKRNORPTDNEDIT02 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label ACR Non Deduc Item Detail No Reported view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_KR_NonDcblVATItemDetail CompanyCode Receiver Company Code
KEY AccountingDocument I_KR_NonDcblVATItemDetail AccountingDocument Journal Entry
KEY FiscalYear I_KR_NonDcblVATItemDetail FiscalYear G/L Fiscal Year
KEY TaxItem I_KR_NonDcblVATItemDetail TaxItem Tax Item
DeclarationPeriodNumber I_KR_NonDcblVATItemDetail DeclarationPeriodNumber Reporting Times
KR_TaxExemptRevenueInCCCrcy I_KR_NonDcblVATItemDetail KR_TaxExemptRevenueInCCCrcy Tax Exempt Revenue
TotalRevenueInCoCodeCrcy I_KR_NonDcblVATItemDetail TotalRevenueInCoCodeCrcy Total Revenue
CompanyCodeCurrency I_KR_NonDcblVATItemDetail CompanyCodeCurrency Local Currency
CreatedByUser I_KR_NonDcblVATItemDetail CreatedByUser User Name
CaseCreatedOn I_KR_NonDcblVATItemDetail CaseCreatedOn Created At
ChangedByUserName I_KR_NonDcblVATItemDetail ChangedByUserName User Name
CaseLastChangedOn I_KR_NonDcblVATItemDetail CaseLastChangedOn Last Changed At
StatryRptRunStatus _Reporteditem StatryRptRunStatus
_Reporteditem _Reporteditem

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 P_KR_StrpNoRptdNdedItemDetai02.
-- 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: PKRNORPTDNEDIT02

CREATE VIEW P_KR_StrpNoRptdNdedItemDetai02 AS
SELECT
  NonDcbVATItemDetail.CompanyCode AS CompanyCode,
  NonDcbVATItemDetail.AccountingDocument AS AccountingDocument,
  NonDcbVATItemDetail.FiscalYear AS FiscalYear,
  NonDcbVATItemDetail.TaxItem AS TaxItem,
  NonDcbVATItemDetail.DeclarationPeriodNumber AS DeclarationPeriodNumber,
  NonDcbVATItemDetail.KR_TaxExemptRevenueInCCCrcy AS KR_TaxExemptRevenueInCCCrcy,
  NonDcbVATItemDetail.TotalRevenueInCoCodeCrcy AS TotalRevenueInCoCodeCrcy,
  NonDcbVATItemDetail.CompanyCodeCurrency AS CompanyCodeCurrency,
  NonDcbVATItemDetail.CreatedByUser AS CreatedByUser,
  NonDcbVATItemDetail.CaseCreatedOn AS CaseCreatedOn,
  NonDcbVATItemDetail.ChangedByUserName AS ChangedByUserName,
  NonDcbVATItemDetail.CaseLastChangedOn AS CaseLastChangedOn,
  _Reporteditem.StatryRptRunStatus AS StatryRptRunStatus
FROM I_KR_NonDcblVATItemDetail AS NonDcbVATItemDetail
LEFT OUTER JOIN P_KR_StrpRptdNdedItemDetail AS _Reporteditem ON CompanyCode = _Reporteditem.CompanyCode AND AccountingDocument = _Reporteditem.AccountingDocument AND FiscalYear = _Reporteditem.FiscalYear AND TaxItem = _Reporteditem.TaxItem AND DeclarationPeriodNumber = _Reporteditem.DeclarationPeriodNumber  -- association [0..1]
;

Learn More