C_PRATstCombinedTaxDets

DDL: C_PRATSTCOMBINEDTAXDETS SQL: CPRATSTCTAX Type: view CONSUMPTION Package: OIU_TV
35 Fields 1 Data Sources 1 Associations

TV - Combine Run Tax - Detailed View

C_PRATstCombinedTaxDets is a Consumption CDS View that provides data about "TV - Combine Run Tax - Detailed View" in SAP S/4HANA. It reads from 1 data source (I_PRATstCombinedTaxCompareUI) and exposes 35 fields with key fields CurrentValnDocument, CurrentValnDocumentYear, DeliveryNetwork, SalesDate, Well. It has 1 association to related views. Part of development package OIU_TV.

Data Sources (1)

SourceAliasJoin Type
I_PRATstCombinedTaxCompareUI I_PRATstCombinedTaxCompareUI from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_PRATstValnRsltsHdr _Header $projection.CurrentValnDocument = _Header.CurrentValnDocument and $projection.CurrentValnDocumentYear = _Header.CurrentValnDocumentYear and $projection.CombinedHdrSqncNumber = _Header.CombinedHdrSqncNumber

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CPRATSTCTAX view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label TV - Combine Run Tax - Detailed View view
AbapCatalog.dataMaintenance #DISPLAY_ONLY view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY CurrentValnDocument CurrentValnDocument DocNr
KEY CurrentValnDocumentYear CurrentValnDocumentYear Document year
KEY DeliveryNetwork DeliveryNetwork Delivery network ID
KEY SalesDate SalesDate Sales Date
KEY Well Well Well
KEY WellCompletion WellCompletion Well Completion
KEY OriginatingMeasurementPt OriginatingMeasurementPt
KEY PRAJointVenture PRAJointVenture Ext vent name
KEY DivisionOfInterest DivisionOfInterest Venture/DOI
KEY PRAContract PRAContract Contract
KEY Material Material Vehicle Model
KEY SeveranceTaxType SeveranceTaxType
KEY CombinedHdrSqncNumber CombinedHdrSqncNumber
CompanyCodeCurrency CompanyCodeCurrency Local Currency
DeliveryNetworkName _Header DeliveryNetworkName
CombinedTaxStsCritlty _Header CombinedTaxStsCritlty
CombinedTaxStatusText _Header CombinedTaxStatusText
ActualStateTaxStsCritlty ActualStateTaxStsCritlty
ActualStateTaxAmount ActualStateTaxAmount
BaselineActualStateTaxAmt BaselineActualStateTaxAmt
EntitledStateTaxStsCritlty EntitledStateTaxStsCritlty
EntitledStateTaxAmount EntitledStateTaxAmount
BaselineEntitledStateTaxAmt BaselineEntitledStateTaxAmt
ActlStateTaxReimbmtStsCritlty ActlStateTaxReimbmtStsCritlty
ActualStateTaxReimbmtAmt ActualStateTaxReimbmtAmt
BslnActlTaxReimbmtAmt BslnActlTaxReimbmtAmt
EntitledTaxReimbmtStsCritlty EntitledTaxReimbmtStsCritlty
EntitledStateTaxReimbmtAmt EntitledStateTaxReimbmtAmt
BslnEntitledTaxReimbmtAmt BslnEntitledTaxReimbmtAmt
ActlGrssStateTaxStsCritlty ActlGrssStateTaxStsCritlty
ActualGrossStateTaxAmt ActualGrossStateTaxAmt
BaselineActlGrssStateTaxAmt BaselineActlGrssStateTaxAmt
EntldGrssStateTaxStsCritlty EntldGrssStateTaxStsCritlty
EntitledGrossStateTaxAmt EntitledGrossStateTaxAmt
BaselineEntldGrssStateTaxAmt BaselineEntldGrssStateTaxAmt

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 C_PRATstCombinedTaxDets.
-- 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: CPRATSTCTAX

CREATE VIEW C_PRATstCombinedTaxDets AS
SELECT
  CurrentValnDocument,
  CurrentValnDocumentYear,
  DeliveryNetwork,
  SalesDate,
  Well,
  WellCompletion,
  OriginatingMeasurementPt,
  PRAJointVenture,
  DivisionOfInterest,
  PRAContract,
  Material,
  SeveranceTaxType,
  CombinedHdrSqncNumber,
  CompanyCodeCurrency,
  _Header.DeliveryNetworkName AS DeliveryNetworkName,
  _Header.CombinedTaxStsCritlty AS CombinedTaxStsCritlty,
  _Header.CombinedTaxStatusText AS CombinedTaxStatusText,
  ActualStateTaxStsCritlty,
  ActualStateTaxAmount,
  BaselineActualStateTaxAmt,
  EntitledStateTaxStsCritlty,
  EntitledStateTaxAmount,
  BaselineEntitledStateTaxAmt,
  ActlStateTaxReimbmtStsCritlty,
  ActualStateTaxReimbmtAmt,
  BslnActlTaxReimbmtAmt,
  EntitledTaxReimbmtStsCritlty,
  EntitledStateTaxReimbmtAmt,
  BslnEntitledTaxReimbmtAmt,
  ActlGrssStateTaxStsCritlty,
  ActualGrossStateTaxAmt,
  BaselineActlGrssStateTaxAmt,
  EntldGrssStateTaxStsCritlty,
  EntitledGrossStateTaxAmt,
  BaselineEntldGrssStateTaxAmt
FROM I_PRATstCombinedTaxCompareUI
LEFT OUTER JOIN I_PRATstValnRsltsHdr AS _Header ON CurrentValnDocument = _Header.CurrentValnDocument AND CurrentValnDocumentYear = _Header.CurrentValnDocumentYear AND CombinedHdrSqncNumber = _Header.CombinedHdrSqncNumber  -- association [1..1]
;

Learn More