I_IN_GSTRetsSalesRegRelation

DDL: I_IN_GSTRETSSALESREGRELATION Type: view_entity COMPOSITE
23 Fields 2 Data Sources

India GSTR Sales Register Relation

I_IN_GSTRetsSalesRegRelation is a Composite CDS View that provides data about "India GSTR Sales Register Relation" in SAP S/4HANA. It reads from 2 data sources (I_EDCRelation, I_IN_GSTSlsRegTaxRateAggrgn) and exposes 23 fields with key fields EDCType, EDCRepresentationType, EDCRepresentationKey, ElectronicDocUUID.

Data Sources (2)

SourceAliasJoin Type
I_EDCRelation _EDCRelation from
I_IN_GSTSlsRegTaxRateAggrgn _GSTRetsSalesRegisterC inner

Annotations (8)

NameValueLevelField
EndUserText.label India GSTR Sales Register Relation view
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY EDCType I_EDCRelation EDCType Consistency Scen.
KEY EDCRepresentationType I_EDCRelation EDCRepresentationType Rep. Type
KEY EDCRepresentationKey I_EDCRelation EDCRepresentationKey Representation Key
KEY ElectronicDocUUID I_IN_GSTSlsRegTaxRateAggrgn ElectronicDocUUID
EDCRecordUUID I_EDCRelation EDCRecordUUID Consistency GUID
EDCCommonKey I_EDCRelation EDCCommonKey Common Key
EDCCompany I_EDCRelation EDCCompany Value
EDCCreatedOnDateTime I_EDCRelation EDCCreatedOnDateTime Variant created on
CompanyCode I_IN_GSTSlsRegTaxRateAggrgn CompanyCode Receiver Company Code
FiscalYear I_IN_GSTSlsRegTaxRateAggrgn FiscalYear G/L Fiscal Year
TaxRate I_IN_GSTSlsRegTaxRateAggrgn TaxRate Tax Rate
IN_DocumentSectionCode I_IN_GSTSlsRegTaxRateAggrgn IN_DocumentSectionCode
IN_EDocEInvcExtNmbr I_IN_GSTSlsRegTaxRateAggrgn IN_EDocEInvcExtNmbr
ReportingDate I_IN_GSTSlsRegTaxRateAggrgn ReportingDate
CompanyCodeCurrency I_IN_GSTSlsRegTaxRateAggrgn CompanyCodeCurrency Local Currency
IN_GSTPlaceOfSupplyName I_IN_GSTSlsRegTaxRateAggrgn IN_GSTPlaceOfSupplyName
IN_InvoiceType I_IN_GSTSlsRegTaxRateAggrgn IN_InvoiceType
IN_PrtnGSTIdentificationNmbr I_IN_GSTSlsRegTaxRateAggrgn IN_PrtnGSTIdentificationNmbr
TaxBaseAmountInCoCodeCrcy I_IN_GSTSlsRegTaxRateAggrgn TaxBaseAmountInCoCodeCrcy TxBaseAmt CoCodeCrcy
IN_IntegratedGSTAmount I_IN_GSTSlsRegTaxRateAggrgn IN_IntegratedGSTAmount
IN_CentralGSTAmount I_IN_GSTSlsRegTaxRateAggrgn IN_CentralGSTAmount
IN_CessGSTAmtInCoCodeCrcy I_IN_GSTSlsRegTaxRateAggrgn IN_CessGSTAmtInCoCodeCrcy
IN_StateGSTAmount I_IN_GSTSlsRegTaxRateAggrgn IN_StateGSTAmount

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_GSTRetsSalesRegRelation.
-- 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_GSTRetsSalesRegRelation AS
SELECT
  _EDCRelation.EDCType AS EDCType,
  _EDCRelation.EDCRepresentationType AS EDCRepresentationType,
  _EDCRelation.EDCRepresentationKey AS EDCRepresentationKey,
  _GSTRetsSalesRegisterC.ElectronicDocUUID AS ElectronicDocUUID,
  _EDCRelation.EDCRecordUUID AS EDCRecordUUID,
  _EDCRelation.EDCCommonKey AS EDCCommonKey,
  _EDCRelation.EDCCompany AS EDCCompany,
  _EDCRelation.EDCCreatedOnDateTime AS EDCCreatedOnDateTime,
  _GSTRetsSalesRegisterC.CompanyCode AS CompanyCode,
  _GSTRetsSalesRegisterC.FiscalYear AS FiscalYear,
  _GSTRetsSalesRegisterC.TaxRate AS TaxRate,
  _GSTRetsSalesRegisterC.IN_DocumentSectionCode AS IN_DocumentSectionCode,
  _GSTRetsSalesRegisterC.IN_EDocEInvcExtNmbr AS IN_EDocEInvcExtNmbr,
  _GSTRetsSalesRegisterC.ReportingDate AS ReportingDate,
  _GSTRetsSalesRegisterC.CompanyCodeCurrency AS CompanyCodeCurrency,
  _GSTRetsSalesRegisterC.IN_GSTPlaceOfSupplyName AS IN_GSTPlaceOfSupplyName,
  _GSTRetsSalesRegisterC.IN_InvoiceType AS IN_InvoiceType,
  _GSTRetsSalesRegisterC.IN_PrtnGSTIdentificationNmbr AS IN_PrtnGSTIdentificationNmbr,
  _GSTRetsSalesRegisterC.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  _GSTRetsSalesRegisterC.IN_IntegratedGSTAmount AS IN_IntegratedGSTAmount,
  _GSTRetsSalesRegisterC.IN_CentralGSTAmount AS IN_CentralGSTAmount,
  _GSTRetsSalesRegisterC.IN_CessGSTAmtInCoCodeCrcy AS IN_CessGSTAmtInCoCodeCrcy,
  _GSTRetsSalesRegisterC.IN_StateGSTAmount AS IN_StateGSTAmount
FROM I_EDCRelation AS _EDCRelation
INNER JOIN I_IN_GSTSlsRegTaxRateAggrgn AS _GSTRetsSalesRegisterC ON /* join condition not captured in parsed metadata */
;

Learn More