C_PhysInvtryDocMovementTypes

DDL: C_PHYSINVTRYDOCMOVEMENTTYPES Type: view_entity CONSUMPTION

Movement types and feature control

C_PhysInvtryDocMovementTypes is a Consumption CDS View that provides data about "Movement types and feature control" in SAP S/4HANA. It reads from 1 data source (I_AdjmtPostingMovementType) and exposes 5 fields with key field PhysicalInventoryStockType.

Data Sources (1)

SourceAliasJoin Type
I_AdjmtPostingMovementType AdjmtPostingMovementType from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Movement types and feature control view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY PhysicalInventoryStockType I_AdjmtPostingMovementType PhysicalInventoryStockType Stock Type
PhysInvtryDecreasingQtyMvtType I_AdjmtPostingMovementType PhysInvtryDecreasingQtyMvtType Movement Type
DecreasingQtyMvtTypeReasonCtrl DecreasingQtyMvtTypeControl GoodsMovementReasonControl
PhysInvtryIncreasingQtyMvtType I_AdjmtPostingMovementType PhysInvtryIncreasingQtyMvtType Movement Type
IncreasingQtyMvtTypeReasonCtrl IncreasingQtyMvtTypeControl GoodsMovementReasonControl

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_PhysInvtryDocMovementTypes.
-- 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 C_PhysInvtryDocMovementTypes AS
SELECT
  AdjmtPostingMovementType.PhysicalInventoryStockType AS PhysicalInventoryStockType,
  AdjmtPostingMovementType.PhysInvtryDecreasingQtyMvtType AS PhysInvtryDecreasingQtyMvtType,
  DecreasingQtyMvtTypeControl.GoodsMovementReasonControl AS DecreasingQtyMvtTypeReasonCtrl,
  AdjmtPostingMovementType.PhysInvtryIncreasingQtyMvtType AS PhysInvtryIncreasingQtyMvtType,
  IncreasingQtyMvtTypeControl.GoodsMovementReasonControl AS IncreasingQtyMvtTypeReasonCtrl
FROM I_AdjmtPostingMovementType AS AdjmtPostingMovementType
;