I_SrvcOrdBillgDelayedSituation

DDL: I_SRVCORDBILLGDELAYEDSITUATION SQL: ISRVCINVSO Type: view COMPOSITE
37 Fields 2 Data Sources

Service Order not invoiced situation

I_SrvcOrdBillgDelayedSituation is a Composite CDS View that provides data about "Service Order not invoiced situation" in SAP S/4HANA. It reads from 2 data sources (I_BillingDocument, I_ServiceDocumentItem) and exposes 37 fields with key fields ServiceObjectType, ServiceOrder, ServiceDocumentItem, ServiceDocumentItemUUID, BillingDocument.

Data Sources (2)

SourceAliasJoin Type
I_BillingDocument BillingHeader inner
I_ServiceDocumentItem SrvcItem from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ISRVCINVSO view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Service Order not invoiced situation view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY ServiceObjectType I_ServiceDocumentItem ServiceObjectType Object Type
KEY ServiceOrder I_ServiceDocumentItem ServiceDocument Transaction ID
KEY ServiceDocumentItem I_ServiceDocumentItem ServiceDocumentItem Item Number in Service Order
KEY ServiceDocumentItemUUID I_ServiceDocumentItem ServiceDocumentItemUUID Push ItemGU
KEY BillingDocument I_BillingDocument BillingDocument SD Document
KEY BillingDocumentItem _Item BillingDocumentItem Item
ServiceDocumentUUID
ServiceDocumentType ServiceDocumentType Transaction Type
SoldToParty
SalesOrganization I_ServiceDocumentItem SalesOrganization Sales Organization
DistributionChannel I_ServiceDocumentItem DistributionChannel RefDistCh-Cust/Mat.
Division I_ServiceDocumentItem Division Internal Division ID
SalesOffice I_ServiceDocumentItem SalesOffice Sales Office
SalesGroup I_ServiceDocumentItem SalesGroup Sales Group
ResponsibleEmployeeUserID RespEmployeeUser UserID User Name
ServiceDocumentCreatedByUser
BillingIssueType I_BillingDocument BillingIssueType
TotalNetAmount I_BillingDocument TotalNetAmount Total Net Amount
TransactionCurrency I_BillingDocument TransactionCurrency Transaction Currency
AccountingPostingStatus I_BillingDocument AccountingPostingStatus
InvoiceClearingStatus I_BillingDocument InvoiceClearingStatus
ServiceDocItemCategory I_ServiceDocumentItem ServiceDocItemCategory Item Category
NrOfDaysAfterCreationDate Days After Billing Document Creation
OverallBillingStatus I_BillingDocument OverallBillingStatus
BillingDocumentIsTemporary I_BillingDocument BillingDocumentIsTemporary
ResponsibleEmployee I_ServiceDocumentItem ResponsibleEmployee Employee Resp.
SalesOrganizationOrgUnitID I_ServiceDocumentItem SalesOrganizationOrgUnitID
SalesOfficeOrgUnitID I_ServiceDocumentItem SalesOfficeOrgUnitID
SalesGroupOrgUnitID I_ServiceDocumentItem SalesGroupOrgUnitID
ServiceOrganization I_ServiceDocumentItem ServiceOrganization
BillingDocumentType I_BillingDocument BillingDocumentType Billing Type
_ServiceObjType I_ServiceDocumentItem _ServiceObjType
_ServiceDocument I_ServiceDocumentItem _ServiceDocument
_ServiceDocItemCategory I_ServiceDocumentItem _ServiceDocItemCategory
_ServiceDocumentType I_ServiceDocumentItem _ServiceDocumentType
_OverallBillingStatus I_BillingDocument _OverallBillingStatus
_TransactionCurrency I_BillingDocument _TransactionCurrency

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_SrvcOrdBillgDelayedSituation.
-- 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: ISRVCINVSO

CREATE VIEW I_SrvcOrdBillgDelayedSituation AS
SELECT
  SrvcItem.ServiceObjectType AS ServiceObjectType,
  SrvcItem.ServiceDocument AS ServiceOrder,
  SrvcItem.ServiceDocumentItem AS ServiceDocumentItem,
  SrvcItem.ServiceDocumentItemUUID AS ServiceDocumentItemUUID,
  BillingHeader.BillingDocument AS BillingDocument,
  _Item.BillingDocumentItem AS BillingDocumentItem,
  SrvcItem._ServiceDocument.ServiceDocumentUUID AS ServiceDocumentUUID,
  ServiceDocumentType,
  SrvcItem._ServiceDocument.SoldToParty AS SoldToParty,
  SrvcItem.SalesOrganization AS SalesOrganization,
  SrvcItem.DistributionChannel AS DistributionChannel,
  SrvcItem.Division AS Division,
  SrvcItem.SalesOffice AS SalesOffice,
  SrvcItem.SalesGroup AS SalesGroup,
  RespEmployeeUser.UserID AS ResponsibleEmployeeUserID,
  SrvcItem._ServiceDocument.ServiceDocumentCreatedByUser AS ServiceDocumentCreatedByUser,
  BillingHeader.BillingIssueType AS BillingIssueType,
  BillingHeader.TotalNetAmount AS TotalNetAmount,
  BillingHeader.TransactionCurrency AS TransactionCurrency,
  BillingHeader.AccountingPostingStatus AS AccountingPostingStatus,
  BillingHeader.InvoiceClearingStatus AS InvoiceClearingStatus,
  SrvcItem.ServiceDocItemCategory AS ServiceDocItemCategory,
  cast(Dats_Days_Between( BillingHeader.BillingDocumentDate, cast($session.system_date as dats) ) as crms4_billing_date ) AS NrOfDaysAfterCreationDate,
  BillingHeader.OverallBillingStatus AS OverallBillingStatus,
  BillingHeader.BillingDocumentIsTemporary AS BillingDocumentIsTemporary,
  SrvcItem.ResponsibleEmployee AS ResponsibleEmployee,
  SrvcItem.SalesOrganizationOrgUnitID AS SalesOrganizationOrgUnitID,
  SrvcItem.SalesOfficeOrgUnitID AS SalesOfficeOrgUnitID,
  SrvcItem.SalesGroupOrgUnitID AS SalesGroupOrgUnitID,
  SrvcItem.ServiceOrganization AS ServiceOrganization,
  BillingHeader.BillingDocumentType AS BillingDocumentType,
  SrvcItem._ServiceObjType AS _ServiceObjType,
  SrvcItem._ServiceDocument AS _ServiceDocument,
  SrvcItem._ServiceDocItemCategory AS _ServiceDocItemCategory,
  SrvcItem._ServiceDocumentType AS _ServiceDocumentType,
  BillingHeader._OverallBillingStatus AS _OverallBillingStatus,
  BillingHeader._TransactionCurrency AS _TransactionCurrency
FROM I_ServiceDocumentItem AS SrvcItem
INNER JOIN I_BillingDocument AS BillingHeader ON /* join condition not captured in parsed metadata */
;

Learn More