C_PPSEntityProfileItemTP

DDL: C_PPSENTITYPROFILEITEMTP Type: view_entity CONSUMPTION
40 Fields 1 Data Sources

Entity Profile Item - TP

C_PPSEntityProfileItemTP is a Consumption CDS View that provides data about "Entity Profile Item - TP" in SAP S/4HANA. It reads from 1 data source (R_PPSEntityProfileItemTP) and exposes 40 fields with key field PPSEntityProfileItemUUID.

Data Sources (1)

SourceAliasJoin Type
R_PPSEntityProfileItemTP R_PPSEntityProfileItemTP projection

Annotations (15)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
EndUserText.label Entity Profile Item - TP view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.allowNewDatasources false view
AbapCatalog.extensibility.elementSuffix PFI view
AbapCatalog.extensibility.quota.maximumFields 170 view
AbapCatalog.extensibility.quota.maximumBytes 1700 view
ObjectModel.sapObjectNodeType.name PPSEntityProfileItem view

Fields (40)

KeyFieldSource TableSource FieldDescription
KEY PPSEntityProfileItemUUID PPSEntityProfileItemUUID
PPSEntityProfileUUID PPSEntityProfileUUID
Plant Plant Valuation Area
PlantName _Plant PlantName Plant Name
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingOrganizationName _PurchasingOrganization PurchasingOrganizationName Purch. Org. Name
PurchasingGroup PurchasingGroup Purchasing Group
PurchasingGroupName _PurchasingGroup PurchasingGroupName Purchasing Grp. Name
AccountAssignmentCategory AccountAssignmentCategory Acct Assgmt Cat
AcctAssignmentCategoryName _AcctAssgmtCategory AcctAssignmentCategoryName Description
MasterFixedAsset MasterFixedAsset Fixed Asset
FixedAsset FixedAsset Sub-number
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName _CompanyCode CompanyCodeName Company Name
CostCenter CostCenter Cost Center
FundsCenter FundsCenter Funds Center
GrantID GrantID Sender Grant
GrantName _Grant GrantName
ProjectNetwork ProjectNetwork Order
ProjectNetworkDescription _ProjectNetwork ProjectNetworkDescription Network Name
Currency Currency Valuation Crcy
CurrencyName _Currency CurrencyName
GoodsMovementType GoodsMovementType Movement Type
GoodsMovementTypeName _GoodsMovementType GoodsMovementTypeName
PPSPricingArrangementType PPSPricingArrangementType
PPSPricingArrangementTypeText _PrcgArrgmtType PPSPricingArrangementTypeText
PPSDeliveryToleranceKey PPSDeliveryToleranceKey Tolerance Key
PPSDeliveryToleranceKeyText _ToleranceGroup PPSDeliveryToleranceKeyText
WBSElement WBSElement WBS Internal ID
PPSWarrantLimit PPSWarrantLimit
PPSWarrantLimitDescription _WarrantLimit PPSWarrantLimitDescription
PPSEntityProfileItemFieldName PPSEntityProfileItemFieldName
PPSEntyProfItemFieldNameDesc _ProfileItemFieldName PPSEntyProfItemFieldNameDesc
PPSEntityProfileItemFieldValue PPSEntityProfileItemFieldValue Field_value
PPSEntityAttributeIsExcluded PPSEntityAttributeIsExcluded
PPSEntityAttributeIsDefault PPSEntityAttributeIsDefault
CreatedAtDateTime CreatedAtDateTime Created On
LastChangedAtDateTime LastChangedAtDateTime Changed On
CreatedByUser CreatedByUser User Name
ChangedBy ChangedBy User Name

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_PPSEntityProfileItemTP.
-- 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_PPSEntityProfileItemTP AS
SELECT
  PPSEntityProfileItemUUID,
  PPSEntityProfileUUID,
  Plant,
  _Plant.PlantName AS PlantName,
  PurchasingOrganization,
  _PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  PurchasingGroup,
  _PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
  AccountAssignmentCategory,
  _AcctAssgmtCategory.AcctAssignmentCategoryName AS AcctAssignmentCategoryName,
  MasterFixedAsset,
  FixedAsset,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  CostCenter,
  FundsCenter,
  GrantID,
  _Grant.GrantName AS GrantName,
  ProjectNetwork,
  _ProjectNetwork.ProjectNetworkDescription AS ProjectNetworkDescription,
  Currency,
  _Currency.CurrencyName AS CurrencyName,
  GoodsMovementType,
  _GoodsMovementType.GoodsMovementTypeName AS GoodsMovementTypeName,
  PPSPricingArrangementType,
  _PrcgArrgmtType.PPSPricingArrangementTypeText AS PPSPricingArrangementTypeText,
  PPSDeliveryToleranceKey,
  _ToleranceGroup.PPSDeliveryToleranceKeyText AS PPSDeliveryToleranceKeyText,
  WBSElement,
  PPSWarrantLimit,
  _WarrantLimit.PPSWarrantLimitDescription AS PPSWarrantLimitDescription,
  PPSEntityProfileItemFieldName,
  _ProfileItemFieldName.PPSEntyProfItemFieldNameDesc AS PPSEntyProfItemFieldNameDesc,
  PPSEntityProfileItemFieldValue,
  PPSEntityAttributeIsExcluded,
  PPSEntityAttributeIsDefault,
  CreatedAtDateTime,
  LastChangedAtDateTime,
  CreatedByUser,
  ChangedBy
FROM R_PPSEntityProfileItemTP
;

Learn More