I_IN_ElectronicDocTransptRegn

DDL: I_IN_ELECTRONICDOCTRANSPTREGN Type: view_entity COMPOSITE

India eWay Bill details

I_IN_ElectronicDocTransptRegn is a Composite CDS View that provides data about "India eWay Bill details" in SAP S/4HANA. It reads from 1 data source (R_IN_ElectronicDocTransptRegn) and exposes 50 fields with key field ElectronicDocUUID.

SAP Help Documentation

CategoryDocument and Reporting Compliance
Purpose
This CDS view provides a complete list of GST invoices under company code and their corresponding e-waybill numbers. This CDS view provides the data to answer the following business questions: What is the e-waybill number for the GST invoice? What is the status of the e-waybill? When was the e-waybill generated in the system? What is the validity of the e-waybill? 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_ElectronicDocEWbillNmbr E-Waybill Number IN_EDocEWbillValidityDate E-Waybill Valid To IN_EDocEWbillValidityTime E-Waybill Validity Ends At

View on SAP Help Portal →

Data Sources (1)

SourceAliasJoin Type
R_IN_ElectronicDocTransptRegn R_IN_ElectronicDocTransptRegn from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label India eWay Bill details 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 (50)

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
ElectronicDocSequenceNmbr ElectronicDocSequenceNmbr Value Number
IN_ElectronicDocEWbillNmbr IN_ElectronicDocEWbillNmbr eWay Bill Number
IN_EDocEWbillCreateDate IN_EDocEWbillCreateDate EWB Creation Date
IN_EDocEWbillCreateTime IN_EDocEWbillCreateTime EWB Creation Time
IN_EDocEWbillValidityDate IN_EDocEWbillValidityDate eWay Bill Valid To
IN_EDocEWbillValidityTime IN_EDocEWbillValidityTime Validity Ends At
IN_EDocTransptDocNmbr IN_EDocTransptDocNmbr Transport Doc No
IN_EDocTransptDocDate IN_EDocTransptDocDate Transport Doc Date
IN_EDocTransptDistanceVal IN_EDocTransptDistanceVal Transport Dist in KM
IN_EDocRmngTransptDstncVal IN_EDocRmngTransptDstncVal Remain TransDist(KM)
IN_EDocVehicleNumber IN_EDocVehicleNumber Vehicle Number
IN_ElectronicDocVehicleType IN_ElectronicDocVehicleType Vehicle Type
IN_ElectronicDocFromPlaceTxt IN_ElectronicDocFromPlaceTxt From Place
IN_ElectronicDocFromState IN_ElectronicDocFromState
IN_ElectronicDocTransptMode IN_ElectronicDocTransptMode Transport Mode
IN_EDocEWbillModifReasonCode IN_EDocEWbillModifReasonCode Reason Code
IN_EDocEWbillModifRemarksTxt IN_EDocEWbillModifRemarksTxt Reason Remarks
IN_EDocTransptrUpdtDate IN_EDocTransptrUpdtDate Trans. Upd Date
IN_EDocEWbillUpdtDate IN_EDocEWbillUpdtDate eWay Bill Upd. Date
IN_EDocEWbillUpdtTime IN_EDocEWbillUpdtTime eWay Bill Updated On
IN_EDocEWbillValdtyExtnRsnCode IN_EDocEWbillValdtyExtnRsnCode Ext. Reason Code
IN_EWbillValdtyExtnRemarksTxt IN_EWbillValdtyExtnRemarksTxt Extn Remarks
IN_EDocEWbillCancRsnCode IN_EDocEWbillCancRsnCode Cancel Reason Code
IN_EDocEWbillCancelDate IN_EDocEWbillCancelDate Cancellation Date
IN_EDocEWbillCancelTime IN_EDocEWbillCancelTime Cancellation Time
IN_EDocEWbillCancRemarksTxt IN_EDocEWbillCancRemarksTxt Cancellation Remarks
IN_ElectronicDocIsCancFlag IN_ElectronicDocIsCancFlag Cancel eDocument
IN_ElectronicDocEditActionFlag IN_ElectronicDocEditActionFlag Edit Action
IN_ElectronicDocInvcNmbr IN_ElectronicDocInvcNmbr Document Nmbr
IN_ElectronicDocBusinessPlace IN_ElectronicDocBusinessPlace Business place
IN_EDocEWbillIsContingencyFlag IN_EDocEWbillIsContingencyFlag Contingency Flag
IN_ElectronicDocTransptrName IN_ElectronicDocTransptrName Transporter Name
IN_ElectronicDocTransptrGSTIN IN_ElectronicDocTransptrGSTIN Transporter GSTIN No
IN_EDocEWbillCtptyRejectStatus IN_EDocEWbillCtptyRejectStatus Counter Party Reject
IN_ElectronicDocCsgnmtStatus IN_ElectronicDocCsgnmtStatus Consignment Status
IN_EDocEWbillTransitType IN_EDocEWbillTransitType Transit Type
IN_EDocEWbillFromPinCode IN_EDocEWbillFromPinCode From Pincode
IN_EDocEWbillExtnAddrLine1Txt IN_EDocEWbillExtnAddrLine1Txt Address Line 1
IN_EDocEWbillExtnAddrLine2Txt IN_EDocEWbillExtnAddrLine2Txt Address Line 2
IN_EDocEWbillExtnAddrLine3Txt IN_EDocEWbillExtnAddrLine3Txt Address Line 3
IN_EDocEWbillIsMultiVehFlag IN_EDocEWbillIsMultiVehFlag
IN_ElectronicDocSubSupplyDesc IN_ElectronicDocSubSupplyDesc Sub Supply Desc

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_ElectronicDocTransptRegn.
-- 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_ElectronicDocTransptRegn 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,
  ElectronicDocSequenceNmbr,
  IN_ElectronicDocEWbillNmbr,
  IN_EDocEWbillCreateDate,
  IN_EDocEWbillCreateTime,
  IN_EDocEWbillValidityDate,
  IN_EDocEWbillValidityTime,
  IN_EDocTransptDocNmbr,
  IN_EDocTransptDocDate,
  IN_EDocTransptDistanceVal,
  IN_EDocRmngTransptDstncVal,
  IN_EDocVehicleNumber,
  IN_ElectronicDocVehicleType,
  IN_ElectronicDocFromPlaceTxt,
  IN_ElectronicDocFromState,
  IN_ElectronicDocTransptMode,
  IN_EDocEWbillModifReasonCode,
  IN_EDocEWbillModifRemarksTxt,
  IN_EDocTransptrUpdtDate,
  IN_EDocEWbillUpdtDate,
  IN_EDocEWbillUpdtTime,
  IN_EDocEWbillValdtyExtnRsnCode,
  IN_EWbillValdtyExtnRemarksTxt,
  IN_EDocEWbillCancRsnCode,
  IN_EDocEWbillCancelDate,
  IN_EDocEWbillCancelTime,
  IN_EDocEWbillCancRemarksTxt,
  IN_ElectronicDocIsCancFlag,
  IN_ElectronicDocEditActionFlag,
  IN_ElectronicDocInvcNmbr,
  IN_ElectronicDocBusinessPlace,
  IN_EDocEWbillIsContingencyFlag,
  IN_ElectronicDocTransptrName,
  IN_ElectronicDocTransptrGSTIN,
  IN_EDocEWbillCtptyRejectStatus,
  IN_ElectronicDocCsgnmtStatus,
  IN_EDocEWbillTransitType,
  IN_EDocEWbillFromPinCode,
  IN_EDocEWbillExtnAddrLine1Txt,
  IN_EDocEWbillExtnAddrLine2Txt,
  IN_EDocEWbillExtnAddrLine3Txt,
  IN_EDocEWbillIsMultiVehFlag,
  IN_ElectronicDocSubSupplyDesc
FROM R_IN_ElectronicDocTransptRegn
;