C_UtilitiesSimulatorItem

DDL: C_UTILITIESSIMULATORITEM SQL: CSIMITEMBR Type: view CONSUMPTION
35 Fields 1 Data Sources

IS-U-BR Bill.Sim: Simulated Document Item - Consumpt

C_UtilitiesSimulatorItem is a Consumption CDS View that provides data about "IS-U-BR Bill.Sim: Simulated Document Item - Consumpt" in SAP S/4HANA. It reads from 1 data source (I_UtilitiesSimulatorItemTP) and exposes 35 fields with key fields ISU_BR_SimulationScenario, UtilitiesBillingDocument, ISU_BR_BillingOriglPrintDoc, ISU_BR_BillingSimulatedPrntDoc, ISU_BR_SequentialItemNumber.

Data Sources (1)

SourceAliasJoin Type
I_UtilitiesSimulatorItemTP I_UtilitiesSimulatorItemTP from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CSIMITEMBR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label IS-U-BR Bill.Sim: Simulated Document Item - Consumpt view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #X view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
UI.headerInfo.typeName Item Information view
UI.headerInfo.typeNamePlural Items Information view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY ISU_BR_SimulationScenario ISU_BR_SimulationScenario Scenario Id
KEY UtilitiesBillingDocument UtilitiesBillingDocument Billing Document Number
KEY ISU_BR_BillingOriglPrintDoc ISU_BR_BillingOriglPrintDoc Original Print Document
KEY ISU_BR_BillingSimulatedPrntDoc ISU_BR_BillingSimulatedPrntDoc Simulated Print Document
KEY ISU_BR_SequentialItemNumber ISU_BR_SequentialItemNumber
PostingDate PostingDate Posting Date for GR
UtilitiesInstallation UtilitiesInstallation
UtilitiesContract UtilitiesContract
BusinessPartner BusinessPartner Issuing Authority
ISU_BR_BillgPeriodStartDate ISU_BR_BillgPeriodStartDate Start Period Calculation
ISU_BR_BillingPeriodEndDate ISU_BR_BillingPeriodEndDate End Period Calculation
ISU_BR_BillgDocLineItmTypeFrom ISU_BR_BillgDocLineItmTypeFrom
ISU_BR_TransactionKeyFrom ISU_BR_TransactionKeyFrom
OriginalCostCriticality OriginalCostCriticality
ISU_BR_BillgDocLineItmTypeTo ISU_BR_BillgDocLineItmTypeTo
ISU_BR_TransactionKeyTo ISU_BR_TransactionKeyTo
ISU_BR_BillingSimulatedNetAmt ISU_BR_BillingSimulatedNetAmt Simulated Net Amount
ActualCostCriticality ActualCostCriticality
ISU_BR_BillingDiffNetAmount ISU_BR_BillingDiffNetAmount Difference Amount
TotalCostCriticality TotalCostCriticality
ISU_BR_RejectStatusDescription ISU_BR_RejectStatusDescription Status
PostingStatusCriticality PostingStatusCriticality
ISU_BR_ContractRejectStatus ISU_BR_ContractRejectStatus
CAPostingDocument CAPostingDocument
ISU_BR_PostStatusDescription ISU_BR_PostStatusDescription FI-CA Posting Status
ISU_BR_ContractAcctPostgStatus ISU_BR_ContractAcctPostgStatus
ISU_BR_PreSortingItemFrom ISU_BR_PreSortingItemFrom Presort Billing Item From
ISU_BR_PreSortingItemTo ISU_BR_PreSortingItemTo Presort Billing Item To
ISU_BR_MainTransactionFrom ISU_BR_MainTransactionFrom Main Transaction From
ISU_BR_MainTransactionTo ISU_BR_MainTransactionTo Main Transaction To
ISU_BR_SubTransactionFrom ISU_BR_SubTransactionFrom Billing Subtransaction From
ISU_BR_SubTransactionTo ISU_BR_SubTransactionTo Billing Subtransaction To
ISU_BR_UtilitiesCurrency ISU_BR_UtilitiesCurrency
ISU_BR_UtilitiesDocumentType ISU_BR_UtilitiesDocumentType Document Type
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 C_UtilitiesSimulatorItem.
-- 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: CSIMITEMBR

CREATE VIEW C_UtilitiesSimulatorItem AS
SELECT
  ISU_BR_SimulationScenario,
  UtilitiesBillingDocument,
  ISU_BR_BillingOriglPrintDoc,
  ISU_BR_BillingSimulatedPrntDoc,
  ISU_BR_SequentialItemNumber,
  PostingDate,
  UtilitiesInstallation,
  UtilitiesContract,
  BusinessPartner,
  ISU_BR_BillgPeriodStartDate,
  ISU_BR_BillingPeriodEndDate,
  ISU_BR_BillgDocLineItmTypeFrom,
  ISU_BR_TransactionKeyFrom,
  OriginalCostCriticality,
  ISU_BR_BillgDocLineItmTypeTo,
  ISU_BR_TransactionKeyTo,
  ISU_BR_BillingSimulatedNetAmt,
  ActualCostCriticality,
  ISU_BR_BillingDiffNetAmount,
  TotalCostCriticality,
  ISU_BR_RejectStatusDescription,
  PostingStatusCriticality,
  ISU_BR_ContractRejectStatus,
  CAPostingDocument,
  ISU_BR_PostStatusDescription,
  ISU_BR_ContractAcctPostgStatus,
  ISU_BR_PreSortingItemFrom,
  ISU_BR_PreSortingItemTo,
  ISU_BR_MainTransactionFrom,
  ISU_BR_MainTransactionTo,
  ISU_BR_SubTransactionFrom,
  ISU_BR_SubTransactionTo,
  ISU_BR_UtilitiesCurrency,
  ISU_BR_UtilitiesDocumentType,
  CAAuthorizationGroup
FROM I_UtilitiesSimulatorItemTP
;

Learn More