P_AU_StRpPTRParams

DDL: P_AU_STRPPTRPARAMS SQL: PAUSRPTRPARAMS Type: view COMPOSITE
23 Fields 3 Data Sources

AU PTR Reporting Parameters

P_AU_StRpPTRParams is a Composite CDS View that provides data about "AU PTR Reporting Parameters" in SAP S/4HANA. It reads from 3 data sources (srf_rpg_cat4, srf_rpg_cat4, srf_rpg_cat4) and exposes 23 fields with key fields ReportingEntity, RepCatId, ParName, ParValidFrom, SequenceNumber.

Data Sources (3)

SourceAliasJoin Type
srf_rpg_cat4 srf_rpg_cat4 from
srf_rpg_cat4 srf_rpg_cat4 union
srf_rpg_cat4 srf_rpg_cat4 union

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PAUSRPTRPARAMS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label AU PTR Reporting Parameters view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY ReportingEntity reporting_entity Reporting Entity
KEY RepCatId rep_cat_id Report ID
KEY ParName par_name Parameter name
KEY ParValidFrom par_valid_from Valid From
KEY SequenceNumber sequence_number Sort Sequence
Sign sign Type of SIGN component in row type of a Ranges type
AccountingDocumentType Param. Value
SupplierAccountGroup Param. Value
KEY RepCatId rep_cat_id Report ID
KEY ParName par_name Parameter name
KEY ParValidFrom par_valid_from Valid From
KEY SequenceNumber sequence_number Sort Sequence
Sign sign Type of SIGN component in row type of a Ranges type
AccountingDocumentType Param. Value
SupplierAccountGroup Param. Value
KEY RepCatId rep_cat_id Report ID
KEY ParName par_name Parameter name
KEY ParValidFrom par_valid_from Valid From
KEY SequenceNumber sequence_number Sort Sequence
Sign sign Type of SIGN component in row type of a Ranges type
AccountingDocumentType Param. Value
SupplierAccountGroup Param. Value
InterCompanyExclIndicator

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_AU_StRpPTRParams.
-- 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: PAUSRPTRPARAMS

CREATE VIEW P_AU_StRpPTRParams AS
SELECT
  reporting_entity AS ReportingEntity,
  rep_cat_id AS RepCatId,
  par_name AS ParName,
  par_valid_from AS ParValidFrom,
  sequence_number AS SequenceNumber,
  Sign,
  cast(par_value as blart) AS AccountingDocumentType,
  cast('' as ktokk) AS SupplierAccountGroup,
  cast(upper(par_value) as char1) AS InterCompanyExclIndicator
FROM srf_rpg_cat4
-- UNION with additional select branch(es): srf_rpg_cat4
;

Learn More