I_IN_InputSrvcDistrBasic

DDL: I_IN_INPUTSRVCDISTRBASIC SQL: IININPSRVDISTR Type: view BASIC Package: GLO_LOG_IN
26 Fields 1 Data Sources

Input Service Distribution Basic CDS

I_IN_InputSrvcDistrBasic (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Country or Region-Specific Functions for Finance

I_IN_InputSrvcDistrBasic is a Basic CDS View that provides data about "Input Service Distribution Basic CDS" in SAP S/4HANA. It reads from 1 data source (j_1ig_isd_distr) and exposes 26 fields with key fields AccountingDocument, AccountingDocumentType, AccountingDocumentItem, FiscalYear, CompanyCode. Part of development package GLO_LOG_IN.

SAP API Hub

CategoryBasic
StateC1
Line of BusinessCountry or Region-Specific Functions for Finance
Application ComponentFI-LOC-LO-IN
CapabilitiesData Source in SQL Select,Data Source for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageCountry/Region-Specific Functions for Finance for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view provides the complete list of ISD invoices and it's credit note distribution data.</p> <ul> <li><p>What are the ISD invoices distributed under the company code?</p></li> <li><p>What are the input service distribution business places where input tax credit is distributed for an ISD invoice?</p></li> <li><p>What are the taxes applied for ISD invoices?</p></li> <li><p>When is the ISD invoice posted in system?</p></li> <li><p>For which ISD invoice a credit note is created and distributed?</p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
j_1ig_isd_distr j_1ig_isd_distr from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IININPSRVDISTR view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XXL view
VDM.viewType #BASIC view
EndUserText.label Input Service Distribution Basic CDS view
Metadata.ignorePropagatedAnnotations true view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY AccountingDocument belnr Document Number of an Accounting Document
KEY AccountingDocumentType blart Rep. rec. doc. type
KEY AccountingDocumentItem buzei Number of Line Item Within Accounting Document
KEY FiscalYear gjahr Settlement Year
KEY CompanyCode bukrs Company Code
KEY InputServiceDistrBusPlace isd_bupla Business Place
KEY ReceivingBusPlace rec_bupla Business Place
CntrlGST isd_cgst Tax Amount in Document Currency
StateGST isd_sgst Tax Amount in Document Currency
UnionTerritoryGST isd_ugst Tax Amount in Document Currency
IntegratedGST isd_igst Tax Amount in Document Currency
InputServiceDistrTaxCESS isd_cess Tax Amount in Document Currency
ReceivingBusPlaceCentralGST rec_cgst Tax Amount in Document Currency
ReceivingBusPlaceStateGST rec_sgst Tax Amount in Document Currency
ReceivingBusPlaceUnionGST rec_ugst Tax Amount in Document Currency
ReceivingBusPlaceIntegratedGST rec_igst Tax Amount in Document Currency
ReceivingBusPlaceCESS rec_cess Tax Amount in Document Currency
TaxCode isd_mwskz Tax on Sales/Purchases Code
Currency waers Transaction Currency
PostingDate budat Posting Date in the Document
ReceivingAccountingDocument rec_belnr Document Number of an Accounting Document
IN_HSNOrSACCode hsn_sac HSN or SAC Code
TaxIsNotDeductible non_deduct Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
IN_InptSrvcDistrDocType doc_type GST IN: Type of Document (Invoice/Credit Memo)
IN_InptSrvcDistrInvc isd_invoice ISD Invoice Document Number
IN_InptSrvcDistrInvcFsclYr isd_invoice_gjahr ISD Invoice Fiscal Year

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_InputSrvcDistrBasic.
-- 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: IININPSRVDISTR

CREATE VIEW I_IN_InputSrvcDistrBasic AS
SELECT
  belnr AS AccountingDocument,
  blart AS AccountingDocumentType,
  buzei AS AccountingDocumentItem,
  gjahr AS FiscalYear,
  bukrs AS CompanyCode,
  isd_bupla AS InputServiceDistrBusPlace,
  rec_bupla AS ReceivingBusPlace,
  isd_cgst AS CntrlGST,
  isd_sgst AS StateGST,
  isd_ugst AS UnionTerritoryGST,
  isd_igst AS IntegratedGST,
  isd_cess AS InputServiceDistrTaxCESS,
  rec_cgst AS ReceivingBusPlaceCentralGST,
  rec_sgst AS ReceivingBusPlaceStateGST,
  rec_ugst AS ReceivingBusPlaceUnionGST,
  rec_igst AS ReceivingBusPlaceIntegratedGST,
  rec_cess AS ReceivingBusPlaceCESS,
  isd_mwskz AS TaxCode,
  waers AS Currency,
  budat AS PostingDate,
  rec_belnr AS ReceivingAccountingDocument,
  hsn_sac AS IN_HSNOrSACCode,
  non_deduct AS TaxIsNotDeductible,
  doc_type AS IN_InptSrvcDistrDocType,
  isd_invoice AS IN_InptSrvcDistrInvc,
  isd_invoice_gjahr AS IN_InptSrvcDistrInvcFsclYr
FROM j_1ig_isd_distr
;

Learn More