I_IN_MatlDocNotReversed

DDL: I_IN_MATLDOCNOTREVERSED SQL: IMATDOCNOTREV Type: view BASIC
54 Fields 1 Data Sources 1 Associations

Documents which are not canceled

I_IN_MatlDocNotReversed is a Basic CDS View that provides data about "Documents which are not canceled" in SAP S/4HANA. It reads from 1 data source (I_IN_GoodsIssueDocList) and exposes 54 fields with key fields MaterialDocumentYear, MaterialDocument, MaterialDocumentItem, SubcontrgChallan, Item. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_IN_GoodsIssueDocList I_IN_GoodsIssueDocList from

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_IN_BusinessPlace _I_IN_BusinessPlace $projection.CompanyCode = I_IN_GoodsIssueDocList.CompanyCode and _I_IN_BusinessPlace.CompanyCode = 'IN'

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMATDOCNOTREV view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Documents which are not canceled view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view

Fields (54)

KeyFieldSource TableSource FieldDescription
KEY MaterialDocumentYear MaterialDocumentYear Material Document Year
KEY MaterialDocument MaterialDocument Material Doc.
KEY MaterialDocumentItem MaterialDocumentItem Material Document Item
KEY SubcontrgChallan j_1ig_subcon chln_inv Challan or Inv. No.
KEY Item j_1ig_subcon item Task ID
Plant Plant Valuation Area
Material Material Vehicle Model
StorageLocation StorageLocation StorageLocation
SubcontrgBatch j_1ig_subcon charg Chargeable Proc.
Supplier Supplier Supplier
GoodsMovementType GoodsMovementType Movement Type
QuantityInEntryUnit QuantityInEntryUnit Quantity in Unit of Entry
EntryUnit EntryUnit Unit of Entry
ReversedMaterialDocumentYear ReversedMaterialDocumentYear Reversed Doc Year
ReversedMaterialDocument ReversedMaterialDocument Reversed Mat Doc
ReversedMaterialDocumentItem ReversedMaterialDocumentItem Reversed Doc Item
RvslOfGoodsReceiptIsAllowed RvslOfGoodsReceiptIsAllowed
IsReversalMovementType IsReversalMovementType
GoodsMovementIsCancelled GoodsMovementIsCancelled Is Item Cancelled
GoodsMovementCancellationType GoodsMovementCancellationType
GoodsRecipientName GoodsRecipientName Recipient Name
UnloadingPointName UnloadingPointName Unloading Point Name
CostCenter CostCenter Cost Center
GLAccount GLAccount General Ledger
CostObject CostObject Cost Object
ProfitabilitySegment ProfitabilitySegment Profitability Segment
ProfitCenter ProfitCenter Profit Center
CostEstimate CostEstimate Cost EstimateNo
ReferenceDocument ReferenceDocument Reference Document
ServicePerformer ServicePerformer Service Performer
EmploymentInternalID EmploymentInternalID WorkForce Assgmt ID
AccountAssignmentCategory AccountAssignmentCategory Acct Assgmt Cat
WorkItem WorkItem Work Item ID
ServicesRenderedDate ServicesRenderedDate Services Rendered Date
CompanyCode CompanyCode Receiver Company Code
BusinessArea BusinessArea Business Area
PostingDate PostingDate Posting Date for GR
TotalGoodsMvtAmtInCCCrcy TotalGoodsMvtAmtInCCCrcy
GoodsMovementStkAmtInCCCrcy GoodsMovementStkAmtInCCCrcy
GoodsMvtCnsmpnAmtInCCCrcy GoodsMvtCnsmpnAmtInCCCrcy
CompanyCodeCurrency CompanyCodeCurrency Local Currency
IsAutomaticallyCreated IsAutomaticallyCreated Is Automatically Created
UserName UserName User who owns item
DomainValue j_1ig_subconstat chln_status
SuccessCount j_1ig_subconstat success TRUE
NumberOfAlerts j_1ig_subconstat failed Failed
NumberOfMinorAlerts j_1ig_subconstat to_be_processed
_BusinessArea _BusinessArea
_CompanyCode _CompanyCode
_Material _Material
_Plant _Plant
_StorageLocation _StorageLocation
_Supplier _Supplier
_I_IN_BusinessPlace _I_IN_BusinessPlace

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_MatlDocNotReversed.
-- 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.
-- SQL view name: IMATDOCNOTREV

CREATE VIEW I_IN_MatlDocNotReversed AS
SELECT
  MaterialDocumentYear,
  MaterialDocument,
  MaterialDocumentItem,
  j_1ig_subcon.chln_inv AS SubcontrgChallan,
  j_1ig_subcon.item AS Item,
  Plant,
  Material,
  StorageLocation,
  j_1ig_subcon.charg AS SubcontrgBatch,
  Supplier,
  GoodsMovementType,
  QuantityInEntryUnit,
  EntryUnit,
  ReversedMaterialDocumentYear,
  ReversedMaterialDocument,
  ReversedMaterialDocumentItem,
  RvslOfGoodsReceiptIsAllowed,
  IsReversalMovementType,
  GoodsMovementIsCancelled,
  GoodsMovementCancellationType,
  GoodsRecipientName,
  UnloadingPointName,
  CostCenter,
  GLAccount,
  CostObject,
  ProfitabilitySegment,
  ProfitCenter,
  CostEstimate,
  ReferenceDocument,
  ServicePerformer,
  EmploymentInternalID,
  AccountAssignmentCategory,
  WorkItem,
  ServicesRenderedDate,
  CompanyCode,
  BusinessArea,
  PostingDate,
  TotalGoodsMvtAmtInCCCrcy,
  GoodsMovementStkAmtInCCCrcy,
  GoodsMvtCnsmpnAmtInCCCrcy,
  CompanyCodeCurrency,
  IsAutomaticallyCreated,
  UserName,
  j_1ig_subconstat.chln_status AS DomainValue,
  j_1ig_subconstat.success AS SuccessCount,
  j_1ig_subconstat.failed AS NumberOfAlerts,
  j_1ig_subconstat.to_be_processed AS NumberOfMinorAlerts
FROM I_IN_GoodsIssueDocList
LEFT OUTER JOIN I_IN_BusinessPlace AS _I_IN_BusinessPlace ON CompanyCode = I_IN_GoodsIssueDocList.CompanyCode AND _I_IN_BusinessPlace.CompanyCode = 'IN'  -- association [1..*]
;

Learn More