R_IN_EDocGSTRetsInbound

DDL: R_IN_EDOCGSTRETSINBOUND Type: view_entity BASIC

India eDocument GSTR Inbound

R_IN_EDocGSTRetsInbound is a Basic CDS View that provides data about "India eDocument GSTR Inbound" in SAP S/4HANA. It reads from 1 data source (edoingstrin) and exposes 11 fields with key field ElectronicDocUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
edoingstrin edoingstrin from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_ElectronicDoc _ElectronicDoc $projection.ElectronicDocUUID = _ElectronicDoc.ElectronicDocUUID

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label India eDocument GSTR Inbound view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY ElectronicDocUUID edoc_guid eDocument GUID
IN_EDocEInvcPullBusinessPlace business_place Business place
IN_EDocEInvcPullTaxPayerGSTIN gstin Taxpayer GSTIN
IN_EDocEInvcPullDocSectionCode doc_section GSTR2A/2B Doc Sec
IN_EDocEInvcPullRptgPeriod Reporting Period
IN_EDocGSTRetsFromDate from_date Valid from Date
IN_EDocBusinessPartnerNumber business_partner Busn. Partner
IN_EDCTaxAuthBusinessPrtnGSTIN cp_gstin Counter Party GSTIN
IN_EDocInvcMgmtSystStatus ims_status
IN_EDocGnrtGSTR2BAgain regenerate_2b
_ElectronicDoc _ElectronicDoc

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 R_IN_EDocGSTRetsInbound.
-- 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 R_IN_EDocGSTRetsInbound AS
SELECT
  edoc_guid AS ElectronicDocUUID,
  business_place AS IN_EDocEInvcPullBusinessPlace,
  gstin AS IN_EDocEInvcPullTaxPayerGSTIN,
  doc_section AS IN_EDocEInvcPullDocSectionCode,
  cast(ret_period as edoc_in_rep_period preserving type) AS IN_EDocEInvcPullRptgPeriod,
  from_date AS IN_EDocGSTRetsFromDate,
  business_partner AS IN_EDocBusinessPartnerNumber,
  cp_gstin AS IN_EDCTaxAuthBusinessPrtnGSTIN,
  ims_status AS IN_EDocInvcMgmtSystStatus,
  regenerate_2b AS IN_EDocGnrtGSTR2BAgain
FROM edoingstrin
LEFT OUTER JOIN I_ElectronicDoc AS _ElectronicDoc ON ElectronicDocUUID = _ElectronicDoc.ElectronicDocUUID  -- association [1..1]
;