P_KR_StrpNoRptdNdedItemMapping

DDL: P_KR_STRPNORPTDNDEDITEMMAPPING SQL: PKRNORPTDNEDIMMP Type: view COMPOSITE
31 Fields 1 Data Sources 2 Associations

ACR Non Deductible Mapping No Reported

P_KR_StrpNoRptdNdedItemMapping is a Composite CDS View that provides data about "ACR Non Deductible Mapping No Reported" in SAP S/4HANA. It reads from 1 data source (I_KR_NoneDeductibleVATMapping) and exposes 31 fields with key fields KR_OutputVATCompanyCode, KR_OutputVATAccountingDocument, KR_OutputVATFiscalYear, KR_OutputVATItem. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_KR_NoneDeductibleVATMapping NonDedVATmapping from

Associations (2)

CardinalityTargetAliasCondition
[0..1] P_KR_StrpRptdNdedItemMapping _KR_StrpRptdNdedItemMapping NonDedVATmapping.KR_OutputVATCompanyCode = _KR_StrpRptdNdedItemMapping.KR_OutputVATCompanyCode and NonDedVATmapping.KR_OutputVATAccountingDocument = _KR_StrpRptdNdedItemMapping.KR_OutputVATAccountingDocument and NonDedVATmapping.KR_OutputVATFiscalYear = _KR_StrpRptdNdedItemMapping.KR_OutputVATFiscalYear and NonDedVATmapping.KR_OutputVATItem = _KR_StrpRptdNdedItemMapping.KR_OutputVATItem
[0..1] I_KR_VATReportingConfiguration _KR_VATReportingConfiguration taxitem.TaxCode = _KR_VATReportingConfiguration.TaxCode

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PKRNORPTDNEDIMMP 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 Deductible Mapping No Reported view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY KR_OutputVATCompanyCode I_KR_NoneDeductibleVATMapping KR_OutputVATCompanyCode Company Code
KEY KR_OutputVATAccountingDocument I_KR_NoneDeductibleVATMapping KR_OutputVATAccountingDocument Document Number
KEY KR_OutputVATFiscalYear I_KR_NoneDeductibleVATMapping KR_OutputVATFiscalYear Fiscal Year
KEY KR_OutputVATItem I_KR_NoneDeductibleVATMapping KR_OutputVATItem Item
TaxCode taxitem TaxCode Tax Code
CompanyCodeCurrency taxitem CompanyCodeCurrency Local Currency
TaxBaseAmountInCoCodeCrcy
TaxAmountInCoCodeCrcy
TaxRateValidityStartDate taxitem TaxRateValidityStartDate Tax Rate Validity Start Date
BusinessPlace taxitem BusinessPlace Business place
TaxReportingDate taxitem TaxReportingDate Tax Reporting Date
PostingDate taxitem PostingDate Posting Date for GR
DocumentDate taxitem DocumentDate Journal Entry Date
TaxReportingDocumentDate taxitem TaxReportingDocumentDate
FiscalPeriod taxitem FiscalPeriod Tax period
ReportingDate taxitem ReportingDate
TaxInvoiceType _KR_VATReportingConfiguration TaxInvoiceType
KR_InputVATCompanyCode I_KR_NoneDeductibleVATMapping KR_InputVATCompanyCode Company Code
KR_InputVATAccountingDocument I_KR_NoneDeductibleVATMapping KR_InputVATAccountingDocument Document Number
KR_InputVATFiscalYear I_KR_NoneDeductibleVATMapping KR_InputVATFiscalYear Fiscal Year
KR_InputVATItem I_KR_NoneDeductibleVATMapping KR_InputVATItem Item
StatryRptRunStatus _KR_StrpRptdNdedItemMapping StatryRptRunStatus
StatryRptRunID _KR_StrpRptdNdedItemMapping StatryRptRunID Report Run ID
StatryRptgEntity _KR_StrpRptdNdedItemMapping StatryRptgEntity Reporting Entity
StatryRptCategory _KR_StrpRptdNdedItemMapping StatryRptCategory Report ID
CreatedByUser I_KR_NoneDeductibleVATMapping CreatedByUser User Name
CaseCreatedOn I_KR_NoneDeductibleVATMapping CaseCreatedOn Created At
ChangedByUserName I_KR_NoneDeductibleVATMapping ChangedByUserName User Name
CaseLastChangedOn I_KR_NoneDeductibleVATMapping CaseLastChangedOn Last Changed At
_KR_StrpRptdNdedItemMapping _KR_StrpRptdNdedItemMapping
_KR_VATReportingConfiguration _KR_VATReportingConfiguration

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_StrpNoRptdNdedItemMapping.
-- 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: PKRNORPTDNEDIMMP

CREATE VIEW P_KR_StrpNoRptdNdedItemMapping AS
SELECT
  NonDedVATmapping.KR_OutputVATCompanyCode AS KR_OutputVATCompanyCode,
  NonDedVATmapping.KR_OutputVATAccountingDocument AS KR_OutputVATAccountingDocument,
  NonDedVATmapping.KR_OutputVATFiscalYear AS KR_OutputVATFiscalYear,
  NonDedVATmapping.KR_OutputVATItem AS KR_OutputVATItem,
  taxitem.TaxCode AS TaxCode,
  taxitem.CompanyCodeCurrency AS CompanyCodeCurrency,
  cast( 0 - taxitem.TaxBaseAmountInCoCodeCrcy as hwbas_shl) AS TaxBaseAmountInCoCodeCrcy,
  cast( 0 - taxitem.TaxAmountInCoCodeCrcy as fis_mwsts) AS TaxAmountInCoCodeCrcy,
  taxitem.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  taxitem.BusinessPlace AS BusinessPlace,
  taxitem.TaxReportingDate AS TaxReportingDate,
  taxitem.PostingDate AS PostingDate,
  taxitem.DocumentDate AS DocumentDate,
  taxitem.TaxReportingDocumentDate AS TaxReportingDocumentDate,
  taxitem.FiscalPeriod AS FiscalPeriod,
  taxitem.ReportingDate AS ReportingDate,
  _KR_VATReportingConfiguration.TaxInvoiceType AS TaxInvoiceType,
  NonDedVATmapping.KR_InputVATCompanyCode AS KR_InputVATCompanyCode,
  NonDedVATmapping.KR_InputVATAccountingDocument AS KR_InputVATAccountingDocument,
  NonDedVATmapping.KR_InputVATFiscalYear AS KR_InputVATFiscalYear,
  NonDedVATmapping.KR_InputVATItem AS KR_InputVATItem,
  _KR_StrpRptdNdedItemMapping.StatryRptRunStatus AS StatryRptRunStatus,
  _KR_StrpRptdNdedItemMapping.StatryRptRunID AS StatryRptRunID,
  _KR_StrpRptdNdedItemMapping.StatryRptgEntity AS StatryRptgEntity,
  _KR_StrpRptdNdedItemMapping.StatryRptCategory AS StatryRptCategory,
  NonDedVATmapping.CreatedByUser AS CreatedByUser,
  NonDedVATmapping.CaseCreatedOn AS CaseCreatedOn,
  NonDedVATmapping.ChangedByUserName AS ChangedByUserName,
  NonDedVATmapping.CaseLastChangedOn AS CaseLastChangedOn
FROM I_KR_NoneDeductibleVATMapping AS NonDedVATmapping
LEFT OUTER JOIN P_KR_StrpRptdNdedItemMapping AS _KR_StrpRptdNdedItemMapping ON NonDedVATmapping.KR_OutputVATCompanyCode = _KR_StrpRptdNdedItemMapping.KR_OutputVATCompanyCode AND NonDedVATmapping.KR_OutputVATAccountingDocument = _KR_StrpRptdNdedItemMapping.KR_OutputVATAccountingDocument AND NonDedVATmapping.KR_OutputVATFiscalYear = _KR_StrpRptdNdedItemMapping.KR_OutputVATFiscalYear AND NonDedVATmapping.KR_OutputVATItem = _KR_StrpRptdNdedItemMapping.KR_OutputVATItem  -- association [0..1]
LEFT OUTER JOIN I_KR_VATReportingConfiguration AS _KR_VATReportingConfiguration ON taxitem.TaxCode = _KR_VATReportingConfiguration.TaxCode  -- association [0..1]
;

Learn More