I_IN_GSTR6CalcDistrAmtCube

DDL: I_IN_GSTR6CALCDISTRAMTCUBE Type: view_entity COMPOSITE
8 Fields 1 Data Sources

Calculate Distr Credit Amt - Cube

I_IN_GSTR6CalcDistrAmtCube is a Composite CDS View (Cube) that provides data about "Calculate Distr Credit Amt - Cube" in SAP S/4HANA. It reads from 1 data source (I_IN_GSTR6DistrInvoiceCube) and exposes 8 fields with key fields ElectronicDocUUID, ElectronicDocCompanyCode, InputServiceDistrBusPlace.

Data Sources (1)

SourceAliasJoin Type
I_IN_GSTR6DistrInvoiceCube _DistrInv from

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Calculate Distr Credit Amt - Cube view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
Metadata.allowExtensions true view
Analytics.dataCategory #CUBE view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
Analytics.internalName #LOCAL view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY ElectronicDocUUID I_IN_GSTR6DistrInvoiceCube ElectronicDocUUID
KEY ElectronicDocCompanyCode I_IN_GSTR6DistrInvoiceCube ElectronicDocCompanyCode
KEY InputServiceDistrBusPlace I_IN_GSTR6DistrInvoiceCube InputServiceDistrBusPlace
PostingDate I_IN_GSTR6DistrInvoiceCube PostingDate Posting Date for GR
IN_EDocGSTRetsTaxReportingDate I_IN_GSTR6DistrInvoiceCube IN_EDocGSTRetsTaxReportingDate
IN_EDocInptTaxCrdtAccptdDate I_IN_GSTR6DistrInvoiceCube IN_EDocInptTaxCrdtAccptdDate
Currency I_IN_GSTR6DistrInvoiceCube CompanyCodeCurrency Local Currency
EDCDocumentPeriod

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_GSTR6CalcDistrAmtCube.
-- 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.

CREATE VIEW I_IN_GSTR6CalcDistrAmtCube AS
SELECT
  _DistrInv.ElectronicDocUUID AS ElectronicDocUUID,
  _DistrInv.ElectronicDocCompanyCode AS ElectronicDocCompanyCode,
  _DistrInv.InputServiceDistrBusPlace AS InputServiceDistrBusPlace,
  _DistrInv.PostingDate AS PostingDate,
  _DistrInv.IN_EDocGSTRetsTaxReportingDate AS IN_EDocGSTRetsTaxReportingDate,
  _DistrInv.IN_EDocInptTaxCrdtAccptdDate AS IN_EDocInptTaxCrdtAccptdDate,
  _DistrInv.CompanyCodeCurrency AS Currency,
  cast( substring( _DistrInv.IN_EDocInptTaxCrdtAccptdDate, 1, 6 ) as edc_document_period ) AS EDCDocumentPeriod
FROM I_IN_GSTR6DistrInvoiceCube AS _DistrInv
;

Learn More