A_PurchaseContractAccount_2

DDL: A_PURCHASECONTRACTACCOUNT_2 SQL: APURCTRACCNT2 Type: view COMPOSITE

Purchase Contract Item Acc. Assignment

A_PurchaseContractAccount_2 is a Composite CDS View that provides data about "Purchase Contract Item Acc. Assignment" in SAP S/4HANA. It reads from 1 data source (I_PurCtrAccount) and exposes 42 fields with key fields AccountAssignment, PurchaseContractItem, PurchaseContract. It has 2 associations to related views.

1 data source(s) 42 fields

Data Sources (1)

SourceAliasJoin Type
I_PurCtrAccount I_PurCtrAccount from

Associations (2)

CardinalityTargetAliasCondition
[1..1] A_PurchaseContract_2 _PurchaseContract $projection.PurchaseContract = _PurchaseContract.PurchaseContract
[1..1] A_PurchaseContractItem_2 _PurchaseContractItem $projection.PurchaseContract = _PurchaseContractItem.PurchaseContract and $projection.PurchaseContractItem = _PurchaseContractItem.PurchaseContractItem

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName APURCTRACCNT2 view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Purchase Contract Item Acc. Assignment view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled false view
AbapCatalog.preserveKey true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
OData.entitySet.name A_PurCtrAccount view

Fields (42)

KeyFieldSource TableSource FieldDescription
KEY AccountAssignment
KEY PurchaseContractItem PurchaseContractItem
KEY PurchaseContract PurchaseContract
IsDeleted IsDeleted
Quantity Quantity
OrderQuantityUnit OrderQuantityUnit
MultipleAcctAssgmtDistrPercent MultipleAcctAssgmtDistrPercent
PurgDocNetAmount PurgDocNetAmount
DocumentCurrency DocumentCurrency
GLAccount GLAccount
BusinessArea BusinessArea
CostCenter CostCenter
SalesOrder SalesOrder
SalesOrderItem SalesOrderItem
SalesOrderScheduleLine SalesOrderScheduleLine
MasterFixedAsset MasterFixedAsset
FixedAsset FixedAsset
OrderID OrderID
GoodsRecipientName GoodsRecipientName
UnloadingPointName UnloadingPointName
ControllingArea ControllingArea
CostObject CostObject
ProfitCenter ProfitCenter
ProjectNetwork ProjectNetwork
RealEstateObject
PartnerAccountNumber PartnerAccountNumber
CommitmentItem
JointVentureRecoveryCode JointVentureRecoveryCode
FundsCenter FundsCenter
FunctionalArea FunctionalArea
SettlementReferenceDate SettlementReferenceDate
TaxCode TaxCode
TaxJurisdiction TaxJurisdiction
NonDeductibleInputTaxAmount NonDeductibleInputTaxAmount
CostCtrActivityType CostCtrActivityType
BusinessProcess BusinessProcess
EarmarkedFundsDocument EarmarkedFundsDocument
GrantID GrantID
BudgetPeriod BudgetPeriod
WBSElementExternalID _WBSElementByInternalKey WBSElementExternalID
_PurchaseContract _PurchaseContract
_PurchaseContractItem _PurchaseContractItem 
@AbapCatalog.sqlViewName: 'APURCTRACCNT2'
@VDM.viewType : #COMPOSITE
@VDM.lifecycle.contract.type:#PUBLIC_REMOTE_API
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Purchase Contract Item Acc. Assignment'
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations:true

@ObjectModel: {
  createEnabled: true,
  updateEnabled: true,
  deleteEnabled: false
}

@AbapCatalog.preserveKey:true
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MIXED
@AccessControl.personalData.blocking:#BLOCKED_DATA_EXCLUDED
@OData.entitySet.name : 'A_PurCtrAccount'

define view A_PurchaseContractAccount_2 as select from I_PurCtrAccount

    association [1..1] to A_PurchaseContract_2 as _PurchaseContract on $projection.PurchaseContract = _PurchaseContract.PurchaseContract

    association [1..1] to A_PurchaseContractItem_2 as _PurchaseContractItem on $projection.PurchaseContract = _PurchaseContractItem.PurchaseContract
                                                                        and $projection.PurchaseContractItem = _PurchaseContractItem.PurchaseContractItem
 {
     key  cast(AccountAssignment as accas) as AccountAssignment,

     key  PurchaseContractItem,

     key  PurchaseContract,

     IsDeleted,

     //CreationDate,

     @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
     Quantity,

     OrderQuantityUnit,

     MultipleAcctAssgmtDistrPercent,

     @Semantics.amount.currencyCode:'DocumentCurrency'
     PurgDocNetAmount,

     @ObjectModel.sapObjectNodeTypeReference:'Currency'
     DocumentCurrency,

     GLAccount,

     BusinessArea,

     CostCenter,

     SalesOrder,

     SalesOrderItem,

     SalesOrderScheduleLine,

     MasterFixedAsset,

     FixedAsset,

     OrderID,

     GoodsRecipientName,

     UnloadingPointName,

     ControllingArea,

     CostObject,

     ProfitCenter,

     //WBSElementInternalID,


     ProjectNetwork,

     cast( REInternalFinNumber as  recaimkeyfi ) as RealEstateObject,

     PartnerAccountNumber,

     cast(CommitmentItem as  fm_fipex ) as CommitmentItem,

     JointVentureRecoveryCode,

     FundsCenter,

     //Fund,


     FunctionalArea,

     SettlementReferenceDate,

     @ObjectModel.sapObjectNodeTypeReference:'SalesTaxCode'
     TaxCode,

     @ObjectModel.sapObjectNodeTypeReference:'TaxJurisdiction'
     TaxJurisdiction,

     @Semantics.amount.currencyCode: 'DocumentCurrency'
     NonDeductibleInputTaxAmount,

     CostCtrActivityType,

     BusinessProcess,

     EarmarkedFundsDocument,

     //EarmarkedFundsItem,


     GrantID,


     BudgetPeriod,
     _WBSElementByInternalKey.WBSElementExternalID,

    @ObjectModel.association.type:  [ #TO_COMPOSITION_ROOT]
    _PurchaseContract,

    @ObjectModel.association.type:  [ #TO_COMPOSITION_PARENT]
    _PurchaseContractItem
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCTRACCOUNT",
"I_WBSELEMENTBYINTERNALKEY"
],
"ASSOCIATED":
[
"A_PURCHASECONTRACTITEM_2",
"A_PURCHASECONTRACT_2"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More