I_PhysInvtryReasonCodeText

DDL: I_PHYSINVTRYREASONCODETEXT Type: view_entity BASIC Package: MM_IM_VDM_PI
7 Fields 1 Data Sources 3 Associations 1 OData Services

Reason Type for Phys Invtry - Text

I_PhysInvtryReasonCodeText (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

ReasonForPhysInventoryDiffText · Supply Chain

I_PhysInvtryReasonCodeText is a Basic CDS View that provides data about "Reason Type for Phys Invtry - Text" in SAP S/4HANA. It reads from 1 data source (t157e) and exposes 7 fields with key fields Language, GoodsMovementType, ReasonForPhysInvtryDifference. It has 3 associations to related views. It is exposed through 1 OData service (ASQL_F8634). Part of development package MM_IM_VDM_PI.

SAP Help Documentation

CategoryCDS Views for Physical Inventory
Data CategoryBasic
StatusReleased
Purpose
This view provides access to texts in different languages for the entity represented by I_PhysInvtryReasonCode .

View on SAP Help Portal →

SAP API Hub

CategoryBasic
StateC1
Line of BusinessSupply Chain
Application ComponentMM-IM-VDM-PI-2CL
CapabilitiesData Source for Data Extraction,Data Source in SQL Select,Association Target for Defining CDS Entities,Language-Dependent Text,Data Source for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageSupply Chain for SAP S/4HANA Cloud Public Edition
Description <p>This view provides access to texts in different languages for the entity represented by I_PhysInvtryReasonCode.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
t157e t157e from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_Language _Language $projection.Language = _Language.Language
[0..1] I_GoodsMovementType _GoodsMovementType $projection.GoodsMovementType = _GoodsMovementType.GoodsMovementType
[0..1] I_PhysInvtryReasonCode _PhysInvtryReasonCode $projection.GoodsMovementType = _PhysInvtryReasonCode.GoodsMovementType and $projection.ReasonForPhysInvtryDifference = _PhysInvtryReasonCode.ReasonForPhysInvtryDifference

Annotations (14)

NameValueLevelField
AbapCatalog.entityBuffer.definitionAllowed true view
EndUserText.label Reason Type for Phys Invtry - Text view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey ReasonForPhysInvtryDifference view
ObjectModel.modelingPattern #LANGUAGE_DEPENDENT_TEXT view
ObjectModel.sapObjectNodeType.name ReasonForPhysInventoryDiffText view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Metadata.ignorePropagatedAnnotations true view
Analytics.dataExtraction.enabled true view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F8634 ASQL_F8634 C2 NOT_RELEASED

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY Language t157e spras Off. Language
KEY GoodsMovementType t157e bwart Movement Type (Inventory Management)
KEY ReasonForPhysInvtryDifference t157e grund Reason for Movement
ReasonForPhysInvtryDiffText t157e grtxt Text: Reason for Goods Movement
_Language _Language
_GoodsMovementType _GoodsMovementType
_PhysInvtryReasonCode _PhysInvtryReasonCode

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_PhysInvtryReasonCodeText.
-- 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 I_PhysInvtryReasonCodeText AS
SELECT
  t157e.spras AS Language,
  t157e.bwart AS GoodsMovementType,
  t157e.grund AS ReasonForPhysInvtryDifference,
  t157e.grtxt AS ReasonForPhysInvtryDiffText
FROM t157e
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
LEFT OUTER JOIN I_GoodsMovementType AS _GoodsMovementType ON GoodsMovementType = _GoodsMovementType.GoodsMovementType  -- association [0..1]
LEFT OUTER JOIN I_PhysInvtryReasonCode AS _PhysInvtryReasonCode ON GoodsMovementType = _PhysInvtryReasonCode.GoodsMovementType AND ReasonForPhysInvtryDifference = _PhysInvtryReasonCode.ReasonForPhysInvtryDifference  -- association [0..1]
;

Learn More