I_UtilitiesSimulatorHeaderTP

DDL: I_UTILITIESSIMULATORHEADERTP SQL: ISIMHEADERTBR Type: view TRANSACTIONAL
13 Fields 2 Data Sources

ISU BR Bill Sim Header - TP

I_UtilitiesSimulatorHeaderTP is a Transactional CDS View that provides data about "ISU BR Bill Sim Header - TP" in SAP S/4HANA. It reads from 2 data sources (I_UtilitiesSimulatorHeader, I_UtilitiesSingleItemTP) and exposes 13 fields with key fields ISU_BR_SimulationScenario, ISU_BR_BillingOriglPrintDoc, ISU_BR_BillingSimulatedPrntDoc.

Data Sources (2)

SourceAliasJoin Type
I_UtilitiesSimulatorHeader Header from
I_UtilitiesSingleItemTP Itemline inner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ISIMHEADERTBR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #X view
VDM.viewType #TRANSACTIONAL view
EndUserText.label ISU BR Bill Sim Header - TP view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY ISU_BR_SimulationScenario I_UtilitiesSimulatorHeader ISU_BR_SimulationScenario
KEY ISU_BR_BillingOriglPrintDoc I_UtilitiesSimulatorHeader ISU_BR_BillingOriglPrintDoc
KEY ISU_BR_BillingSimulatedPrntDoc I_UtilitiesSimulatorHeader ISU_BR_BillingSimulatedPrntDoc
UtilitiesBillingDocument I_UtilitiesSingleItemTP UtilitiesBillingDocument
UtilsBillgDocCreationDate I_UtilitiesSimulatorHeader UtilsBillgDocCreationDate
ISU_BR_ContractAcctPostgStatus I_UtilitiesSimulatorHeader ISU_BR_ContractAcctPostgStatus
ISU_BR_PostStatusDescription I_UtilitiesSimulatorHeader ISU_BR_PostStatusDescription
UtilitiesInstallation I_UtilitiesSingleItemTP UtilitiesInstallation
UtilitiesContract I_UtilitiesSingleItemTP UtilitiesContract
BusinessPartner I_UtilitiesSingleItemTP BusinessPartner Issuing Authority
ISU_BR_BillgPeriodStartDate I_UtilitiesSingleItemTP ISU_BR_BillgPeriodStartDate
ISU_BR_BillingPeriodEndDate I_UtilitiesSingleItemTP ISU_BR_BillingPeriodEndDate
CAAuthorizationGroup CAAuthorizationGroup AuthorizGroup

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_UtilitiesSimulatorHeaderTP.
-- 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: ISIMHEADERTBR

CREATE VIEW I_UtilitiesSimulatorHeaderTP AS
SELECT
  Header.ISU_BR_SimulationScenario AS ISU_BR_SimulationScenario,
  Header.ISU_BR_BillingOriglPrintDoc AS ISU_BR_BillingOriglPrintDoc,
  Header.ISU_BR_BillingSimulatedPrntDoc AS ISU_BR_BillingSimulatedPrntDoc,
  Itemline.UtilitiesBillingDocument AS UtilitiesBillingDocument,
  Header.UtilsBillgDocCreationDate AS UtilsBillgDocCreationDate,
  Header.ISU_BR_ContractAcctPostgStatus AS ISU_BR_ContractAcctPostgStatus,
  Header.ISU_BR_PostStatusDescription AS ISU_BR_PostStatusDescription,
  Itemline.UtilitiesInstallation AS UtilitiesInstallation,
  Itemline.UtilitiesContract AS UtilitiesContract,
  Itemline.BusinessPartner AS BusinessPartner,
  Itemline.ISU_BR_BillgPeriodStartDate AS ISU_BR_BillgPeriodStartDate,
  Itemline.ISU_BR_BillingPeriodEndDate AS ISU_BR_BillingPeriodEndDate,
  CAAuthorizationGroup
FROM I_UtilitiesSimulatorHeader AS Header
INNER JOIN I_UtilitiesSingleItemTP AS Itemline ON /* join condition not captured in parsed metadata */
;

Learn More