P_KR_StrpRptdNdedItemMapping

DDL: P_KR_STRPRPTDNDEDITEMMAPPING SQL: PKRRPTDNEDIMMAP Type: view COMPOSITE Package: GLO_FIN_NON_DEDUCTIBLE_VAT
16 Fields

ACR Non Deductible Mapping Reported

P_KR_StrpRptdNdedItemMapping is a Composite CDS View that provides data about "ACR Non Deductible Mapping Reported" in SAP S/4HANA. Part of development package GLO_FIN_NON_DEDUCTIBLE_VAT.

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PKRRPTDNEDIMMAP 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 Reported view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY KR_InputVATCompanyCode I_KR_ReportedNoneDcblVATMappg KR_InputVATCompanyCode
KEY KR_InputVATAccountingDocument I_KR_ReportedNoneDcblVATMappg KR_InputVATAccountingDocument
KEY KR_InputVATFiscalYear I_KR_ReportedNoneDcblVATMappg KR_InputVATFiscalYear
KEY KR_InputVATItem I_KR_ReportedNoneDcblVATMappg KR_InputVATItem
StatryRptRunStatus I_StRpRepRun StatryRptRunStatus
StatryRptRunID I_KR_ReportedNoneDcblVATMappg StatryRptRunID Report Run ID
StatryRptgEntity I_KR_ReportedNoneDcblVATMappg StatryRptgEntity Reporting Entity
StatryRptCategory I_KR_ReportedNoneDcblVATMappg StatryRptCategory Report ID
KR_OutputVATCompanyCode I_KR_ReportedNoneDcblVATMappg KR_OutputVATCompanyCode
KR_OutputVATAccountingDocument I_KR_ReportedNoneDcblVATMappg KR_OutputVATAccountingDocument
KR_OutputVATFiscalYear I_KR_ReportedNoneDcblVATMappg KR_OutputVATFiscalYear
KR_OutputVATItem I_KR_ReportedNoneDcblVATMappg KR_OutputVATItem
CreatedByUser I_KR_ReportedNoneDcblVATMappg CreatedByUser User Name
CaseCreatedOn I_KR_ReportedNoneDcblVATMappg CaseCreatedOn Created At
ChangedByUserName I_KR_ReportedNoneDcblVATMappg ChangedByUserName
CaseLastChangedOn I_KR_ReportedNoneDcblVATMappg CaseLastChangedOn Last Changed At

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_StrpRptdNdedItemMapping.
-- 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: PKRRPTDNEDIMMAP

CREATE VIEW P_KR_StrpRptdNdedItemMapping AS
SELECT
  I_KR_ReportedNoneDcblVATMappg.KR_InputVATCompanyCode AS KR_InputVATCompanyCode,
  I_KR_ReportedNoneDcblVATMappg.KR_InputVATAccountingDocument AS KR_InputVATAccountingDocument,
  I_KR_ReportedNoneDcblVATMappg.KR_InputVATFiscalYear AS KR_InputVATFiscalYear,
  I_KR_ReportedNoneDcblVATMappg.KR_InputVATItem AS KR_InputVATItem,
  I_StRpRepRun.StatryRptRunStatus AS StatryRptRunStatus,
  I_KR_ReportedNoneDcblVATMappg.StatryRptRunID AS StatryRptRunID,
  I_KR_ReportedNoneDcblVATMappg.StatryRptgEntity AS StatryRptgEntity,
  I_KR_ReportedNoneDcblVATMappg.StatryRptCategory AS StatryRptCategory,
  I_KR_ReportedNoneDcblVATMappg.KR_OutputVATCompanyCode AS KR_OutputVATCompanyCode,
  I_KR_ReportedNoneDcblVATMappg.KR_OutputVATAccountingDocument AS KR_OutputVATAccountingDocument,
  I_KR_ReportedNoneDcblVATMappg.KR_OutputVATFiscalYear AS KR_OutputVATFiscalYear,
  I_KR_ReportedNoneDcblVATMappg.KR_OutputVATItem AS KR_OutputVATItem,
  I_KR_ReportedNoneDcblVATMappg.CreatedByUser AS CreatedByUser,
  I_KR_ReportedNoneDcblVATMappg.CaseCreatedOn AS CaseCreatedOn,
  I_KR_ReportedNoneDcblVATMappg.ChangedByUserName AS ChangedByUserName,
  I_KR_ReportedNoneDcblVATMappg.CaseLastChangedOn AS CaseLastChangedOn
;

Learn More