I_PRAMaintStateTaxExempt

DDL: I_PRAMAINTSTATETAXEXEMPT Type: view BASIC
16 Fields 2 Data Sources 2 Associations

Maintain State Tax Exemption XI

I_PRAMaintStateTaxExempt is a Basic CDS View that provides data about "Maintain State Tax Exemption XI" in SAP S/4HANA. It reads from 2 data sources (oiu_do_do, oiu_do_doex) and exposes 16 fields with key fields CompanyCode, PRAJointVenture, DivisionOfInterest, PRACustomerSupplierCode, PRAOwner. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
oiu_do_do oiu_do_do inner
oiu_do_doex oiu_do_doex from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_MajorProduct _MajorProduct $projection.MajorProduct = _MajorProduct.MajorProduct
[1..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode

Annotations (11)

NameValueLevelField
EndUserText.label Maintain State Tax Exemption XI view
AbapCatalog.sqlViewName IPRADOEX view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode oiu_do_do bukrs Value
KEY PRAJointVenture oiu_do_do vname Volatility Name
KEY DivisionOfInterest oiu_do_do doi_no Venture/DOI
KEY PRACustomerSupplierCode oiu_do_do cust_vend_cd Ocust vend cd
KEY PRAOwner oiu_do_do own_no Owner Number
KEY OwnerInterestType oiu_do_do own_int_type_cd Opart int type
KEY OwnerInterestSequence oiu_do_do own_isq_no Own. ISQ
KEY DOIOwnerEffectiveFromDate oiu_do_do eff_from_dt Effective From Date
KEY PRADivisionOfInterestNmbr oiu_do_doex oiu_do_no Div.int.no
KEY MajorProduct oiu_do_doex majpd_cd Major Product
DOIOwnerIsExempt oiu_do_doex strip_ex_fl Str Ex St Whld Fl
CreatedByUser oiu_do_doex oiu_cruser Created By
CreationDateTime oiu_do_doex oiu_timestamp Timestamp
_PRAMaintDOIOwner _PRAMaintDOIOwner
_MajorProduct _MajorProduct
_CompanyCode _CompanyCode

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 I_PRAMaintStateTaxExempt.
-- 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.

CREATE VIEW I_PRAMaintStateTaxExempt AS
SELECT
  oiu_do_do.bukrs AS CompanyCode,
  oiu_do_do.vname AS PRAJointVenture,
  oiu_do_do.doi_no AS DivisionOfInterest,
  oiu_do_do.cust_vend_cd AS PRACustomerSupplierCode,
  oiu_do_do.own_no AS PRAOwner,
  oiu_do_do.own_int_type_cd AS OwnerInterestType,
  oiu_do_do.own_isq_no AS OwnerInterestSequence,
  oiu_do_do.eff_from_dt AS DOIOwnerEffectiveFromDate,
  oiu_do_doex.oiu_do_no AS PRADivisionOfInterestNmbr,
  oiu_do_doex.majpd_cd AS MajorProduct,
  oiu_do_doex.strip_ex_fl AS DOIOwnerIsExempt,
  oiu_do_doex.oiu_cruser AS CreatedByUser,
  oiu_do_doex.oiu_timestamp AS CreationDateTime
FROM oiu_do_doex
INNER JOIN oiu_do_do ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MajorProduct AS _MajorProduct ON MajorProduct = _MajorProduct.MajorProduct  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
;

Learn More