What is C_PL_SAFTGoodsMvtCnsldtnHeader in SAP S/4HANA?

C_PL_SAFTGoodsMvtCnsldtnHeader is a consumption CDS view in SAP S/4HANA. SAF-T Goods Mvt Consolidation Header It contains 32 fields.

Which tables does C_PL_SAFTGoodsMvtCnsldtnHeader read from?

C_PL_SAFTGoodsMvtCnsldtnHeader reads data from: I_SAFTConsolidationKey.

What VDM layer is C_PL_SAFTGoodsMvtCnsldtnHeader?

C_PL_SAFTGoodsMvtCnsldtnHeader is classified as a Consumption view optimized for specific business scenarios and reporting.

C_PL_SAFTGoodsMvtCnsldtnHeader

DDL: C_PL_SAFTGOODSMVTCNSLDTNHEADER SQL: CPLSAFTGOODSMOVH Type: view CONSUMPTION

32 Fields 1 Data Sources

SAF-T Goods Mvt Consolidation Header

C_PL_SAFTGoodsMvtCnsldtnHeader is a Consumption CDS View that provides data about "SAF-T Goods Mvt Consolidation Header" in SAP S/4HANA. It reads from 1 data source (I_SAFTConsolidationKey) and exposes 32 fields with key fields SAFTConsolidationUUID, GoodsMovementType, GoodsMovement, MaterialDocumentYear, Plant.

Data Sources (1)

Source	Alias	Join Type
I_SAFTConsolidationKey	saftn_consolidation	inner

Annotations (12)

Name	Value	Level
AbapCatalog.sqlViewName	CPLSAFTGOODSMOVH	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#BLOCKED_DATA_INCLUDED	view
VDM.viewType	#CONSUMPTION	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#D	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
VDM.lifecycle.status	#DEPRECATED	view
EndUserText.label	SAF-T Goods Mvt Consolidation Header	view

Fields (32)

Key	Field	Source Table	Source Field	Description
KEY	SAFTConsolidationUUID		SAFTConsolidationUUID	Consolidation ID
KEY	GoodsMovementType		GoodsMovementType	Movement Type
KEY	GoodsMovement		GoodsMovement
KEY	MaterialDocumentYear		MaterialDocumentYear	Material Document Year
KEY	Plant		Plant	Valuation Area
KEY	StorageLocation		StorageLocation	StorageLocation
	CompanyCode		CompanyCode	Receiver Company Code
	DocumentDate		DocumentDate	Journal Entry Date
	PostingDate		PostingDate	Posting Date for GR
	InvoiceReference		InvoiceReference	Invoice Reference
	InvoiceReferenceReportingDate		InvoiceReferenceReportingDate
	ShipFromPartyAddressLine1Text		ShipFromPartyAddressLine1Text
	ShipToPartyAddressLine1Text		ShipToPartyAddressLine1Text
	TotalGoodsMvtAmtInCCCrcy		TotalGoodsMvtAmtInCCCrcy
	StorageLocationName1endasWarehouseName
	EmailAddress		EmailAddress	E-Mail Address
	LocalTaxOffice		LocalTaxOffice
	District		District	District Court
	CompanyRegion		CompanyRegion	Region
	Municipality		Municipality	Venue Municplty
	BusinessPartnerName41asCompanyName
	HouseNumber1asCompanyCodeAddress
	RegionendasRegion
	CityName
	PostalCode
	StreetName
	HouseNumber
	CityNameelseNiedotyczyendasHomeCityName
	HouseNumberSupplementText
	CompanyVATRegistration	_CompanyCode	VATRegistration	VAT Registration No.
	ReportingVATRegistration
	CompanyCodeCurrency	_CompanyCode	Currency	Valuation Crcy

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_SAFTGoodsMvtCnsldtnHeader.
-- 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: CPLSAFTGOODSMOVH

CREATE VIEW C_PL_SAFTGoodsMvtCnsldtnHeader AS
SELECT
  SAFTConsolidationUUID,
  GoodsMovementType,
  GoodsMovement,
  MaterialDocumentYear,
  Plant,
  StorageLocation,
  CompanyCode,
  DocumentDate,
  PostingDate,
  InvoiceReference,
  InvoiceReferenceReportingDate,
  ShipFromPartyAddressLine1Text,
  ShipToPartyAddressLine1Text,
  TotalGoodsMvtAmtInCCCrcy,
  case when StorageLocation is initial then concat_with_space(Plant, _Plant.PlantName,1) else concat_with_space(concat(concat(Plant,'/'),StorageLocation),concat(concat(_Plant.PlantName,'/'),_StorageLocation.StorageLocationName),1) end as WarehouseName AS StorageLocationName1endasWarehouseName,
  EmailAddress,
  LocalTaxOffice,
  District,
  CompanyRegion,
  Municipality,
  concat_with_space(concat_with_space(concat_with_space(_CompanyCode._Address.BusinessPartnerName1,_CompanyCode._Address.BusinessPartnerName2, 1), _CompanyCode._Address.BusinessPartnerName3,1),_CompanyCode._Address.BusinessPartnerName4,1) as CompanyName AS BusinessPartnerName41asCompanyName,
  concat_with_space(concat_with_space(concat_with_space(_CompanyCode._Address.CityName,_CompanyCode._Address.PostalCode, 1), _CompanyCode._Address.StreetName,1),_CompanyCode._Address.HouseNumber,1) as CompanyCodeAddress AS HouseNumber1asCompanyCodeAddress,
  case when _CompanyCode._Address.Region is initial then 'Nie dotyczy' else _CompanyCode._Address.Region end as Region AS RegionendasRegion,
  _CompanyCode._Address.CityName AS CityName,
  _CompanyCode._Address.PostalCode AS PostalCode,
  _CompanyCode._Address.StreetName AS StreetName,
  _CompanyCode._Address.HouseNumber AS HouseNumber,
  case when _CompanyCode._Address.HomeCityName is not initial then _CompanyCode._Address.HomeCityName when _CompanyCode._Address.CityName is not initial then _CompanyCode._Address.CityName else 'Nie dotyczy' end as HomeCityName AS CityNameelseNiedotyczyendasHomeCityName,
  _CompanyCode._Address.HouseNumberSupplementText AS HouseNumberSupplementText,
  _CompanyCode.VATRegistration AS CompanyVATRegistration,
  replace(_CompanyCode.VATRegistration, 'PL', '') AS ReportingVATRegistration,
  _CompanyCode.Currency AS CompanyCodeCurrency
INNER JOIN I_SAFTConsolidationKey AS saftn_consolidation ON /* join condition not captured in parsed metadata */
;

Depth:

C_PL_SAFTGoodsMvtCnsldtnHeader view

I_SAFTConsolidationKey view

C_PL_SAFTGoodsMvtChkRecd view