I_IN_GoodsIssueDocList

DDL: I_IN_GOODSISSUEDOCLIST SQL: IGOODSISUDOCLST Type: view BASIC
46 Fields 1 Data Sources

Goods Issue Documents For INDIA

I_IN_GoodsIssueDocList is a Basic CDS View that provides data about "Goods Issue Documents For INDIA" in SAP S/4HANA. It reads from 1 data source (I_IN_MatlDocList) and exposes 46 fields with key fields MaterialDocumentYear, MaterialDocument, MaterialDocumentItem.

Data Sources (1)

SourceAliasJoin Type
I_IN_MatlDocList I_IN_MatlDocList from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IGOODSISUDOCLST view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Goods Issue Documents For INDIA view
VDM.viewType #BASIC view

Fields (46)

KeyFieldSource TableSource FieldDescription
KEY MaterialDocumentYear MaterialDocumentYear Material Document Year
KEY MaterialDocument MaterialDocument Material Doc.
KEY MaterialDocumentItem MaterialDocumentItem Material Document Item
Plant Plant Valuation Area
Material Material Vehicle Model
StorageLocation StorageLocation StorageLocation
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 RevGR desp. IR
IsReversalMovementType IsReversalMovementType
GoodsMovementIsCancelled GoodsMovementIsCancelled Is Item Cancelled
GoodsMovementCancellationType GoodsMovementCancellationType Rel. for Analytics
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 Loc. amount
GoodsMovementStkAmtInCCCrcy GoodsMovementStkAmtInCCCrcy Amt LC w/ Stk Qty
GoodsMvtCnsmpnAmtInCCCrcy GoodsMvtCnsmpnAmtInCCCrcy Amt LC w/ Cons Qty
CompanyCodeCurrency CompanyCodeCurrency Local Currency
IsAutomaticallyCreated IsAutomaticallyCreated Is Automatically Created
UserName UserName User who owns item
_BusinessArea _BusinessArea
_CompanyCode _CompanyCode
_Material _Material
_Plant _Plant
_StorageLocation _StorageLocation
_Supplier _Supplier

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_GoodsIssueDocList.
-- 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: IGOODSISUDOCLST

CREATE VIEW I_IN_GoodsIssueDocList AS
SELECT
  MaterialDocumentYear,
  MaterialDocument,
  MaterialDocumentItem,
  Plant,
  Material,
  StorageLocation,
  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
FROM I_IN_MatlDocList
;

Learn More