P_RU_VatSPLedgerCust

DDL: P_RU_VATSPLEDGERCUST SQL: PRUVATSPLDCUST Type: view CONSUMPTION
30 Fields 1 Data Sources

S/P Ledgers Customizing Data

P_RU_VatSPLedgerCust is a Consumption CDS View that provides data about "S/P Ledgers Customizing Data" in SAP S/4HANA. It reads from 1 data source (I_RU_VATReturnSettingItem) and exposes 30 fields with key fields RU_VATSubScenarioVersion, AccountingDocumentType, TaxCode, DebitCreditCode, TaxItemClassification.

Data Sources (1)

SourceAliasJoin Type
I_RU_VATReturnSettingItem VatSPLedgerCustDecl from

Annotations (11)

NameValueLevelField
VDM.viewType #CONSUMPTION view
VDM.private true view
AbapCatalog.sqlViewName PRUVATSPLDCUST view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
EndUserText.label S/P Ledgers Customizing Data view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY RU_VATSubScenarioVersion I_RU_VATReturnSettingItem RU_VATSubScenarioVersion Subscenario Version
KEY AccountingDocumentType VatSPLedgerCustSubs AccountingDocumentType Journal Entry Type
KEY TaxCode VatSPLedgerCustSubs TaxCode Tax Code
KEY DebitCreditCode VatSPLedgerCustSubs DebitCreditCode Single-Character Flag
KEY TaxItemClassification VatSPLedgerCustSubs TaxItemClassification
KEY IsCorrectionInvoice VatSPLedgerCustSubs IsCorrectionInvoice
KEY RU_VATReturnVersion I_RU_VATReturnSettingItem RU_VATReturnVersion VAT Return Version
KEY RU_VATSubScenario I_RU_VATReturnSettingItem RU_VATSubScenario Subscenario
KEY RU_VATReturnSection I_RU_VATReturnSettingItem RU_VATReturnSection VAT Return Section
KEY RU_VATScenario I_RU_VATReturnSettingItem RU_VATScenario VAT Scenario
KEY TaxBox I_RU_VATReturnSettingItem RU_VATReturnLine Line
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 VatSPLedgerCustSubs 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_VatSPLedgerCust.
-- 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: PRUVATSPLDCUST

CREATE VIEW P_RU_VatSPLedgerCust AS
SELECT
  VatSPLedgerCustDecl.RU_VATSubScenarioVersion AS RU_VATSubScenarioVersion,
  VatSPLedgerCustSubs.AccountingDocumentType AS AccountingDocumentType,
  VatSPLedgerCustSubs.TaxCode AS TaxCode,
  VatSPLedgerCustSubs.DebitCreditCode AS DebitCreditCode,
  VatSPLedgerCustSubs.TaxItemClassification AS TaxItemClassification,
  VatSPLedgerCustSubs.IsCorrectionInvoice AS IsCorrectionInvoice,
  VatSPLedgerCustDecl.RU_VATReturnVersion AS RU_VATReturnVersion,
  VatSPLedgerCustDecl.RU_VATSubScenario AS RU_VATSubScenario,
  VatSPLedgerCustDecl.RU_VATReturnSection AS RU_VATReturnSection,
  VatSPLedgerCustDecl.RU_VATScenario AS RU_VATScenario,
  VatSPLedgerCustDecl.RU_VATReturnLine AS TaxBox,
  VatSPLedgerCustDecl.RU_VATReturnSectionType AS RU_VATReturnSectionType,
  VatSPLedgerCustDecl.BusinessPartnerType AS BusinessPartnerType,
  VatSPLedgerCustDecl.PaymentOrderOutputType AS PaymentOrderOutputType,
  VatSPLedgerCustDecl.ImprtCstmsDeclnIsRead AS ImprtCstmsDeclnIsRead,
  VatSPLedgerCustDecl.RU_TaxBaseAmountCalcType AS RU_TaxBaseAmountCalcType,
  VatSPLedgerCustDecl.RU_TaxAmountCalcType AS RU_TaxAmountCalcType,
  VatSPLedgerCustDecl.RU_TotalAmountCalcType AS RU_TotalAmountCalcType,
  VatSPLedgerCustDecl.AgentType AS AgentType,
  VatSPLedgerCustDecl.RU_OrgOperationType AS RU_OrgOperationType,
  VatSPLedgerCustDecl.RU_PersonOperationType AS RU_PersonOperationType,
  VatSPLedgerCustDecl.MatlRcptDateIsRead AS MatlRcptDateIsRead,
  VatSPLedgerCustDecl.RU_CustomerOutputType AS RU_CustomerOutputType,
  VatSPLedgerCustDecl.RU_SupplierAgentOutputType AS RU_SupplierAgentOutputType,
  VatSPLedgerCustDecl.RU_SupplierOutputType AS RU_SupplierOutputType,
  VatSPLedgerCustDecl.RU_SubagentOutputType AS RU_SubagentOutputType,
  VatSPLedgerCustDecl.RU_InvoiceSupplierOutputType AS RU_InvoiceSupplierOutputType,
  VatSPLedgerCustDecl.RU_InvoiceCustomerOutputType AS RU_InvoiceCustomerOutputType,
  VatSPLedgerCustDecl.SalesDealType AS SalesDealType,
  VatSPLedgerCustSubs.VATReturnOperation AS VATReturnOperation
FROM I_RU_VATReturnSettingItem AS VatSPLedgerCustDecl
;

Learn More