P_RU_ExprtConfRegRptItemSOK

DDL: P_RU_EXPRTCONFREGRPTITEMSOK SQL: PRUREGRPTITEM Type: view COMPOSITE Package: GLO_FIN_IS_VAT_RU_EXP_CONF_REG

Submitted documents

P_RU_ExprtConfRegRptItemSOK is a Composite CDS View that provides data about "Submitted documents" in SAP S/4HANA. It reads from 1 data source (I_StRpRepRun) and exposes 13 fields. Part of development package GLO_FIN_IS_VAT_RU_EXP_CONF_REG.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
I_StRpRepRun CurrentRun from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PRUREGRPTITEM view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.private true view
AbapCatalog.compiler.compareFilter true view

Fields (13)

KeyFieldSource TableSource FieldDescription
StatryRptgEntity SubmittedDocs StatryRptgEntity
StatryRptCategory SubmittedDocs StatryRptCategory
StatryRptRunID SubmittedDocs StatryRptRunID
CompanyCode SubmittedDocs CompanyCode
TaxTransferDocument SubmittedDocs TaxTransferDocument
FiscalYear SubmittedDocs FiscalYear
VATReturnOperation SubmittedDocs VATReturnOperation
StatryRptTaskUUID SubmittedDocs StatryRptTaskUUID
StatryRptRunType SubmittedDocs StatryRptRunType
StatryRptRunStatus SubmittedDocs StatryRptRunStatus
CurrentStatryRptRunID I_StRpRepRun StatryRptRunID
StatryRptTaskPeriodStartDate SubmittedDocs StatryRptTaskPeriodStartDate
StatryRptTaskPeriodEndDate SubmittedDocs StatryRptTaskPeriodEndDate 
@AbapCatalog.sqlViewName:'PRUREGRPTITEM'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #NOT_REQUIRED
@VDM.private: true
@AbapCatalog.compiler.compareFilter:true
//select submitted only in PREVIOUS periods documents

define view P_RU_ExprtConfRegRptItemSOK
  as select from I_StRpRepRun                 as CurrentRun

    join         P_RU_ExprtConfRegRptItemSOK1 as SubmittedDocs on  SubmittedDocs.StatryRptgEntity  =  CurrentRun.StatryRptgEntity
                                                               and SubmittedDocs.StatryRptCategory =  CurrentRun.StatryRptCategory
                                                               and SubmittedDocs.StatryRptTaskUUID <> CurrentRun.StatryRptTaskUUID

{
  SubmittedDocs.StatryRptgEntity,
  SubmittedDocs.StatryRptCategory,
  SubmittedDocs.StatryRptRunID,
  SubmittedDocs.CompanyCode,
  SubmittedDocs.TaxTransferDocument,
  SubmittedDocs.FiscalYear,
  SubmittedDocs.VATReturnOperation,
  SubmittedDocs.StatryRptTaskUUID,
  SubmittedDocs.StatryRptRunType,
  SubmittedDocs.StatryRptRunStatus,
  CurrentRun.StatryRptRunID as CurrentStatryRptRunID,
  SubmittedDocs.StatryRptTaskPeriodStartDate,
  SubmittedDocs.StatryRptTaskPeriodEndDate
}

Learn More