I_IN_ElectronicDocInvoice

DDL: I_IN_ELECTRONICDOCINVOICE Type: view_entity COMPOSITE

India eInvoice details

I_IN_ElectronicDocInvoice is a Composite CDS View that provides data about "India eInvoice details" in SAP S/4HANA. It reads from 1 data source (R_IN_ElectronicDocInvoice) and exposes 34 fields with key field ElectronicDocUUID.

SAP Help Documentation

CategoryDocument and Reporting Compliance
Purpose
This CDS view retrieves the e-invoice details after the Invoice Reference Number (IRN) is generated, such as the IRN, acknowledgement number, date, QR code, and all relevant field values. This CDS view provides the data to answer the following business questions: What is the acknowledgement number of the GST invoice? What is the QR code details of the GST invoice? What is the Invoice Registration Number (IRN) generated? What is the corresponding e-waybill number of the GST invoice? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have a role with the following restriction types set to read access: F_BKPF_BUK (Accounting Document: Authorization for Company Codes)

Structure
Important Fields Important fields in this view include the following: Field Name Description ElectronicDocCompanyCode Company Code ElectronicDocCountry Country/Region ElectronicDocSourceType eDocument Source Type ElectronicDocSourceKey eDocument Source Key ElectronicDocType eDocument Type IN_EDocEInvcExtNmbr Document Number (ODN) IN_EDocEInvcBusinessPlace Business Place IN_ElectronicDocInvcRefNmbr Invoice Registration Number (IRN) IN_ElectronicDocAcknNmbr Acknowledgement Number IN_ElectronicDocQRCodeTxt QR Code IN_EDocEInvcEWbillNmbr E-Waybill Number IN_EDocEInvcEWbillValidityDate E-Waybill Valid To IN_EDocEInvcEWbillValidityTime E-Waybill Validity Ends At

View on SAP Help Portal →

Data Sources (1)

SourceAliasJoin Type
R_IN_ElectronicDocInvoice R_IN_ElectronicDocInvoice from

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label India eInvoice details view
AccessControl.personalData.blocking #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.modelingPattern #NONE view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY ElectronicDocUUID ElectronicDocUUID eDocument GUID
ElectronicDocCompanyCode _ElectronicDoc ElectronicDocCompanyCode
ElectronicDocCountry _ElectronicDoc ElectronicDocCountry
ElectronicDocSourceType _ElectronicDoc ElectronicDocSourceType
ElectronicDocSourceKey _ElectronicDoc ElectronicDocSourceKey
ElectronicDocType _ElectronicDoc ElectronicDocType
ElectronicDocProcessStatus _ElectronicDoc ElectronicDocProcessStatus
ElectronicDocProcess _ElectronicDoc ElectronicDocProcess
IN_EDocEInvcExtNmbr IN_EDocEInvcExtNmbr Document Nmbr
IN_EDocEInvcBusinessPlace IN_EDocEInvcBusinessPlace Business place
IN_ElectronicDocInvcRefNmbr IN_ElectronicDocInvcRefNmbr Invc Reference Nmbr
IN_ElectronicDocAcknNmbr IN_ElectronicDocAcknNmbr Acknowledgement No
IN_ElectronicDocAcknDate IN_ElectronicDocAcknDate Acknowledgement Date
IN_ElectronicDocAcknTime IN_ElectronicDocAcknTime Ack. Time
IN_ElectronicDocCancelDate IN_ElectronicDocCancelDate Cancellation Date
IN_ElectronicDocCancelTime IN_ElectronicDocCancelTime Cancellation Time
IN_ElectronicDocCancReasonCode IN_ElectronicDocCancReasonCode Cancel Reason Code
IN_EDocCancelRemarksTxt IN_EDocCancelRemarksTxt Cancellation Remarks
IN_ElectronicDocQRCodeTxt IN_ElectronicDocQRCodeTxt QR Code
IN_EDocEInvcEWbillNmbr IN_EDocEInvcEWbillNmbr eWay Bill Number
IN_EDocEInvcEWbillCreateDate IN_EDocEInvcEWbillCreateDate EWB Creation Date
IN_EDocEInvcEWbillCreateTime IN_EDocEInvcEWbillCreateTime EWB Creation Time
IN_EDocEInvcEWbillValidityDate IN_EDocEInvcEWbillValidityDate eWay Bill Valid To
IN_EDocEInvcEWbillValidityTime IN_EDocEInvcEWbillValidityTime Validity Ends At
IN_EDocEWbillStatus IN_EDocEWbillStatus eWay Bill Status
IN_EDocEInvcEditActionFlag IN_EDocEInvcEditActionFlag Edit Action
IN_EDocEInvcTransptDocNmbr IN_EDocEInvcTransptDocNmbr Transport Doc No
IN_EDocEInvcTransptDocDate IN_EDocEInvcTransptDocDate Transport Doc Date
IN_EDocEInvcTransptDstncVal IN_EDocEInvcTransptDstncVal Transport Dist in KM
IN_EDocEInvcVehicleNumber IN_EDocEInvcVehicleNumber Vehicle Number
IN_EDocEInvcVehicleType IN_EDocEInvcVehicleType Vehicle Type
IN_EDocEInvcTransptMode IN_EDocEInvcTransptMode Transport Mode
IN_EDocEInvcTransptrName IN_EDocEInvcTransptrName Transporter Name
IN_EDocEInvcTransptrGSTIN IN_EDocEInvcTransptrGSTIN Transporter GSTIN No

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_ElectronicDocInvoice.
-- 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_ElectronicDocInvoice AS
SELECT
  ElectronicDocUUID,
  _ElectronicDoc.ElectronicDocCompanyCode AS ElectronicDocCompanyCode,
  _ElectronicDoc.ElectronicDocCountry AS ElectronicDocCountry,
  _ElectronicDoc.ElectronicDocSourceType AS ElectronicDocSourceType,
  _ElectronicDoc.ElectronicDocSourceKey AS ElectronicDocSourceKey,
  _ElectronicDoc.ElectronicDocType AS ElectronicDocType,
  _ElectronicDoc.ElectronicDocProcessStatus AS ElectronicDocProcessStatus,
  _ElectronicDoc.ElectronicDocProcess AS ElectronicDocProcess,
  IN_EDocEInvcExtNmbr,
  IN_EDocEInvcBusinessPlace,
  IN_ElectronicDocInvcRefNmbr,
  IN_ElectronicDocAcknNmbr,
  IN_ElectronicDocAcknDate,
  IN_ElectronicDocAcknTime,
  IN_ElectronicDocCancelDate,
  IN_ElectronicDocCancelTime,
  IN_ElectronicDocCancReasonCode,
  IN_EDocCancelRemarksTxt,
  IN_ElectronicDocQRCodeTxt,
  IN_EDocEInvcEWbillNmbr,
  IN_EDocEInvcEWbillCreateDate,
  IN_EDocEInvcEWbillCreateTime,
  IN_EDocEInvcEWbillValidityDate,
  IN_EDocEInvcEWbillValidityTime,
  IN_EDocEWbillStatus,
  IN_EDocEInvcEditActionFlag,
  IN_EDocEInvcTransptDocNmbr,
  IN_EDocEInvcTransptDocDate,
  IN_EDocEInvcTransptDstncVal,
  IN_EDocEInvcVehicleNumber,
  IN_EDocEInvcVehicleType,
  IN_EDocEInvcTransptMode,
  IN_EDocEInvcTransptrName,
  IN_EDocEInvcTransptrGSTIN
FROM R_IN_ElectronicDocInvoice
;