C_IN_ServiceDistrOvwQ

DDL: C_IN_SERVICEDISTROVWQ SQL: CINISDOVWQRY Type: view CONSUMPTION

ISD Overview

C_IN_ServiceDistrOvwQ is a Consumption CDS View that provides data about "ISD Overview" in SAP S/4HANA. It reads from 1 data source (C_IN_InputServiceDistrCube) and exposes 22 fields.

Data Sources (1)

SourceAliasJoin Type
C_IN_InputServiceDistrCube C_IN_InputServiceDistrCube from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CINISDOVWQRY view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
VDM.viewType #CONSUMPTION view
OData.publish true view
EndUserText.label ISD Overview view

Fields (22)

KeyFieldSource TableSource FieldDescription
AccountingDocument AccountingDocument Invoice Number
DocumentType DocumentType Document Type
AccountingDocumentItem AccountingDocumentItem Accounting Document Item
FiscalYear FiscalYear Fiscal Year
CompanyCode CompanyCode Company Code
InputServiceDistrBusPlace InputServiceDistrBusPlace Sending Business Place
ReceivingBusPlace ReceivingBusPlace Recieving Business Place
CntrlGST CntrlGST CGST
StateGST StateGST SGST
UnionTerritoryGST UnionTerritoryGST UGST
IntegratedGST IntegratedGST IGST
InputServiceDistrTaxCESS InputServiceDistrTaxCESS CESS
ReceivingBusPlaceCentralGST ReceivingBusPlaceCentralGST CGST Due
ReceivingBusPlaceStateGST ReceivingBusPlaceStateGST SGST Due
ReceivingBusPlaceUnionGST ReceivingBusPlaceUnionGST UGST Due
ReceivingBusPlaceIntegratedGST ReceivingBusPlaceIntegratedGST IGST Due
ReceivingBusPlaceCESS ReceivingBusPlaceCESS CESS Due
TotalTaxAmount TotalTaxAmount Total tax amount
TaxAmountDue TaxAmountDue Tax to be Distributed
TaxAmountDistributed TaxAmountDistributed Tax Already Distributed
Currency Currency Currency
NumberOfDocuments NumberOfDocuments Number of Documents

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_IN_ServiceDistrOvwQ.
-- 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: CINISDOVWQRY

CREATE VIEW C_IN_ServiceDistrOvwQ AS
SELECT
  AccountingDocument,
  DocumentType,
  AccountingDocumentItem,
  FiscalYear,
  CompanyCode,
  InputServiceDistrBusPlace,
  ReceivingBusPlace,
  CntrlGST,
  StateGST,
  UnionTerritoryGST,
  IntegratedGST,
  InputServiceDistrTaxCESS,
  ReceivingBusPlaceCentralGST,
  ReceivingBusPlaceStateGST,
  ReceivingBusPlaceUnionGST,
  ReceivingBusPlaceIntegratedGST,
  ReceivingBusPlaceCESS,
  TotalTaxAmount,
  TaxAmountDue,
  TaxAmountDistributed,
  Currency,
  NumberOfDocuments
FROM C_IN_InputServiceDistrCube
;