I_IN_EDocEWbillMultiVehGrpDet

DDL: I_IN_EDOCEWBILLMULTIVEHGRPDET Type: view_entity COMPOSITE

India eWay Bill Multi Group Details

I_IN_EDocEWbillMultiVehGrpDet is a Composite CDS View that provides data about "India eWay Bill Multi Group Details" in SAP S/4HANA. It reads from 1 data source (R_IN_EDocEWbillMultiVehGrp) and exposes 21 fields with key fields ElectronicDocUUID, IN_EDocMultiVehGrpNmbr, IN_EDocMultiVehSqncNmbr. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
R_IN_EDocEWbillMultiVehGrp MultiGrp from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_RegionText _RegionText _RegionText.Country = 'IN' and _RegionText.Language = $session.system_language

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label India eWay Bill Multi Group Details view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.updateEnabled true view
ObjectModel.createEnabled true view
ObjectModel.deleteEnabled true view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY ElectronicDocUUID R_IN_EDocEWbillMultiVehGrp ElectronicDocUUID eDocument GUID
KEY IN_EDocMultiVehGrpNmbr R_IN_EDocEWbillMultiVehGrp IN_EDocMultiVehGrpNmbr Group Number
KEY IN_EDocMultiVehSqncNmbr MultiGrpDet IN_EDocMultiVehSqncNmbr
IN_EDocMultiVehIsModifd MultiGrpDet IN_EDocMultiVehIsModifd
IN_EDocMultiVehGrpTxt R_IN_EDocEWbillMultiVehGrp IN_EDocMultiVehGrpTxt
IN_EDocMultiVehNewVehNmbr MultiGrpDet IN_EDocMultiVehNewVehNmbr
IN_EDocTransptDocNmbr MultiGrpDet IN_EDocTransptDocNmbr
IN_EDocTransptDocDate MultiGrpDet IN_EDocTransptDocDate
IN_EDocMultiVehQtyVal MultiGrpDet IN_EDocMultiVehQtyVal
IN_EDocMultiVehToPlaceTxt R_IN_EDocEWbillMultiVehGrp IN_EDocMultiVehToPlaceTxt To Place
IN_EDocMultiVehToState R_IN_EDocEWbillMultiVehGrp IN_EDocMultiVehToState To State
IN_EDocMultiVehAddedDate MultiGrpDet IN_EDocMultiVehAddedDate
IN_EDocMultiVehAddedTime MultiGrpDet IN_EDocMultiVehAddedTime
IN_EDocMultiVehUpdtDate MultiGrpDet IN_EDocMultiVehUpdtDate
IN_EDocMultiVehUpdtTime MultiGrpDet IN_EDocMultiVehUpdtTime
IN_EDocMultiVehGrpCreateDate R_IN_EDocEWbillMultiVehGrp IN_EDocMultiVehGrpCreateDate Group Creation Date
IN_EDocMultiVehGrpCreateTime R_IN_EDocEWbillMultiVehGrp IN_EDocMultiVehGrpCreateTime Group Creation Time
IN_EDocMultiVehOldVehNmbr MultiGrpDet IN_EDocMultiVehOldVehNmbr
IN_EDocEWbillOldTransptDocNmbr MultiGrpDet IN_EDocEWbillOldTransptDocNmbr
IN_EDocEWbillModifReasonCode MultiGrpDet IN_EDocEWbillModifReasonCode Return/Change Reason
IN_EDocEWbillModifRemarksTxt MultiGrpDet IN_EDocEWbillModifRemarksTxt Reason Remarks

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_EDocEWbillMultiVehGrpDet.
-- 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_EDocEWbillMultiVehGrpDet AS
SELECT
  MultiGrp.ElectronicDocUUID AS ElectronicDocUUID,
  MultiGrp.IN_EDocMultiVehGrpNmbr AS IN_EDocMultiVehGrpNmbr,
  MultiGrpDet.IN_EDocMultiVehSqncNmbr AS IN_EDocMultiVehSqncNmbr,
  MultiGrpDet.IN_EDocMultiVehIsModifd AS IN_EDocMultiVehIsModifd,
  MultiGrp.IN_EDocMultiVehGrpTxt AS IN_EDocMultiVehGrpTxt,
  MultiGrpDet.IN_EDocMultiVehNewVehNmbr AS IN_EDocMultiVehNewVehNmbr,
  MultiGrpDet.IN_EDocTransptDocNmbr AS IN_EDocTransptDocNmbr,
  MultiGrpDet.IN_EDocTransptDocDate AS IN_EDocTransptDocDate,
  MultiGrpDet.IN_EDocMultiVehQtyVal AS IN_EDocMultiVehQtyVal,
  MultiGrp.IN_EDocMultiVehToPlaceTxt AS IN_EDocMultiVehToPlaceTxt,
  MultiGrp.IN_EDocMultiVehToState AS IN_EDocMultiVehToState,
  MultiGrpDet.IN_EDocMultiVehAddedDate AS IN_EDocMultiVehAddedDate,
  MultiGrpDet.IN_EDocMultiVehAddedTime AS IN_EDocMultiVehAddedTime,
  MultiGrpDet.IN_EDocMultiVehUpdtDate AS IN_EDocMultiVehUpdtDate,
  MultiGrpDet.IN_EDocMultiVehUpdtTime AS IN_EDocMultiVehUpdtTime,
  MultiGrp.IN_EDocMultiVehGrpCreateDate AS IN_EDocMultiVehGrpCreateDate,
  MultiGrp.IN_EDocMultiVehGrpCreateTime AS IN_EDocMultiVehGrpCreateTime,
  MultiGrpDet.IN_EDocMultiVehOldVehNmbr AS IN_EDocMultiVehOldVehNmbr,
  MultiGrpDet.IN_EDocEWbillOldTransptDocNmbr AS IN_EDocEWbillOldTransptDocNmbr,
  MultiGrpDet.IN_EDocEWbillModifReasonCode AS IN_EDocEWbillModifReasonCode,
  MultiGrpDet.IN_EDocEWbillModifRemarksTxt AS IN_EDocEWbillModifRemarksTxt
FROM R_IN_EDocEWbillMultiVehGrp AS MultiGrp
LEFT OUTER JOIN I_RegionText AS _RegionText ON _RegionText.Country = 'IN' AND _RegionText.Language = $session.system_language  -- association [0..1]
;