P_RU_VATReportingCust

DDL: P_RU_VATREPORTINGCUST SQL: PRUVATRPTGCUST Type: view CONSUMPTION
32 Fields 2 Data Sources

P_RU_VATReportingCust is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (I_RU_VATReturnSettingItem, P_RU_VATReportingCustSubs) and exposes 32 fields with key fields RU_VATReturnVersion, RU_VATSubScenarioVersion, RU_VATReturnSection, RU_VATReturnLine, RU_VATSubScenario.

Data Sources (2)

SourceAliasJoin Type
I_RU_VATReturnSettingItem DeclCust from
P_RU_VATReportingCustSubs SubsCust inner

Annotations (7)

NameValueLevelField
VDM.private true view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName PRUVATRPTGCUST view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY RU_VATReturnVersion I_RU_VATReturnSettingItem RU_VATReturnVersion VAT Return Version
KEY RU_VATSubScenarioVersion I_RU_VATReturnSettingItem RU_VATSubScenarioVersion Subscenario Version
KEY RU_VATReturnSection I_RU_VATReturnSettingItem RU_VATReturnSection VAT Return Section
KEY RU_VATReturnLine I_RU_VATReturnSettingItem RU_VATReturnLine Line
KEY RU_VATSubScenario P_RU_VATReportingCustSubs RU_VATSubScenario Subscenario
KEY RU_VATSubScenarioItem P_RU_VATReportingCustSubs RU_VATSubScenarioItem
KEY TaxCode P_RU_VATReportingCustSubs TaxCode Tax Code
KEY AccountingDocumentType P_RU_VATReportingCustSubs AccountingDocumentType Journal Entry Type
KEY DebitCreditCode P_RU_VATReportingCustSubs DebitCreditCode Single-Character Flag
KEY TaxItemClassification P_RU_VATReportingCustSubs TaxItemClassification
KEY RU_SourceDocumentType P_RU_VATReportingCustSubs RU_SourceDocumentType
KEY IsCorrectionInvoice P_RU_VATReportingCustSubs IsCorrectionInvoice
RU_VATScenario I_RU_VATReturnSettingItem RU_VATScenario VAT Scenario
RU_VATReturnSectionType I_RU_VATReturnSettingItem RU_VATReturnSectionType Section Type
BusinessPartnerType I_RU_VATReturnSettingItem BusinessPartnerType Undefined range (can be used for patch levels)
PaymentOrderOutputType I_RU_VATReturnSettingItem PaymentOrderOutputType
ImprtCstmsDeclnIsRead I_RU_VATReturnSettingItem ImprtCstmsDeclnIsRead
RU_TaxBaseAmountCalcType I_RU_VATReturnSettingItem RU_TaxBaseAmountCalcType
RU_TaxAmountCalcType I_RU_VATReturnSettingItem RU_TaxAmountCalcType
RU_TotalAmountCalcType I_RU_VATReturnSettingItem RU_TotalAmountCalcType
AgentType I_RU_VATReturnSettingItem AgentType
RU_OrgOperationType I_RU_VATReturnSettingItem RU_OrgOperationType
RU_PersonOperationType I_RU_VATReturnSettingItem RU_PersonOperationType
MatlRcptDateIsRead I_RU_VATReturnSettingItem MatlRcptDateIsRead
RU_CustomerOutputType I_RU_VATReturnSettingItem RU_CustomerOutputType
RU_SupplierAgentOutputType I_RU_VATReturnSettingItem RU_SupplierAgentOutputType
RU_SupplierOutputType I_RU_VATReturnSettingItem RU_SupplierOutputType
RU_SubagentOutputType I_RU_VATReturnSettingItem RU_SubagentOutputType
RU_InvoiceSupplierOutputType I_RU_VATReturnSettingItem RU_InvoiceSupplierOutputType
RU_InvoiceCustomerOutputType I_RU_VATReturnSettingItem RU_InvoiceCustomerOutputType
SalesDealType I_RU_VATReturnSettingItem SalesDealType Deal Type
VATReturnOperation P_RU_VATReportingCustSubs VATReturnOperation Operation Code

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_RU_VATReportingCust.
-- 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: PRUVATRPTGCUST

CREATE VIEW P_RU_VATReportingCust AS
SELECT
  DeclCust.RU_VATReturnVersion AS RU_VATReturnVersion,
  DeclCust.RU_VATSubScenarioVersion AS RU_VATSubScenarioVersion,
  DeclCust.RU_VATReturnSection AS RU_VATReturnSection,
  DeclCust.RU_VATReturnLine AS RU_VATReturnLine,
  SubsCust.RU_VATSubScenario AS RU_VATSubScenario,
  SubsCust.RU_VATSubScenarioItem AS RU_VATSubScenarioItem,
  SubsCust.TaxCode AS TaxCode,
  SubsCust.AccountingDocumentType AS AccountingDocumentType,
  SubsCust.DebitCreditCode AS DebitCreditCode,
  SubsCust.TaxItemClassification AS TaxItemClassification,
  SubsCust.RU_SourceDocumentType AS RU_SourceDocumentType,
  SubsCust.IsCorrectionInvoice AS IsCorrectionInvoice,
  DeclCust.RU_VATScenario AS RU_VATScenario,
  DeclCust.RU_VATReturnSectionType AS RU_VATReturnSectionType,
  DeclCust.BusinessPartnerType AS BusinessPartnerType,
  DeclCust.PaymentOrderOutputType AS PaymentOrderOutputType,
  DeclCust.ImprtCstmsDeclnIsRead AS ImprtCstmsDeclnIsRead,
  DeclCust.RU_TaxBaseAmountCalcType AS RU_TaxBaseAmountCalcType,
  DeclCust.RU_TaxAmountCalcType AS RU_TaxAmountCalcType,
  DeclCust.RU_TotalAmountCalcType AS RU_TotalAmountCalcType,
  DeclCust.AgentType AS AgentType,
  DeclCust.RU_OrgOperationType AS RU_OrgOperationType,
  DeclCust.RU_PersonOperationType AS RU_PersonOperationType,
  DeclCust.MatlRcptDateIsRead AS MatlRcptDateIsRead,
  DeclCust.RU_CustomerOutputType AS RU_CustomerOutputType,
  DeclCust.RU_SupplierAgentOutputType AS RU_SupplierAgentOutputType,
  DeclCust.RU_SupplierOutputType AS RU_SupplierOutputType,
  DeclCust.RU_SubagentOutputType AS RU_SubagentOutputType,
  DeclCust.RU_InvoiceSupplierOutputType AS RU_InvoiceSupplierOutputType,
  DeclCust.RU_InvoiceCustomerOutputType AS RU_InvoiceCustomerOutputType,
  DeclCust.SalesDealType AS SalesDealType,
  SubsCust.VATReturnOperation AS VATReturnOperation
FROM I_RU_VATReturnSettingItem AS DeclCust
INNER JOIN P_RU_VATReportingCustSubs AS SubsCust ON /* join condition not captured in parsed metadata */
;

Learn More