I_PurReqnAcctAssgmtAPI01
Account Assgmt in Purchase Requisition
I_PurReqnAcctAssgmtAPI01 is a Composite CDS View that provides data about "Account Assgmt in Purchase Requisition" in SAP S/4HANA. It reads from 1 data source (I_PurReqnAcctAssgmt) and exposes 68 fields with key fields PurchaseRequisition, PurchaseRequisitionItem, PurchaseReqnAcctAssgmtNumber. It has 2 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_PurReqnAcctAssgmt | I_PurReqnAcctAssgmt | from |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | I_PurchaseRequisitionItemAPI01 | _PurchaseRequisition_Api01 | $projection.PurchaseRequisition = _PurchaseRequisition_Api01.PurchaseRequisition and $projection.PurchaseRequisitionItem = _PurchaseRequisition_Api01.PurchaseRequisitionItem |
| [0..1] | I_CommitmentItemShortID | _CommitmentItemShortID | $projection.CommitmentItemShortID = _CommitmentItemShortID.CommitmentItemShortID |
Annotations (12)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | IPRACCASMTAPI01 | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| VDM.viewType | #COMPOSITE | view | |
| VDM.lifecycle.contract.type | #PUBLIC_LOCAL_API | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| AbapCatalog.preserveKey | true | view | |
| EndUserText.label | Account Assgmt in Purchase Requisition | view |
Fields (68)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | PurchaseRequisition | I_PurReqnAcctAssgmt | PurchaseRequisition | |
| KEY | PurchaseRequisitionItem | I_PurReqnAcctAssgmt | PurchaseRequisitionItem | |
| KEY | PurchaseReqnAcctAssgmtNumber | I_PurReqnAcctAssgmt | PurchaseReqnAcctAssgmtNumber | |
| CostCenter | I_PurReqnAcctAssgmt | CostCenter | ||
| MasterFixedAsset | I_PurReqnAcctAssgmt | MasterFixedAsset | ||
| ProjectNetwork | I_PurReqnAcctAssgmt | ProjectNetwork | ||
| Quantity | I_PurReqnAcctAssgmt | Quantity | ||
| BaseUnit | _PurchaseRequisition_Api01 | BaseUnit | ||
| MultipleAcctAssgmtDistrPercent | I_PurReqnAcctAssgmt | MultipleAcctAssgmtDistrPercent | ||
| PurReqnNetAmount | I_PurReqnAcctAssgmt | PurReqnNetAmount | ||
| PurReqnItemCurrency | _PurchaseRequisition_Api01 | PurReqnItemCurrency | ||
| IsDeleted | I_PurReqnAcctAssgmt | IsDeleted | ||
| CostElement | I_PurReqnAcctAssgmt | CostElement | ||
| GLAccount | I_PurReqnAcctAssgmt | GLAccount | ||
| BusinessArea | I_PurReqnAcctAssgmt | BusinessArea | ||
| SDDocument | I_PurReqnAcctAssgmt | SDDocument | ||
| SalesOrder | I_PurReqnAcctAssgmt | SalesOrder | ||
| SalesDocumentItem | I_PurReqnAcctAssgmt | SalesDocumentItem | ||
| SalesOrderItem | I_PurReqnAcctAssgmt | SalesOrderItem | ||
| ScheduleLine | I_PurReqnAcctAssgmt | ScheduleLine | ||
| SalesOrderScheduleLine | I_PurReqnAcctAssgmt | SalesOrderScheduleLine | ||
| FixedAsset | I_PurReqnAcctAssgmt | FixedAsset | ||
| ProcessOrder | I_PurReqnAcctAssgmt | ProcessOrder | ||
| OrderID | I_PurReqnAcctAssgmt | OrderID | ||
| UnloadingPointName | I_PurReqnAcctAssgmt | UnloadingPointName | ||
| ControllingArea | I_PurReqnAcctAssgmt | ControllingArea | ||
| CostObject | I_PurReqnAcctAssgmt | CostObject | ||
| ProfitabilitySegment | ||||
| ProfitabilitySegment_2 | ||||
| ProfitCenter | I_PurReqnAcctAssgmt | ProfitCenter | ||
| WBSElementInternalID | ||||
| WBSElementInternalID_2 | I_PurReqnAcctAssgmt | WBSElementInternalID_2 | ||
| ProjectNetworkInternalID | I_PurReqnAcctAssgmt | ProjectNetworkInternalID | ||
| CommitmentItem | ||||
| CommitmentItemShortID | I_PurReqnAcctAssgmt | CommitmentItemShortID | ||
| FundsCenter | I_PurReqnAcctAssgmt | FundsCenter | ||
| Fund | I_PurReqnAcctAssgmt | Fund | ||
| FunctionalArea | I_PurReqnAcctAssgmt | FunctionalArea | ||
| CreationDate | I_PurReqnAcctAssgmt | CreationDate | ||
| GoodsRecipientName | I_PurReqnAcctAssgmt | GoodsRecipientName | ||
| RealEstateObject | RealEstateObject | |||
| REInternalFinNumber | REInternalFinNumber | |||
| NetworkActivityInternalID | I_PurReqnAcctAssgmt | NetworkActivityInternalID | ||
| PartnerAccountNumber | I_PurReqnAcctAssgmt | PartnerAccountNumber | ||
| JointVentureRecoveryCode | I_PurReqnAcctAssgmt | JointVentureRecoveryCode | ||
| SettlementReferenceDate | I_PurReqnAcctAssgmt | SettlementReferenceDate | ||
| OrderInternalID | I_PurReqnAcctAssgmt | OrderInternalID | ||
| OrderIntBillOfOperationsItem | I_PurReqnAcctAssgmt | OrderIntBillOfOperationsItem | ||
| EarmarkedFundsDocument | I_PurReqnAcctAssgmt | EarmarkedFundsDocument | ||
| ServiceDocID | I_PurReqnAcctAssgmt | ServiceDocID | ||
| ServiceDocItemID | I_PurReqnAcctAssgmt | ServiceDocItemID | ||
| ServiceDocumentType | I_PurReqnAcctAssgmt | ServiceDocumentType | ||
| CostCtrActivityType | I_PurReqnAcctAssgmt | CostCtrActivityType | ||
| BusinessProcess | I_PurReqnAcctAssgmt | BusinessProcess | ||
| GrantID | I_PurReqnAcctAssgmt | GrantID | ||
| ValidityDate | I_PurReqnAcctAssgmt | ValidityDate | ||
| ChartOfAccounts | I_PurReqnAcctAssgmt | ChartOfAccounts | ||
| WBSElement | I_PurReqnAcctAssgmt | WBSElement | ||
| WBSElementExternalID_2 | I_PurReqnAcctAssgmt | WBSElementExternalID_2 | ||
| ProcmtHubWBSElementExternalID | I_PurReqnAcctAssgmt | ProcmtHubWBSElementExternalID | ||
| PurchaseRequisitionType | _PurchaseRequisition_Api01 | PurchaseRequisitionType | ||
| Plant | _PurchaseRequisition_Api01 | Plant | ||
| PurchasingOrganization | _PurchaseRequisition_Api01 | PurchasingOrganization | ||
| PurchasingGroup | _PurchaseRequisition_Api01 | PurchasingGroup | ||
| _REObjectByIntFinNumber | _REObjectByIntFinNumber | |||
| _PurchaseRequisitionItem | _PurchaseRequisition_Api01 | |||
| _PurchaseRequisition_Api01 | _PurchaseRequisition_Api01 | |||
| _CommitmentItemShortID | _CommitmentItemShortID |
@AbapCatalog.sqlViewName: 'IPRACCASMTAPI01'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass:#TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory:#L //Inserted by VDM CDS Suite Plugin
//@ObjectModel.representativeKey: 'PurchaseReqnAcctAssgmtNumber'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #COMPOSITE
@ObjectModel.supportedCapabilities: [#SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET]
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@Metadata.ignorePropagatedAnnotations: true
@AbapCatalog.preserveKey: true
@EndUserText.label: 'Account Assgmt in Purchase Requisition'
define view I_PurReqnAcctAssgmtAPI01
as select from I_PurReqnAcctAssgmt
/* association [0..1] to I_PurchaseRequisitionItemAPI01 as _PurchaseRequisitionItem on $projection.PurchaseRequisition = _PurchaseRequisitionItem.PurchaseRequisition
and $projection.PurchaseRequisitionItem = _PurchaseRequisitionItem.PurchaseRequisitionItem*/
association [0..1] to I_PurchaseRequisitionItemAPI01 as _PurchaseRequisition_Api01 on $projection.PurchaseRequisition = _PurchaseRequisition_Api01.PurchaseRequisition
and $projection.PurchaseRequisitionItem = _PurchaseRequisition_Api01.PurchaseRequisitionItem
association [0..1] to I_CommitmentItemShortID as _CommitmentItemShortID on $projection.CommitmentItemShortID = _CommitmentItemShortID.CommitmentItemShortID
{
key I_PurReqnAcctAssgmt.PurchaseRequisition as PurchaseRequisition,
key I_PurReqnAcctAssgmt.PurchaseRequisitionItem as PurchaseRequisitionItem,
key I_PurReqnAcctAssgmt.PurchaseReqnAcctAssgmtNumber as PurchaseReqnAcctAssgmtNumber,
I_PurReqnAcctAssgmt.CostCenter,
I_PurReqnAcctAssgmt.MasterFixedAsset,
I_PurReqnAcctAssgmt.ProjectNetwork,
@Semantics.quantity.unitOfMeasure: 'BaseUnit'
I_PurReqnAcctAssgmt.Quantity,
@Semantics.unitOfMeasure: true
_PurchaseRequisition_Api01.BaseUnit,
I_PurReqnAcctAssgmt.MultipleAcctAssgmtDistrPercent,
@Semantics.amount.currencyCode: 'PurReqnItemCurrency'
I_PurReqnAcctAssgmt.PurReqnNetAmount,
@Semantics.currencyCode: true
_PurchaseRequisition_Api01.PurReqnItemCurrency,
I_PurReqnAcctAssgmt.IsDeleted,
I_PurReqnAcctAssgmt.CostElement,
I_PurReqnAcctAssgmt.GLAccount,
I_PurReqnAcctAssgmt.BusinessArea,
I_PurReqnAcctAssgmt.SDDocument,
I_PurReqnAcctAssgmt.SalesOrder,
I_PurReqnAcctAssgmt.SalesDocumentItem,
I_PurReqnAcctAssgmt.SalesOrderItem,
I_PurReqnAcctAssgmt.ScheduleLine,
I_PurReqnAcctAssgmt.SalesOrderScheduleLine,
I_PurReqnAcctAssgmt.FixedAsset,
I_PurReqnAcctAssgmt.ProcessOrder,
I_PurReqnAcctAssgmt.OrderID,
I_PurReqnAcctAssgmt.UnloadingPointName,
I_PurReqnAcctAssgmt.ControllingArea,
I_PurReqnAcctAssgmt.CostObject,
@API.element.releaseState:#DECOMMISSIONED
@API.element.successor:'ProfitabilitySegment_2'
cast(I_PurReqnAcctAssgmt.ProfitabilitySegment as rkeobjnr_numc ) as ProfitabilitySegment,
cast(I_PurReqnAcctAssgmt.ProfitabilitySegment as rkeobjnr_char ) as ProfitabilitySegment_2,
I_PurReqnAcctAssgmt.ProfitCenter,
@API.element.releaseState:#DEPRECATED
@API.element.successor:'WBSElementInternalID_2'
cast( I_PurReqnAcctAssgmt.WBSElementInternalID_2 as ps_psp_pnr ) as WBSElementInternalID,
I_PurReqnAcctAssgmt.WBSElementInternalID_2,
I_PurReqnAcctAssgmt.ProjectNetworkInternalID,
@API.element.releaseState:#DEPRECATED
@API.element.successor:'CommitmentItemShortID'
cast(I_PurReqnAcctAssgmt.CommitmentItemShortID as fipos) as CommitmentItem,
I_PurReqnAcctAssgmt.CommitmentItemShortID,
I_PurReqnAcctAssgmt.FundsCenter,
I_PurReqnAcctAssgmt.Fund,
I_PurReqnAcctAssgmt.FunctionalArea,
I_PurReqnAcctAssgmt.CreationDate,
I_PurReqnAcctAssgmt.GoodsRecipientName,
@API.element.releaseState:#DEPRECATED
@API.element.successor:'REInternalFinNumber'
RealEstateObject,
REInternalFinNumber,
I_PurReqnAcctAssgmt.NetworkActivityInternalID,
I_PurReqnAcctAssgmt.PartnerAccountNumber,
I_PurReqnAcctAssgmt.JointVentureRecoveryCode,
I_PurReqnAcctAssgmt.SettlementReferenceDate,
I_PurReqnAcctAssgmt.OrderInternalID,
I_PurReqnAcctAssgmt.OrderIntBillOfOperationsItem,
I_PurReqnAcctAssgmt.EarmarkedFundsDocument,
I_PurReqnAcctAssgmt.ServiceDocID,
I_PurReqnAcctAssgmt.ServiceDocItemID,
I_PurReqnAcctAssgmt.ServiceDocumentType,
I_PurReqnAcctAssgmt.CostCtrActivityType,
I_PurReqnAcctAssgmt.BusinessProcess,
I_PurReqnAcctAssgmt.GrantID,
I_PurReqnAcctAssgmt.ValidityDate,
I_PurReqnAcctAssgmt.ChartOfAccounts,
@API.element.releaseState:#DEPRECATED
@API.element.successor:'WBSElementExternalID_2'
I_PurReqnAcctAssgmt.WBSElement,
I_PurReqnAcctAssgmt.WBSElementExternalID_2,
I_PurReqnAcctAssgmt.ProcmtHubWBSElementExternalID,
_PurchaseRequisition_Api01.PurchaseRequisitionType as PurchaseRequisitionType,
_PurchaseRequisition_Api01.Plant as Plant,
_PurchaseRequisition_Api01.PurchasingOrganization as PurchasingOrganization,
_PurchaseRequisition_Api01.PurchasingGroup as PurchasingGroup,
/*associations*/
_REObjectByIntFinNumber,
@API.element.releaseState:#DEPRECATED
@API.element.successor:'_PurchaseRequisition_Api01'
_PurchaseRequisition_Api01 as _PurchaseRequisitionItem,
_PurchaseRequisition_Api01,
_CommitmentItemShortID
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASEREQUISITIONITEMAPI01",
"I_PURREQNACCTASSGMT"
],
"ASSOCIATED":
[
"I_COMMITMENTITEMSHORTID",
"I_PURCHASEREQUISITIONITEMAPI01",
"I_REOBJECTBYINTFINNUMBER"
],
"BASE":
[
"I_PURREQNACCTASSGMT"
],
"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