I_PurReqnAccountAssignment

DDL: I_PURREQNACCOUNTASSIGNMENT SQL: IMMPURREQACCASS Type: view BASIC

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)

SourceAliasJoin Type
ebkn ebkn from

Associations (7)

CardinalityTargetAliasCondition
[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)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
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":""
}
}*/