I_IN_InptSrvcDistr

DDL: I_IN_INPTSRVCDISTR SQL: IINISD Type: view COMPOSITE
16 Fields 1 Data Sources

I view for Input Service Distribution

I_IN_InptSrvcDistr is a Composite CDS View that provides data about "I view for Input Service Distribution" in SAP S/4HANA. It reads from 1 data source (I_IN_InputSrvcDistrBasic) and exposes 16 fields with key fields AccountingDocument, DocumentType, AccountingDocumentItem, FiscalYear, CompanyCode.

Data Sources (1)

SourceAliasJoin Type
I_IN_InputSrvcDistrBasic I_IN_InputSrvcDistrBasic from

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName IINISD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
VDM.viewType #COMPOSITE view
EndUserText.label I view for Input Service Distribution view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY AccountingDocument AccountingDocument Journal Entry
KEY DocumentType AccountingDocumentType Journal Entry Type
KEY AccountingDocumentItem AccountingDocumentItem Posting View Item
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY CompanyCode CompanyCode Receiver Company Code
InputServiceDistrBusPlace InputServiceDistrBusPlace ISD BUPLA
ReceivingBusPlace ReceivingBusPlace REC BUPLA
CntrlGST CntrlGST Amount
StateGST StateGST Amount
UnionTerritoryGST UnionTerritoryGST Amount
IntegratedGST IntegratedGST Amount
InputServiceDistrTaxCESS InputServiceDistrTaxCESS Amount
TotalTaxAmount
Currency Currency Valuation Crcy
PostingDate PostingDate Posting Date for GR
ReceivingAccountingDocument ReceivingAccountingDocument Document Number

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_IN_InptSrvcDistr.
-- 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: IINISD

CREATE VIEW I_IN_InptSrvcDistr AS
SELECT
  AccountingDocument,
  AccountingDocumentType AS DocumentType,
  AccountingDocumentItem,
  FiscalYear,
  CompanyCode,
  InputServiceDistrBusPlace,
  ReceivingBusPlace,
  CntrlGST,
  StateGST,
  UnionTerritoryGST,
  IntegratedGST,
  InputServiceDistrTaxCESS,
  (CntrlGST+CntrlGST+UnionTerritoryGST+IntegratedGST+InputServiceDistrTaxCESS) AS TotalTaxAmount,
  Currency,
  PostingDate,
  ReceivingAccountingDocument
FROM I_IN_InputSrvcDistrBasic
;

Learn More