C_PPS_PurConGartdMinAcctAsgtTP

DDL: C_PPS_PURCONGARTDMINACCTASGTTP Type: view_entity CONSUMPTION
41 Fields 1 Data Sources

PPS PC Guaranteed Min Account Assignment

C_PPS_PurConGartdMinAcctAsgtTP is a Consumption CDS View that provides data about "PPS PC Guaranteed Min Account Assignment" in SAP S/4HANA. It reads from 1 data source (R_PPS_PurConGartdMinAcctAsgtTP) and exposes 41 fields with key fields PurchaseContract, PurchaseContractItem, CommitmentPlanItemNumber, AccountAssignmentNumber.

Data Sources (1)

SourceAliasJoin Type
R_PPS_PurConGartdMinAcctAsgtTP R_PPS_PurConGartdMinAcctAsgtTP projection

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label PPS PC Guaranteed Min Account Assignment view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey AccountAssignmentNumber view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Search.searchable true view
VDM.viewType #CONSUMPTION view

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract PurchaseContract Purchasing Doc.
KEY PurchaseContractItem PurchaseContractItem Item
KEY CommitmentPlanItemNumber CommitmentPlanItemNumber Comm. Plan Item
KEY AccountAssignmentNumber AccountAssignmentNumber Account Assgmt No.
PurgDocNetAmount PurgDocNetAmount Net Value
CommitmentItemShortID CommitmentItemShortID Commitment Item Short ID
CommitmentItemName _CommitmentItemTxt CommitmentItemName Long Text
FundsCenter FundsCenter Funds Center
FundsCenterName
FunctionalArea FunctionalArea Sendr Fctl Area
FunctionalAreaName
GrantID GrantID Sender Grant
Fund Fund Sender Fund
FundName
GLAccount GLAccount General Ledger
EarmarkedFundsDocument EarmarkedFundsDocument Earmarked Funds
EarmarkedFundsDocumentItem EarmarkedFundsDocumentItem Document Item
NetworkNumberForAcctAssgmt NetworkNumberForAcctAssgmt Network
NetworkActivity NetworkActivity Operation/Activity
ProductionOrder ProductionOrder Order
CostCenter CostCenter Cost Center
CostCenterName
ControllingArea ControllingArea Controlling Area
BusinessArea BusinessArea Business Area
WBSElementInternalID WBSElementInternalID WBS Internal ID
DeletionIndicator DeletionIndicator Deletion Ind.
FundedProgram FundedProgram Funded Program
FundsMgmtPeriodOfPerfStartDate FundsMgmtPeriodOfPerfStartDate Per. of Perf. Start
FundsMgmtPeriodOfPerfEndDate FundsMgmtPeriodOfPerfEndDate Per. of Perf. End
BudgetPeriod BudgetPeriod Budget Period
EmrkdFndsAcctAssgmtChangeable EmrkdFndsAcctAssgmtChangeable AcctAss.Change.
CompanyCode _PurchaseContract CompanyCode Receiver Company Code
ChartOfAccounts
FinancialManagementArea FinancialManagementArea FM Area
FundsCenterFinMgmtArea
DocumentCurrency DocumentCurrency Document Currency
Association_GLAccount
_Fund _Fund
_FundsCenter _FundsCenter
_FunctionalArea _FunctionalArea
_CommitmentItemTxt _CommitmentItemTxt

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_PPS_PurConGartdMinAcctAsgtTP.
-- 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_PPS_PurConGartdMinAcctAsgtTP AS
SELECT
  PurchaseContract,
  PurchaseContractItem,
  CommitmentPlanItemNumber,
  AccountAssignmentNumber,
  PurgDocNetAmount,
  CommitmentItemShortID,
  _CommitmentItemTxt.CommitmentItemName AS CommitmentItemName,
  FundsCenter,
  _FundsCenter._Text[1: Language = $session.system_language].FundsCenterName AS FundsCenterName,
  FunctionalArea,
  _FunctionalArea._Text[1: Language = $session.system_language].FunctionalAreaName AS FunctionalAreaName,
  GrantID,
  Fund,
  _Fund._Text[1: Language = $session.system_language].FundName AS FundName,
  GLAccount,
  EarmarkedFundsDocument,
  EarmarkedFundsDocumentItem,
  NetworkNumberForAcctAssgmt,
  NetworkActivity,
  ProductionOrder,
  CostCenter,
  _CostCenter._Text[1: Language = $session.system_language].CostCenterName AS CostCenterName,
  ControllingArea,
  BusinessArea,
  WBSElementInternalID,
  DeletionIndicator,
  FundedProgram,
  FundsMgmtPeriodOfPerfStartDate,
  FundsMgmtPeriodOfPerfEndDate,
  BudgetPeriod,
  EmrkdFndsAcctAssgmtChangeable,
  _PurchaseContract.CompanyCode AS CompanyCode,
  cast(_PurchaseContract._CompanyCode.ChartOfAccounts as ktopl preserving type) AS ChartOfAccounts,
  FinancialManagementArea,
  cast(_PurchaseContract._CompanyCode.FinancialManagementArea as fikrs preserving type) AS FundsCenterFinMgmtArea,
  DocumentCurrency
FROM R_PPS_PurConGartdMinAcctAsgtTP
;

Learn More