P_KR_StrpRptdNdedItemDetail

DDL: P_KR_STRPRPTDNDEDITEMDETAIL SQL: PKRRPTDNEDITDTA Type: view COMPOSITE Package: GLO_FIN_NON_DEDUCTIBLE_VAT
21 Fields

ACR Non Deduct Item Detail Reported

P_KR_StrpRptdNdedItemDetail is a Composite CDS View that provides data about "ACR Non Deduct Item Detail Reported" in SAP S/4HANA. Part of development package GLO_FIN_NON_DEDUCTIBLE_VAT.

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PKRRPTDNEDITDTA 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 Deduct Item Detail Reported view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_KR_RptdNoneDcblVATItmDetail CompanyCode Receiver Company Code
KEY AccountingDocument I_KR_RptdNoneDcblVATItmDetail AccountingDocument Journal Entry
KEY FiscalYear I_KR_RptdNoneDcblVATItmDetail FiscalYear G/L Fiscal Year
KEY TaxItem I_KR_RptdNoneDcblVATItmDetail TaxItem Tax Item
StatryRptRunID I_KR_RptdNoneDcblVATItmDetail StatryRptRunID Report Run ID
StatryRptgEntity I_KR_RptdNoneDcblVATItmDetail StatryRptgEntity Reporting Entity
StatryRptCategory I_KR_RptdNoneDcblVATItmDetail StatryRptCategory Report ID
ReportingDate I_KR_RptdNoneDcblVATItmDetail ReportingDate
DeclarationPeriodNumber I_KR_RptdNoneDcblVATItmDetail DeclarationPeriodNumber
KR_NoneDeductibleInputVATCat I_KR_RptdNoneDcblVATItmDetail KR_NoneDeductibleInputVATCat
KR_NoneDeductibleInputVATSts I_KR_RptdNoneDcblVATItmDetail KR_NoneDeductibleInputVATSts
FinancialAccountType I_KR_RptdNoneDcblVATItmDetail FinancialAccountType Fin. Account Type
KR_TaxExemptRevenueInCCCrcy I_KR_RptdNoneDcblVATItmDetail KR_TaxExemptRevenueInCCCrcy
TotalRevenueInCoCodeCrcy I_KR_RptdNoneDcblVATItmDetail TotalRevenueInCoCodeCrcy
IsCompleted I_KR_RptdNoneDcblVATItmDetail IsCompleted
Currency I_KR_RptdNoneDcblVATItmDetail Currency Valuation Crcy
CreatedByUser I_KR_RptdNoneDcblVATItmDetail CreatedByUser User Name
CaseCreatedOn I_KR_RptdNoneDcblVATItmDetail CaseCreatedOn Created At
ChangedByUserName I_KR_RptdNoneDcblVATItmDetail ChangedByUserName
CaseLastChangedOn I_KR_RptdNoneDcblVATItmDetail CaseLastChangedOn Last Changed At
StatryRptRunStatus I_StRpRepRun StatryRptRunStatus

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_StrpRptdNdedItemDetail.
-- 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: PKRRPTDNEDITDTA

CREATE VIEW P_KR_StrpRptdNdedItemDetail AS
SELECT
  I_KR_RptdNoneDcblVATItmDetail.CompanyCode AS CompanyCode,
  I_KR_RptdNoneDcblVATItmDetail.AccountingDocument AS AccountingDocument,
  I_KR_RptdNoneDcblVATItmDetail.FiscalYear AS FiscalYear,
  I_KR_RptdNoneDcblVATItmDetail.TaxItem AS TaxItem,
  I_KR_RptdNoneDcblVATItmDetail.StatryRptRunID AS StatryRptRunID,
  I_KR_RptdNoneDcblVATItmDetail.StatryRptgEntity AS StatryRptgEntity,
  I_KR_RptdNoneDcblVATItmDetail.StatryRptCategory AS StatryRptCategory,
  I_KR_RptdNoneDcblVATItmDetail.ReportingDate AS ReportingDate,
  I_KR_RptdNoneDcblVATItmDetail.DeclarationPeriodNumber AS DeclarationPeriodNumber,
  I_KR_RptdNoneDcblVATItmDetail.KR_NoneDeductibleInputVATCat AS KR_NoneDeductibleInputVATCat,
  I_KR_RptdNoneDcblVATItmDetail.KR_NoneDeductibleInputVATSts AS KR_NoneDeductibleInputVATSts,
  I_KR_RptdNoneDcblVATItmDetail.FinancialAccountType AS FinancialAccountType,
  I_KR_RptdNoneDcblVATItmDetail.KR_TaxExemptRevenueInCCCrcy AS KR_TaxExemptRevenueInCCCrcy,
  I_KR_RptdNoneDcblVATItmDetail.TotalRevenueInCoCodeCrcy AS TotalRevenueInCoCodeCrcy,
  I_KR_RptdNoneDcblVATItmDetail.IsCompleted AS IsCompleted,
  I_KR_RptdNoneDcblVATItmDetail.Currency AS Currency,
  I_KR_RptdNoneDcblVATItmDetail.CreatedByUser AS CreatedByUser,
  I_KR_RptdNoneDcblVATItmDetail.CaseCreatedOn AS CaseCreatedOn,
  I_KR_RptdNoneDcblVATItmDetail.ChangedByUserName AS ChangedByUserName,
  I_KR_RptdNoneDcblVATItmDetail.CaseLastChangedOn AS CaseLastChangedOn,
  I_StRpRepRun.StatryRptRunStatus AS StatryRptRunStatus
;

Learn More