I_IN_GoodsReceiptDocList

DDL: I_IN_GOODSRECEIPTDOCLIST SQL: IGOODSRCPTDOCLST Type: view BASIC Package: J1I_GST_LOG_APP
45 Fields 1 Data Sources

List of Goods Receipt Documents

I_IN_GoodsReceiptDocList is a Basic CDS View that provides data about "List of Goods Receipt Documents" in SAP S/4HANA. It reads from 1 data source (I_IN_MatlDocList) and exposes 45 fields with key fields MaterialDocumentYear, MaterialDocument, MaterialDocumentItem. Part of development package J1I_GST_LOG_APP.

Data Sources (1)

SourceAliasJoin Type
I_IN_MatlDocList I_IN_MatlDocList from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IGOODSRCPTDOCLST view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label List of Goods Receipt Documents 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 (45)

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
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
_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_GoodsReceiptDocList.
-- 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: IGOODSRCPTDOCLST

CREATE VIEW I_IN_GoodsReceiptDocList 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
FROM I_IN_MatlDocList
;

Learn More