R_PPS_PurContrAcctAssgmtDraft

DDL: R_PPS_PURCONTRACCTASSGMTDRAFT Type: view_entity BASIC
65 Fields 1 Data Sources 1 Associations

Purchase Contract Acct Assgmt - Draft

R_PPS_PurContrAcctAssgmtDraft is a Basic CDS View that provides data about "Purchase Contract Acct Assgmt - Draft" in SAP S/4HANA. It reads from 1 data source (pps_pc_account_d) and exposes 65 fields with key fields AccountAssignmentNumber, PurchaseContractItem, PurchaseContract, DraftUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
pps_pc_account_d pps_pc_account_d from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_CostCenterText _CostCenterText _CostCenterText.CostCenter = $projection.CostCenter and _CostCenterText.ControllingArea = $projection.ControllingArea and _CostCenterText.ValidityEndDate > $session.system_date and _CostCenterText.Language = $session.system_language

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Purchase Contract Acct Assgmt - Draft view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (65)

KeyFieldSource TableSource FieldDescription
KEY AccountAssignmentNumber accountassignmentnumber Account Assgmt No.
KEY PurchaseContractItem purchasecontractitem Item
KEY PurchaseContract purchasecontract Purchasing Doc.
KEY DraftUUID draftuuid UUID
ParentDraftUUID parentdraftuuid NodeID
CostCenter costcenter Cost Center
CostCenterDescription
MasterFixedAsset masterfixedasset Fixed Asset
ProjectNetwork projectnetwork Order
Quantity quantity Value
OrderQuantityUnit orderquantityunit Sales Unit
MultipleAcctAssgmtDistrPercent multipleacctassgmtdistrpercent Distribution
PurgDocNetAmount purgdocnetamount Net Value
DocumentCurrency documentcurrency Document Currency
IsDeleted isdeleted TRUE
GLAccount glaccount General Ledger
BusinessArea businessarea Business Area
SalesOrder salesorder SD Document
SalesOrderItem salesorderitem Sales Order Item
SalesOrderScheduleLine salesorderscheduleline SOrder schedule
FixedAsset fixedasset Sub-number
OrderID orderid Order ID
UnloadingPointName unloadingpointname Unloading Point Name
ControllingArea controllingarea Controlling Area
CostObject costobject Cost Object
ProfitCenter profitcenter Profit Center
WBSElementInternalID wbselementinternalid WBS Internal ID
WBSElementExternalID wbselementexternalid WBS Element External ID
WBSDescription wbsdescription WBS Element Name
ProjectNetworkInternalID projectnetworkinternalid Plan No.f.Oper.
CommitmentItem commitmentitem Commitment item
CommitmentItemShortID commitmentitemshortid Commitment Item Short ID
NetworkActivity networkactivity Operation/Activity
FundsCenter fundscenter Funds Center
Fund fund Sender Fund
FunctionalArea functionalarea Sendr Fctl Area
LastChangedDate lastchangeddate Created On
GoodsRecipientName goodsrecipientname Recipient Name
IsFinallyInvoiced isfinallyinvoiced Final Invoice
NetworkActivityInternalID networkactivityinternalid Counter
PartnerAccountNumber partneraccountnumber Partner
JointVentureRecoveryCode jointventurerecoverycode Recovery Ind.
SettlementReferenceDate settlementreferencedate Reference date
OrderInternalID orderinternalid Plan No.f.Oper.
OrderIntBillOfOperationsItem orderintbillofoperationsitem Order Internal Bill of Operations Item
TaxCode taxcode Tax Code
TaxJurisdiction taxjurisdiction Tax Jurisdiction
NonDeductibleInputTaxAmount nondeductibleinputtaxamount Non-deductible
CostCtrActivityType costctractivitytype Activity Type
BusinessProcess businessprocess Business Process
GrantID grantid Sender Grant
BudgetPeriod budgetperiod Budget Period
EarmarkedFundsDocument earmarkedfundsdocument Earmarked Funds
ValidityDate validitydate Valid On
LastChangeDateTime lastchangedatetime Timestamp
PPSFieldChangeIndicatorBinary ppsfieldchangeindicatorbinary Control
CompanyCode companycode Receiver Company Code
FinancialManagementArea financialmanagementarea FM Area
PurchaseContractDraftUUID purchasecontractdraftuuid Key
DraftEntityCreationDateTime draftentitycreationdatetime Draft Created On
DraftEntityLastChangeDateTime draftentitylastchangedatetime Draft Last Changed On
DraftAdministrativeDataUUID draftadministrativedatauuid UUID
DraftEntityOperationCode draftentityoperationcode Draft - Operation Code
HasActiveEntity hasactiveentity TRUE
DraftFieldChanges draftfieldchanges Field Changes

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_PPS_PurContrAcctAssgmtDraft.
-- 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_PPS_PurContrAcctAssgmtDraft AS
SELECT
  AccountAssignmentNumber,
  PurchaseContractItem,
  PurchaseContract,
  DraftUUID,
  ParentDraftUUID,
  CostCenter,
  _CostCenterText[1: Language = $session.system_language ].CostCenterDescription AS CostCenterDescription,
  MasterFixedAsset,
  ProjectNetwork,
  Quantity,
  OrderQuantityUnit,
  MultipleAcctAssgmtDistrPercent,
  PurgDocNetAmount,
  DocumentCurrency,
  IsDeleted,
  GLAccount,
  BusinessArea,
  SalesOrder,
  SalesOrderItem,
  SalesOrderScheduleLine,
  FixedAsset,
  OrderID,
  UnloadingPointName,
  ControllingArea,
  CostObject,
  ProfitCenter,
  WBSElementInternalID,
  WBSElementExternalID,
  WBSDescription,
  ProjectNetworkInternalID,
  CommitmentItem,
  CommitmentItemShortID,
  NetworkActivity,
  FundsCenter,
  Fund,
  FunctionalArea,
  LastChangedDate,
  GoodsRecipientName,
  IsFinallyInvoiced,
  NetworkActivityInternalID,
  PartnerAccountNumber,
  JointVentureRecoveryCode,
  SettlementReferenceDate,
  OrderInternalID,
  OrderIntBillOfOperationsItem,
  TaxCode,
  TaxJurisdiction,
  NonDeductibleInputTaxAmount,
  CostCtrActivityType,
  BusinessProcess,
  GrantID,
  BudgetPeriod,
  EarmarkedFundsDocument,
  ValidityDate,
  LastChangeDateTime,
  PPSFieldChangeIndicatorBinary,
  CompanyCode,
  FinancialManagementArea,
  PurchaseContractDraftUUID,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM pps_pc_account_d
LEFT OUTER JOIN I_CostCenterText AS _CostCenterText ON _CostCenterText.CostCenter = CostCenter AND _CostCenterText.ControllingArea = ControllingArea AND _CostCenterText.ValidityEndDate > $session.system_date AND _CostCenterText.Language = $session.system_language  -- association [0..*]
;

Learn More