R_PPSEntityProfileItemTP

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 R_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 R_PPSEntityProfileItemTP AS
SELECT
  PPSEntityProfileItemUUID,
  PPSEntityProfileUUID,
  Plant,
  PurchasingOrganization,
  PurchasingGroup,
  AccountAssignmentCategory,
  MasterFixedAsset,
  FixedAsset,
  CompanyCode,
  CostCenter,
  FundsCenter,
  GrantID,
  ProjectNetwork,
  Currency,
  GoodsMovementType,
  PPSPricingArrangementType,
  PPSDeliveryToleranceKey,
  WBSElement,
  PPSWarrantLimit,
  PPSEntityProfileItemFieldName,
  PPSEntityProfileItemFieldValue,
  PPSEntityAttributeIsExcluded,
  PPSEntityAttributeIsDefault,
  CreatedAtDateTime,
  LastChangedAtDateTime,
  CreatedByUser,
  ChangedBy
FROM I_PPSEntityProfileItem
LEFT OUTER JOIN I_PPSEntyPrflItemFieldName AS _ProfileItemFieldName ON PPSEntityProfileItemFieldName = _ProfileItemFieldName.PPSEntityProfileItemFieldName  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroup ON PurchasingGroup = _PurchasingGroup.PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN I_AcctAssignmentCategoryText AS _AcctAssgmtCategory ON AccountAssignmentCategory = _AcctAssgmtCategory.AccountAssignmentCategory AND _AcctAssgmtCategory.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_GrantText AS _Grant ON GrantID = _Grant.GrantID AND _Grant.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProjectNetwork AS _ProjectNetwork ON ProjectNetwork = _ProjectNetwork.ProjectNetwork  -- association [0..1]
LEFT OUTER JOIN I_CurrencyText AS _Currency ON Currency = _Currency.Currency AND _Currency.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_GoodsMovementTypeStdVH AS _GoodsMovementType ON GoodsMovementType = _GoodsMovementType.GoodsMovementType  -- association [0..1]
LEFT OUTER JOIN I_PPS_PrcgArrgmtTypeText AS _PrcgArrgmtType ON PPSPricingArrangementType = _PrcgArrgmtType.PPSPricingArrangementType AND _PrcgArrgmtType.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PPS_PurgDocToleranceKeyVH AS _ToleranceGroup ON PPSDeliveryToleranceKey = _ToleranceGroup.PPSDeliveryToleranceKey  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElement ON WBSElement = _WBSElement.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_PPSWarrantLimitValueHelp AS _WarrantLimit ON PPSWarrantLimit = _WarrantLimit.PPSWarrantLimit  -- association [0..1]
LEFT OUTER JOIN E_PPSEntityProfileItem AS _ProfileItemExtension ON PPSEntityProfileItemUUID = _ProfileItemExtension.PPSEntityProfileItemUUID  -- association [0..1]
;