A_PurOrdAccountAssignment

DDL: A_PURORDACCOUNTASSIGNMENT SQL: APURORDACCASSIGN Type: view COMPOSITE

Account Assignment

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

1 data source(s) 45 fields

Data Sources (1)

SourceAliasJoin Type
I_PurOrdAccountAssignment I_PurOrdAccountAssignment from

Associations (2)

CardinalityTargetAliasCondition
[1..1] A_PurchaseOrder _PurchaseOrder $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder
[0..1] I_WBSElementBasicData _WBSElement _WBSElement.WBSElementInternalID = I_PurOrdAccountAssignment.WBSElementInternalID

Annotations (14)

NameValueLevelField
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName APURORDACCASSIGN view
VDM.viewType #COMPOSITE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Account Assignment view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
OData.entitySet.name A_PurOrdAccountAssignment view

Fields (45)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder I_PurOrdAccountAssignment PurchaseOrder
KEY PurchaseOrderItem I_PurOrdAccountAssignment PurchaseOrderItem
KEY AccountAssignmentNumber I_PurOrdAccountAssignment AccountAssignmentNumber
IsDeleted I_PurOrdAccountAssignment IsDeleted
PurchaseOrderQuantityUnit _PurchaseOrderItem PurchaseOrderQuantityUnit
Quantity I_PurOrdAccountAssignment Quantity
MultipleAcctAssgmtDistrPercent I_PurOrdAccountAssignment MultipleAcctAssgmtDistrPercent
DocumentCurrency I_PurOrdAccountAssignment DocumentCurrency
PurgDocNetAmount I_PurOrdAccountAssignment PurgDocNetAmount
GLAccount I_PurOrdAccountAssignment GLAccount
BusinessArea I_PurOrdAccountAssignment BusinessArea
CostCenter I_PurOrdAccountAssignment CostCenter
SalesOrder I_PurOrdAccountAssignment SalesOrder
SalesOrderItem I_PurOrdAccountAssignment SalesOrderItem
SalesOrderScheduleLine I_PurOrdAccountAssignment SalesOrderScheduleLine
MasterFixedAsset MasterFixedAsset
FixedAsset FixedAsset
GoodsRecipientName GoodsRecipientName
UnloadingPointName UnloadingPointName
ControllingArea I_PurOrdAccountAssignment ControllingArea
CostObject I_PurOrdAccountAssignment CostObject
OrderID I_PurOrdAccountAssignment OrderID
ProfitCenter I_PurOrdAccountAssignment ProfitCenter
WBSElementInternalID WBSElementInternalID
WBSElement _WBSElement WBSElement
WBSElementExternalID _WBSElement WBSElementExternalID
ProjectNetwork I_PurOrdAccountAssignment ProjectNetwork
NetworkActivity I_PurOrdAccountAssignment NetworkActivity
RealEstateObject I_PurOrdAccountAssignment RealEstateObject
PartnerAccountNumber I_PurOrdAccountAssignment PartnerAccountNumber
CommitmentItem I_PurOrdAccountAssignment CommitmentItem
JointVentureRecoveryCode I_PurOrdAccountAssignment JointVentureRecoveryCode
FundsCenter I_PurOrdAccountAssignment FundsCenter
Fund I_PurOrdAccountAssignment Fund
FunctionalArea I_PurOrdAccountAssignment FunctionalArea
SettlementReferenceDate I_PurOrdAccountAssignment SettlementReferenceDate
TaxCode I_PurOrdAccountAssignment TaxCode
TaxJurisdiction I_PurOrdAccountAssignment TaxJurisdiction
CostCtrActivityType CostCtrActivityType
BusinessProcess BusinessProcess
EarmarkedFundsDocument EarmarkedFundsDocument
GrantID GrantID
BudgetPeriod BudgetPeriod
_PurchaseOrder _PurchaseOrder
_PurchaseOrderItem _PurchaseOrderItem 
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'APURORDACCASSIGN'
@VDM.viewType: #COMPOSITE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@EndUserText.label: 'Account Assignment'
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations:true
@OData.entitySet.name : 'A_PurOrdAccountAssignment'
//@ObjectModel: {

// createEnabled: true,

// updateEnabled: true,

// deleteEnabled: true

//}


define view A_PurOrdAccountAssignment
  as select from I_PurOrdAccountAssignment
  association to parent A_PurchaseOrderItem         as _PurchaseOrderItem on  $projection.PurchaseOrder     = _PurchaseOrderItem.PurchaseOrder
                                                                          and $projection.PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem
  association [1..1] to A_PurchaseOrder             as _PurchaseOrder     on  $projection.PurchaseOrder     = _PurchaseOrder.PurchaseOrder
  association [0..1] to I_WBSElementBasicData       as _WBSElement        on  _WBSElement.WBSElementInternalID = I_PurOrdAccountAssignment.WBSElementInternalID                                                                
                                                                  
{
  key I_PurOrdAccountAssignment.PurchaseOrder,
  key I_PurOrdAccountAssignment.PurchaseOrderItem,
  key I_PurOrdAccountAssignment.AccountAssignmentNumber,
//      @ObjectModel: { readOnly: true }

      I_PurOrdAccountAssignment.IsDeleted,
      //      CreationDate,

      
//      @ObjectModel.readOnly: true

      @Semantics.unitOfMeasure: true
      _PurchaseOrderItem.PurchaseOrderQuantityUnit,
      @Semantics.quantity.unitOfMeasure: 'PurchaseOrderQuantityUnit'      
      I_PurOrdAccountAssignment.Quantity,
      I_PurOrdAccountAssignment.MultipleAcctAssgmtDistrPercent,
//      @ObjectModel.readOnly: true

      @Semantics.currencyCode: true
      @ObjectModel.sapObjectNodeTypeReference: 'Currency'
      I_PurOrdAccountAssignment.DocumentCurrency,
      @Semantics.amount.currencyCode: 'DocumentCurrency'     
      I_PurOrdAccountAssignment.PurgDocNetAmount,
//      @ObjectModel: { readOnly: 'EXTERNAL_CALCULATION' }

      I_PurOrdAccountAssignment.GLAccount,

      I_PurOrdAccountAssignment.BusinessArea,
//      @ObjectModel: { readOnly: 'EXTERNAL_CALCULATION' }

      I_PurOrdAccountAssignment.CostCenter,
//      @ObjectModel: { readOnly: 'EXTERNAL_CALCULATION' }

      I_PurOrdAccountAssignment.SalesOrder,
//      @ObjectModel: { readOnly: 'EXTERNAL_CALCULATION' }

     I_PurOrdAccountAssignment.SalesOrderItem,
      I_PurOrdAccountAssignment.SalesOrderScheduleLine,
      MasterFixedAsset,
      FixedAsset,
      GoodsRecipientName,
      UnloadingPointName,
      I_PurOrdAccountAssignment.ControllingArea,
      I_PurOrdAccountAssignment.CostObject,
      I_PurOrdAccountAssignment.OrderID,
//      @ObjectModel: { readOnly: 'EXTERNAL_CALCULATION' }

      I_PurOrdAccountAssignment.ProfitCenter,
    
      WBSElementInternalID,
      _WBSElement.WBSElement,      
      _WBSElement.WBSElementExternalID,
            
      I_PurOrdAccountAssignment.ProjectNetwork,
      I_PurOrdAccountAssignment.NetworkActivity,
      I_PurOrdAccountAssignment.RealEstateObject,
      I_PurOrdAccountAssignment.PartnerAccountNumber,
      I_PurOrdAccountAssignment.CommitmentItem,
      I_PurOrdAccountAssignment.JointVentureRecoveryCode,
      I_PurOrdAccountAssignment.FundsCenter,
      I_PurOrdAccountAssignment.Fund,
//      @ObjectModel: { readOnly: 'EXTERNAL_CALCULATION' }

      I_PurOrdAccountAssignment.FunctionalArea,
      I_PurOrdAccountAssignment.SettlementReferenceDate,
      @ObjectModel.sapObjectNodeTypeReference: 'SalesTaxCode'
      I_PurOrdAccountAssignment.TaxCode,
      @ObjectModel.sapObjectNodeTypeReference: 'TaxJurisdiction'
      I_PurOrdAccountAssignment.TaxJurisdiction,

      CostCtrActivityType,
      BusinessProcess,
      EarmarkedFundsDocument,
      GrantID,
      //      EarmarkedFundsItem,

      //     ActiveMaintOrdOper,

      //     CommitmentItem,

      //       IsAccountAssignmentFinal,

      //        FinalAcctAssgmtReasonCode,

      BudgetPeriod,   
//      @ObjectModel.association.type: #TO_COMPOSITION_ROOT

      _PurchaseOrder,
//      @ObjectModel.association.type: #TO_COMPOSITION_PARENT

      _PurchaseOrderItem

} where _PurchaseOrderItem.PurchasingDocumentDeletionCode = '' 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"A_PURCHASEORDERITEM",
"I_PURORDACCOUNTASSIGNMENT",
"I_WBSELEMENTBASICDATA"
],
"ASSOCIATED":
[
"A_PURCHASEORDER",
"A_PURCHASEORDERITEM",
"I_WBSELEMENTBASICDATA"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More