R_PurContrAccountTP

DDL: R_PURCONTRACCOUNTTP Type: view_entity TRANSACTIONAL
51 Fields 1 Data Sources

Purchase Contract Account

R_PurContrAccountTP is a Transactional CDS View that provides data about "Purchase Contract Account" in SAP S/4HANA. It reads from 1 data source (I_PurCtrAccount) and exposes 51 fields with key fields AccountAssignmentNumber, PurchaseContractItem, PurchaseContract.

Data Sources (1)

SourceAliasJoin Type
I_PurCtrAccount I_PurCtrAccount from

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Purchase Contract Account view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.representativeKey AccountAssignmentNumber view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
Metadata.ignorePropagatedAnnotations true view

Fields (51)

KeyFieldSource TableSource FieldDescription
KEY AccountAssignmentNumber I_PurCtrAccount AccountAssignment Sender Acct Assgmt
KEY PurchaseContractItem I_PurCtrAccount PurchaseContractItem Item
KEY PurchaseContract I_PurCtrAccount PurchaseContract Purchasing Doc.
CostCenter I_PurCtrAccount CostCenter Cost Center
MasterFixedAsset I_PurCtrAccount MasterFixedAsset Fixed Asset
ProjectNetwork I_PurCtrAccount ProjectNetwork Order
Quantity I_PurCtrAccount Quantity Value
OrderQuantityUnit I_PurCtrAccount OrderQuantityUnit Sales Unit
MultipleAcctAssgmtDistrPercent I_PurCtrAccount MultipleAcctAssgmtDistrPercent Distribution
PurgDocNetAmount I_PurCtrAccount PurgDocNetAmount Net Value
DocumentCurrency I_PurCtrAccount DocumentCurrency Document Currency
IsDeleted I_PurCtrAccount IsDeleted TRUE
GLAccount I_PurCtrAccount GLAccount General Ledger
BusinessArea I_PurCtrAccount BusinessArea Business Area
SalesOrder I_PurCtrAccount SalesOrder SD Document
SalesOrderItem I_PurCtrAccount SalesOrderItem Sales Order Item
SalesOrderScheduleLine I_PurCtrAccount SalesOrderScheduleLine SOrder schedule
FixedAsset I_PurCtrAccount FixedAsset Sub-number
OrderID I_PurCtrAccount OrderID Order ID
UnloadingPointName I_PurCtrAccount UnloadingPointName Unloading Point Name
ControllingArea I_PurCtrAccount ControllingArea Controlling Area
CostObject I_PurCtrAccount CostObject Cost Object
ProfitCenter I_PurCtrAccount ProfitCenter Profit Center
WBSElementInternalID I_WBSElementBasicData WBSElementInternalID WBS Internal ID
WBSDescription I_WBSElementBasicData WBSDescription WBS Element Name
ProjectNetworkInternalID I_PurCtrAccount ProjectNetworkInternalID Plan No.f.Oper.
CommitmentItemShortID I_PurCtrAccount CommitmentItemShortID Commitment Item Short ID
FundsCenter I_PurCtrAccount FundsCenter Funds Center
Fund I_PurCtrAccount Fund Sender Fund
FunctionalArea I_PurCtrAccount FunctionalArea Sendr Fctl Area
LastChangedDate I_PurCtrAccount LastChangedDate Created On
GoodsRecipientName I_PurCtrAccount GoodsRecipientName Recipient Name
IsFinallyInvoiced I_PurCtrAccount IsFinallyInvoiced Final Invoice
NetworkActivityInternalID I_PurCtrAccount NetworkActivityInternalID Counter
PartnerAccountNumber I_PurCtrAccount PartnerAccountNumber Partner
JointVentureRecoveryCode I_PurCtrAccount JointVentureRecoveryCode Recovery Ind.
SettlementReferenceDate I_PurCtrAccount SettlementReferenceDate Reference date
OrderInternalID I_PurCtrAccount OrderInternalID Plan No.f.Oper.
OrderIntBillOfOperationsItem I_PurCtrAccount OrderIntBillOfOperationsItem Order Internal Bill of Operations Item
TaxCode I_PurCtrAccount TaxCode Tax Code
TaxJurisdiction I_PurCtrAccount TaxJurisdiction Tax Jurisdiction
NonDeductibleInputTaxAmount I_PurCtrAccount NonDeductibleInputTaxAmount Non-deductible
CostCtrActivityType I_PurCtrAccount CostCtrActivityType Activity Type
BusinessProcess I_PurCtrAccount BusinessProcess Business Process
GrantID I_PurCtrAccount GrantID Sender Grant
BudgetPeriod I_PurCtrAccount BudgetPeriod Budget Period
EarmarkedFundsDocument I_PurCtrAccount EarmarkedFundsDocument Earmarked Funds
ValidityDate I_PurCtrAccount ValidityDate Valid On
LastChangeDateTime _PurContract LastChangeDateTime Timestamp
_PurContract _PurContract
_PurchaseContractItem _PurchaseContractItem

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_PurContrAccountTP.
-- 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_PurContrAccountTP AS
SELECT
  I_PurCtrAccount.AccountAssignment AS AccountAssignmentNumber,
  I_PurCtrAccount.PurchaseContractItem AS PurchaseContractItem,
  I_PurCtrAccount.PurchaseContract AS PurchaseContract,
  I_PurCtrAccount.CostCenter AS CostCenter,
  I_PurCtrAccount.MasterFixedAsset AS MasterFixedAsset,
  I_PurCtrAccount.ProjectNetwork AS ProjectNetwork,
  I_PurCtrAccount.Quantity AS Quantity,
  I_PurCtrAccount.OrderQuantityUnit AS OrderQuantityUnit,
  I_PurCtrAccount.MultipleAcctAssgmtDistrPercent AS MultipleAcctAssgmtDistrPercent,
  I_PurCtrAccount.PurgDocNetAmount AS PurgDocNetAmount,
  I_PurCtrAccount.DocumentCurrency AS DocumentCurrency,
  I_PurCtrAccount.IsDeleted AS IsDeleted,
  I_PurCtrAccount.GLAccount AS GLAccount,
  I_PurCtrAccount.BusinessArea AS BusinessArea,
  I_PurCtrAccount.SalesOrder AS SalesOrder,
  I_PurCtrAccount.SalesOrderItem AS SalesOrderItem,
  I_PurCtrAccount.SalesOrderScheduleLine AS SalesOrderScheduleLine,
  I_PurCtrAccount.FixedAsset AS FixedAsset,
  I_PurCtrAccount.OrderID AS OrderID,
  I_PurCtrAccount.UnloadingPointName AS UnloadingPointName,
  I_PurCtrAccount.ControllingArea AS ControllingArea,
  I_PurCtrAccount.CostObject AS CostObject,
  I_PurCtrAccount.ProfitCenter AS ProfitCenter,
  I_WBSElementBasicData.WBSElementInternalID AS WBSElementInternalID,
  I_WBSElementBasicData.WBSDescription AS WBSDescription,
  I_PurCtrAccount.ProjectNetworkInternalID AS ProjectNetworkInternalID,
  I_PurCtrAccount.CommitmentItemShortID AS CommitmentItemShortID,
  I_PurCtrAccount.FundsCenter AS FundsCenter,
  I_PurCtrAccount.Fund AS Fund,
  I_PurCtrAccount.FunctionalArea AS FunctionalArea,
  I_PurCtrAccount.LastChangedDate AS LastChangedDate,
  I_PurCtrAccount.GoodsRecipientName AS GoodsRecipientName,
  I_PurCtrAccount.IsFinallyInvoiced AS IsFinallyInvoiced,
  I_PurCtrAccount.NetworkActivityInternalID AS NetworkActivityInternalID,
  I_PurCtrAccount.PartnerAccountNumber AS PartnerAccountNumber,
  I_PurCtrAccount.JointVentureRecoveryCode AS JointVentureRecoveryCode,
  I_PurCtrAccount.SettlementReferenceDate AS SettlementReferenceDate,
  I_PurCtrAccount.OrderInternalID AS OrderInternalID,
  I_PurCtrAccount.OrderIntBillOfOperationsItem AS OrderIntBillOfOperationsItem,
  I_PurCtrAccount.TaxCode AS TaxCode,
  I_PurCtrAccount.TaxJurisdiction AS TaxJurisdiction,
  I_PurCtrAccount.NonDeductibleInputTaxAmount AS NonDeductibleInputTaxAmount,
  I_PurCtrAccount.CostCtrActivityType AS CostCtrActivityType,
  I_PurCtrAccount.BusinessProcess AS BusinessProcess,
  I_PurCtrAccount.GrantID AS GrantID,
  I_PurCtrAccount.BudgetPeriod AS BudgetPeriod,
  I_PurCtrAccount.EarmarkedFundsDocument AS EarmarkedFundsDocument,
  I_PurCtrAccount.ValidityDate AS ValidityDate,
  _PurContract.LastChangeDateTime AS LastChangeDateTime
FROM I_PurCtrAccount
;

Learn More