P_RU_VatSubscenarioAssignment

DDL: P_RU_VATSUBSCENARIOASSIGNMENT SQL: PRUVATSUBSCASSGN Type: view BASIC
23 Fields 1 Data Sources

P_RU_VatSubscenarioAssignment is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (firud_vatsubas) and exposes 23 fields with key fields RU_VATReturnVersion, RU_VATReturnSection, RU_VATReturnLine, RU_VATSubScenario.

Data Sources (1)

SourceAliasJoin Type
firud_vatsubas firud_vatsubas from

Annotations (10)

NameValueLevelField
VDM.private true view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName PRUVATSUBSCASSGN 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 #A view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY RU_VATReturnVersion version XML Vers.
KEY RU_VATReturnSection sect VAT Return Section
KEY RU_VATReturnLine line VAT Return Line Item
KEY RU_VATSubScenario subscenario Subscenario
TaxBaseAmountCalcType_1 vatr_base VAT Base Source
TaxAmountCalcType vatr_tax VAT Amount Source
TaxBaseAmountCalcType_2 tax_base Tax Base Source
AmountCalcType tax_amount VAT Amount Type
SignIsInverted sign_inver Invert D/C Sign
BusinessPartnerType bp_opt Business Partner
AgentType bp_ag Bus. Partner Agent
PaymentOrderOutputType pord_out Payment Order
ImprtCstmsDeclnIsRead gtd_out ImCD/RNPT Option
MatlRcptDateIsRead mrec_dt_out Date of Material Rec
RU_CustomerOutputType buyer Real Buyer Source
RU_SupplierAgentOutputType sellerag Real Seller Source
RU_SupplierOutputType seller Seller
RU_SubagentOutputType subagent Subagent Source
SalesDealType dealtype Deal Type
RU_OrgOperationType opc_type Oper.TypeCode Org.
RU_PersonOperationType opc_tpin Oper.TypeCode Person
RU_InvoiceSupplierOutputType sel_inv_out Seller in Inv.Output
RU_InvoiceCustomerOutputType buy_inv_out Buyer in Inv. Output

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_VatSubscenarioAssignment.
-- 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: PRUVATSUBSCASSGN

CREATE VIEW P_RU_VatSubscenarioAssignment AS
SELECT
  version AS RU_VATReturnVersion,
  sect AS RU_VATReturnSection,
  line AS RU_VATReturnLine,
  subscenario AS RU_VATSubScenario,
  vatr_base AS TaxBaseAmountCalcType_1,
  vatr_tax AS TaxAmountCalcType,
  tax_base AS TaxBaseAmountCalcType_2,
  tax_amount AS AmountCalcType,
  sign_inver AS SignIsInverted,
  bp_opt AS BusinessPartnerType,
  bp_ag AS AgentType,
  pord_out AS PaymentOrderOutputType,
  gtd_out AS ImprtCstmsDeclnIsRead,
  mrec_dt_out AS MatlRcptDateIsRead,
  buyer AS RU_CustomerOutputType,
  sellerag AS RU_SupplierAgentOutputType,
  seller AS RU_SupplierOutputType,
  subagent AS RU_SubagentOutputType,
  dealtype AS SalesDealType,
  opc_type AS RU_OrgOperationType,
  opc_tpin AS RU_PersonOperationType,
  sel_inv_out AS RU_InvoiceSupplierOutputType,
  buy_inv_out AS RU_InvoiceCustomerOutputType
FROM firud_vatsubas
;

Learn More