Deprecated
This CDS view is deprecated in S/4HANA. View all deprecated CDS views →

C_PL_SAFTGoodsMvtCnsldtnItmQry

DDL: C_PL_SAFTGOODSMVTCNSLDTNITMQRY SQL: CPLSAFTGOODSMTIQ Type: view CONSUMPTION Package: GLO_FIN_IS_SAFT_PL
25 Fields 1 Data Sources

SAF-T Goods Movements Items

C_PL_SAFTGoodsMvtCnsldtnItmQry is a Consumption CDS View that provides data about "SAF-T Goods Movements Items" in SAP S/4HANA. It reads from 1 data source (C_PL_SAFTGoodsMvtCnsldtnItemC) and exposes 25 fields with key fields SAFTConsolidationUUID, GoodsMovementType, GoodsMovement, MaterialDocumentYear, GoodsMovementItem. Part of development package GLO_FIN_IS_SAFT_PL.

Data Sources (1)

SourceAliasJoin Type
C_PL_SAFTGoodsMvtCnsldtnItemC GoodsMvt_Item from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CPLSAFTGOODSMTIQ view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
Analytics.query true view
Analytics.settings.maxProcessingEffort #HIGH view
VDM.lifecycle.status #DEPRECATED view
EndUserText.label SAF-T Goods Movements Items view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY SAFTConsolidationUUID SAFTConsolidationUUID
KEY GoodsMovementType GoodsMovementType Movement Type
KEY GoodsMovement GoodsMovement
KEY MaterialDocumentYear MaterialDocumentYear Material Document Year
KEY GoodsMovementItem GoodsMovementItem
KEY Plant Plant Valuation Area
KEY StorageLocation StorageLocation StorageLocation
WarehouseLocation WarehouseLocation
CompanyCode CompanyCode Receiver Company Code
Customer Customer Sold-to Party
Supplier Supplier Supplier
Product Product Product Sold
Quantity Quantity Value
UnitOfMeasure UnitOfMeasure Unit Protected Qty
GoodsValueCurrency GoodsValueCurrency
DocumentDate DocumentDate Journal Entry Date
PostingDate PostingDate Posting Date for GR
PriceUnit PriceUnit Fixation Set Grp UoM
ItemGoodsValue ItemGoodsValue
MaterialName MaterialName Material Description
InvoiceReference InvoiceReference Invoice Reference
InvoiceReferenceReportingDate InvoiceReferenceReportingDate
ShipFromPartyAddressLine1Text ShipFromPartyAddressLine1Text
ShipToPartyAddressLine1Text ShipToPartyAddressLine1Text
TotalGoodsMvtAmtInCCCrcy TotalGoodsMvtAmtInCCCrcy

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_PL_SAFTGoodsMvtCnsldtnItmQry.
-- 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: CPLSAFTGOODSMTIQ

CREATE VIEW C_PL_SAFTGoodsMvtCnsldtnItmQry AS
SELECT
  SAFTConsolidationUUID,
  GoodsMovementType,
  GoodsMovement,
  MaterialDocumentYear,
  GoodsMovementItem,
  Plant,
  StorageLocation,
  WarehouseLocation,
  CompanyCode,
  Customer,
  Supplier,
  Product,
  Quantity,
  UnitOfMeasure,
  GoodsValueCurrency,
  DocumentDate,
  PostingDate,
  PriceUnit,
  ItemGoodsValue,
  MaterialName,
  InvoiceReference,
  InvoiceReferenceReportingDate,
  ShipFromPartyAddressLine1Text,
  ShipToPartyAddressLine1Text,
  TotalGoodsMvtAmtInCCCrcy
FROM C_PL_SAFTGoodsMvtCnsldtnItemC AS GoodsMvt_Item
;

Learn More