I_PurContrAccountAssgmt

DDL: I_PURCONTRACCOUNTASSGMT SQL: IPCACCTASSGMT Type: view COMPOSITE
45 Fields 1 Data Sources 2 Associations

Purchase Contract Account Assignment

I_PurContrAccountAssgmt is a Composite CDS View that provides data about "Purchase Contract Account Assignment" in SAP S/4HANA. It reads from 1 data source (I_PurgDocAccountAssignment) and exposes 45 fields with key fields PurchaseContract, PurchaseContractItem, AccountAssignmentNumber. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_PurgDocAccountAssignment I_PurgDocAccountAssignment from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_PurchaseContract _PurchaseContract _PurchaseContract.PurchaseContract = $projection.PurchaseContract
[1..1] I_PurchaseContractItem _PurchaseContractItem _PurchaseContractItem.PurchaseContract = $projection.PurchaseContract and _PurchaseContractItem.PurchaseContractItem = $projection.PurchaseContractItem

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IPCACCTASSGMT view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Purchase Contract Account Assignment view

Fields (45)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract PurchasingDocument Purchasing Document
KEY PurchaseContractItem PurchasingDocumentItem Purchasing Doc. Item
KEY AccountAssignmentNumber AccountAssignmentNumber Account Assgmt No.
CostCenter CostCenter Cost Center
MasterFixedAsset MasterFixedAsset Fixed Asset
ProjectNetwork ProjectNetwork Order
Quantity Quantity Value
OrderQuantityUnit _PurchaseContractItem OrderQuantityUnit Sales Unit
MultipleAcctAssgmtDistrPercent MultipleAcctAssgmtDistrPercent Distribution
PurgDocNetAmount PurgDocNetAmount Net Value
DocumentCurrency _PurchaseContract 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
WBSElementInternalID_2 WBS Internal ID
CommitmentItem CommitmentItem Commitment item
CommitmentItemShortID CommitmentItemShortID Commitment Item Short ID
FunctionalArea FunctionalArea Sendr Fctl Area
GoodsRecipientName GoodsRecipientName Recipient Name
RealEstateObject Real Estate Key
PartnerAccountNumber PartnerAccountNumber Partner
JointVentureRecoveryCode JointVentureRecoveryCode Recovery Ind.
SettlementReferenceDate SettlementReferenceDate Reference date
TaxCode TaxCode Tax Code
TaxJurisdiction TaxJurisdiction Tax Jurisdiction
NonDeductibleInputTaxAmount NonDeductibleInputTaxAmount Non-deductible
CostCtrActivityType CostCtrActivityType Activity Type
GrantID GrantID Sender Grant
BudgetPeriod BudgetPeriod Budget Period
EarmarkedFundsDocument EarmarkedFundsDocument Earmarked Funds
FundsCenter FundsCenter Funds Center
BusinessProcess BusinessProcess Business Process
_PurchaseContract _PurchaseContract
_PurchaseContractItem _PurchaseContractItem
_CommitmentItemShortID _CommitmentItemShortID

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 I_PurContrAccountAssgmt.
-- 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.
-- SQL view name: IPCACCTASSGMT

CREATE VIEW I_PurContrAccountAssgmt AS
SELECT
  PurchasingDocument AS PurchaseContract,
  PurchasingDocumentItem AS PurchaseContractItem,
  AccountAssignmentNumber,
  CostCenter,
  MasterFixedAsset,
  ProjectNetwork,
  Quantity,
  _PurchaseContractItem.OrderQuantityUnit AS OrderQuantityUnit,
  MultipleAcctAssgmtDistrPercent,
  PurgDocNetAmount,
  _PurchaseContract.DocumentCurrency AS DocumentCurrency,
  IsDeleted,
  GLAccount,
  BusinessArea,
  SalesOrder,
  SalesOrderItem,
  SalesOrderScheduleLine,
  FixedAsset,
  OrderID,
  UnloadingPointName,
  ControllingArea,
  CostObject,
  ProfitCenter,
  WBSElementInternalID,
  cast( WBSElementInternalID as ps_s4_pspnr ) AS WBSElementInternalID_2,
  CommitmentItem,
  CommitmentItemShortID,
  FunctionalArea,
  GoodsRecipientName,
  cast( REInternalFinNumber as imkey ) AS RealEstateObject,
  PartnerAccountNumber,
  JointVentureRecoveryCode,
  SettlementReferenceDate,
  TaxCode,
  TaxJurisdiction,
  NonDeductibleInputTaxAmount,
  CostCtrActivityType,
  GrantID,
  BudgetPeriod,
  EarmarkedFundsDocument,
  FundsCenter,
  BusinessProcess
FROM I_PurgDocAccountAssignment
LEFT OUTER JOIN I_PurchaseContract AS _PurchaseContract ON _PurchaseContract.PurchaseContract = PurchaseContract  -- association [1..1]
LEFT OUTER JOIN I_PurchaseContractItem AS _PurchaseContractItem ON _PurchaseContractItem.PurchaseContract = PurchaseContract AND _PurchaseContractItem.PurchaseContractItem = PurchaseContractItem  -- association [1..1]
;

Learn More