I_PurReqnAccountAssignment
Purchase Requisition Account Assignment
I_PurReqnAccountAssignment is a Basic CDS View that provides data about "Purchase Requisition Account Assignment" in SAP S/4HANA. It reads from 1 data source (ebkn) and exposes 44 fields with key fields PurchaseRequisition, PurchaseRequisitionItem, PurchaseReqnAcctAssgmtNumber. It has 7 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| ebkn | ebkn | from |
Associations (7)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..*] | I_CostCenter | _CostCenter | $projection.CostCenter = _CostCenter.CostCenter and $projection.ControllingArea = _CostCenter.ControllingArea |
| [0..*] | I_GLAccount | _GLAccount | $projection.GLAccount = _GLAccount.GLAccount |
| [0..1] | I_BusinessArea | _BusinessArea | $projection.BusinessArea = _BusinessArea.BusinessArea |
| [0..*] | I_ProfitCenter | _ProfitCenter | $projection.ControllingArea = _ProfitCenter.ControllingArea and $projection.ProfitCenter = _ProfitCenter.ProfitCenter |
| [0..1] | I_SalesOrder | _SalesOrder | $projection.SalesOrder = _SalesOrder.SalesOrder |
| [0..1] | I_SalesOrderItem | _SalesOrderItem | $projection.SalesOrderItem = _SalesOrderItem.SalesOrder and $projection.SalesOrder = _SalesOrderItem.SalesOrderItem |
| [0..1] | I_ControllingArea | _ControllingArea | $projection.ControllingArea = _ControllingArea.ControllingArea |
Annotations (9)
| Name | Value | Level | Field |
|---|---|---|---|
| EndUserText.label | Purchase Requisition Account Assignment | view | |
| AccessControl.authorizationCheck | #PRIVILEGED_ONLY | view | |
| VDM.viewType | #BASIC | view | |
| AbapCatalog.sqlViewName | IMMPURREQACCASS | view | |
| ObjectModel.usageType.serviceQuality | #A | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view |
Fields (44)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | PurchaseRequisition | banfn | ||
| KEY | PurchaseRequisitionItem | |||
| KEY | PurchaseReqnAcctAssgmtNumber | zebkn | ||
| CostCenter | kostl | |||
| MasterFixedAsset | anln1 | |||
| ProjectNetwork | nplnr | |||
| ProcessOrder | aufnr | |||
| Quantity | menge | |||
| MultipleAcctAssgmtDistrPercent | vproz | |||
| Currency | ||||
| PurReqnNetAmount | netwr | |||
| IsDeleted | loekz | |||
| GLAccount | sakto | |||
| BusinessArea | gsber | |||
| SalesOrder | vbeln | |||
| SalesOrderItem | vbelp | |||
| SalesOrderScheduleLine | veten | |||
| FixedAsset | anln2 | |||
| OrderID | aufnr | |||
| UnloadingPointName | ablad | |||
| ControllingArea | kokrs | |||
| CostObject | kstrg | |||
| ProfitabilitySegment | paobjnr | |||
| ProfitabilitySegment_2 | ||||
| ProfitCenter | prctr | |||
| WBSElementInternalID | ps_psp_pnr | |||
| WBSElementInternalID_2 | ||||
| ProjectNetworkInternalID | aufpl | |||
| CommitmentItem | fipos | |||
| CommitmentItemShortID | ||||
| FundsCenter | fistl | |||
| Fund | geber | |||
| FunctionalArea | fkber | |||
| BudgetPeriod | budget_pd | |||
| GrantID | grant_nbr | |||
| EarmarkedFunds | kblnr | |||
| EarmarkedFundsItem | kblpos | |||
| _CostCenter | _CostCenter | |||
| _BusinessArea | _BusinessArea | |||
| _ProfitCenter | _ProfitCenter | |||
| _SalesOrderItem | _SalesOrderItem | |||
| _SalesOrder | _SalesOrder | |||
| _ControllingArea | _ControllingArea | |||
| _GLAccount | _GLAccount |
@EndUserText.label: 'Purchase Requisition Account Assignment'
@AccessControl.authorizationCheck:#PRIVILEGED_ONLY
@VDM.viewType : #BASIC
@AbapCatalog.sqlViewName: 'IMMPURREQACCASS'
@ObjectModel.usageType.serviceQuality: #A
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
define view I_PurReqnAccountAssignment
as select from ebkn
association [0..*] to I_CostCenter as _CostCenter on $projection.CostCenter = _CostCenter.CostCenter
and $projection.ControllingArea = _CostCenter.ControllingArea
association [0..*] to I_GLAccount as _GLAccount on $projection.GLAccount = _GLAccount.GLAccount
association [0..1] to I_BusinessArea as _BusinessArea on $projection.BusinessArea = _BusinessArea.BusinessArea
association [0..*] to I_ProfitCenter as _ProfitCenter on $projection.ControllingArea = _ProfitCenter.ControllingArea
and $projection.ProfitCenter = _ProfitCenter.ProfitCenter
association [0..1] to I_SalesOrder as _SalesOrder on $projection.SalesOrder = _SalesOrder.SalesOrder
association [0..1] to I_SalesOrderItem as _SalesOrderItem on $projection.SalesOrderItem = _SalesOrderItem.SalesOrder
and $projection.SalesOrder = _SalesOrderItem.SalesOrderItem
association [0..1] to I_ControllingArea as _ControllingArea on $projection.ControllingArea = _ControllingArea.ControllingArea
{
key banfn as PurchaseRequisition,
key cast (bnfpo as vdm_purchaserequisitionitem) as PurchaseRequisitionItem,
key zebkn as PurchaseReqnAcctAssgmtNumber,
kostl as CostCenter,
anln1 as MasterFixedAsset,
nplnr as ProjectNetwork,
aufnr as ProcessOrder,
menge as Quantity,
vproz as MultipleAcctAssgmtDistrPercent,
@UI.hidden: true
@Semantics.currencyCode: true
cast ('' as abap.cuky) as Currency,
@Semantics.amount.currencyCode: 'Currency'
netwr as PurReqnNetAmount,
loekz as IsDeleted,
sakto as GLAccount,
gsber as BusinessArea,
vbeln as SalesOrder,
vbelp as SalesOrderItem,
veten as SalesOrderScheduleLine,
anln2 as FixedAsset,
aufnr as OrderID,
ablad as UnloadingPointName,
kokrs as ControllingArea,
kstrg as CostObject,
// paobjnr as ProfitabilitySegment,
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'ProfitabilitySegment_2'
paobjnr as ProfitabilitySegment,
cast( paobjnr as rkeobjnr_char ) as ProfitabilitySegment_2,
prctr as ProfitCenter,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'WBSElementInternalID_2'
ps_psp_pnr as WBSElementInternalID,
cast( ps_psp_pnr as ps_s4_pspnr ) as WBSElementInternalID_2,
aufpl as ProjectNetworkInternalID,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'CommitmentItemShortID'
fipos as CommitmentItem,
cast( fipos as fmis_ci_internalname ) as CommitmentItemShortID,
fistl as FundsCenter,
geber as Fund,
fkber as FunctionalArea,
budget_pd as BudgetPeriod,
grant_nbr as GrantID,
kblnr as EarmarkedFunds,
kblpos as EarmarkedFundsItem,
_CostCenter,
_BusinessArea,
_ProfitCenter,
_SalesOrderItem,
_SalesOrder,
_ControllingArea,
_GLAccount
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"EBKN"
],
"ASSOCIATED":
[
"I_BUSINESSAREA",
"I_CONTROLLINGAREA",
"I_COSTCENTER",
"I_GLACCOUNT",
"I_PROFITCENTER",
"I_SALESORDER",
"I_SALESORDERITEM"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA