C_GdsRcptItemQty

DDL: C_GDSRCPTITEMQTY SQL: CGDSRCPTITEMQTY Type: view
13 Fields 1 Data Sources 2 Associations

Goods Receipt Item Quantity

C_GdsRcptItemQty is a CDS View that provides data about "Goods Receipt Item Quantity" in SAP S/4HANA. It reads from 1 data source (nsdm_e_mseg) and exposes 13 fields with key fields GoodsMovement, GoodsMovementYear, GoodsMovementItem. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
nsdm_e_mseg gr_items from

Associations (2)

CardinalityTargetAliasCondition
[0..*] t006a GoodsMovementEntryUnitT006A $projection.GoodsMovementEntryUnit = GoodsMovementEntryUnitT006A.msehi
[0..*] t006a BaseUnitT006A $projection.BaseUnit = BaseUnitT006A.msehi

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CGDSRCPTITEMQTY view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Goods Receipt Item Quantity view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY GoodsMovement nsdm_e_mseg mblnr Goods Movement
KEY GoodsMovementYear nsdm_e_mseg mjahr Goods Movement Year
KEY GoodsMovementItem nsdm_e_mseg zeile Agency Business Document
Material nsdm_e_mseg matnr Material
GoodsMovementEntryUnit nsdm_e_mseg erfme Unit of Entry
GoodsMovementEntryUnitT006A GoodsMovementEntryUnitT006A Goods Movement Entry Unit
BaseUnit nsdm_e_mseg meins Valuation Unit
BaseUnitT006A BaseUnitT006A Base Unit
GoodsMovementCurrency nsdm_e_mseg waers Goods Movement Currency
GoodsMovementEntryQty nsdm_e_mseg erfmg Goods Movement Entry Quantity
GdsMovementEntryQtyInBaseUnit nsdm_e_mseg menge Goods Movement Entry Quantity in Base Unit
InventoryValueInCoCodeCrcy nsdm_e_mseg dmbtr Inventory Value in Company Code Currency
shkzg nsdm_e_mseg shkzg Returns

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 C_GdsRcptItemQty.
-- 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: CGDSRCPTITEMQTY

CREATE VIEW C_GdsRcptItemQty AS
SELECT
  gr_items.mblnr AS GoodsMovement,
  gr_items.mjahr AS GoodsMovementYear,
  gr_items.zeile AS GoodsMovementItem,
  gr_items.matnr AS Material,
  gr_items.erfme AS GoodsMovementEntryUnit,
  GoodsMovementEntryUnitT006A,
  gr_items.meins AS BaseUnit,
  BaseUnitT006A,
  gr_items.waers AS GoodsMovementCurrency,
  gr_items.erfmg AS GoodsMovementEntryQty,
  gr_items.menge AS GdsMovementEntryQtyInBaseUnit,
  gr_items.dmbtr AS InventoryValueInCoCodeCrcy,
  gr_items.shkzg AS shkzg
FROM nsdm_e_mseg AS gr_items
LEFT OUTER JOIN t006a AS GoodsMovementEntryUnitT006A ON GoodsMovementEntryUnit = GoodsMovementEntryUnitT006A.msehi  -- association [0..*]
LEFT OUTER JOIN t006a AS BaseUnitT006A ON BaseUnit = BaseUnitT006A.msehi  -- association [0..*]
;

Learn More