I_PurgDocAccountAssignment
Purchasing Document Account Assignment
I_PurgDocAccountAssignment is a Basic CDS View that provides data about "Purchasing Document Account Assignment" in SAP S/4HANA. It reads from 1 data source (I_PurgDocAccountAssignmentBsc) and exposes 104 fields with key fields PurchasingDocument, PurchasingDocumentItem, AccountAssignmentNumber. It has 37 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_PurgDocAccountAssignmentBsc | I_PurgDocAccountAssignmentBsc | from |
Associations (37)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | I_PurchasingDocumentItem | _PurchasingDocumentItem | $projection.PurchasingDocument = _PurchasingDocumentItem.PurchasingDocument and $projection.PurchasingDocumentItem = _PurchasingDocumentItem.PurchasingDocumentItem |
| [0..1] | I_CostCenter | _CostCenter | $projection.CostCenter = _CostCenter.CostCenter and $projection.ControllingArea = _CostCenter.ControllingArea and $projection.ValidityDate <= _CostCenter.ValidityEndDate and $projection.ValidityDate >= _CostCenter.ValidityStartDate |
| [0..*] | I_CostCenterText | _CostCenterText | $projection.CostCenter = _CostCenterText.CostCenter and $projection.ControllingArea = _CostCenterText.ControllingArea and $projection.ValidityDate <= _CostCenterText.ValidityEndDate and $projection.ValidityDate >= _CostCenterText.ValidityStartDate |
| [0..*] | I_GLAccount | _GLAccount | $projection.GLAccount = _GLAccount.GLAccount |
| [0..*] | I_GLAccountText | _GLAccountText | $projection.GLAccount = _GLAccountText.GLAccount and $projection.ChartOfAccounts = _GLAccountText.ChartOfAccounts |
| [0..1] | I_BusinessArea | _BusinessArea | $projection.BusinessArea = _BusinessArea.BusinessArea |
| [0..*] | I_BusinessAreaText | _BusinessAreaText | $projection.BusinessArea = _BusinessAreaText.BusinessArea |
| [0..1] | I_ProfitCenter | _ProfitCenter | $projection.ControllingArea = _ProfitCenter.ControllingArea and $projection.ProfitCenter = _ProfitCenter.ProfitCenter and $projection.ValidityDate <= _ProfitCenter.ValidityEndDate and $projection.ValidityDate >= _ProfitCenter.ValidityStartDate |
| [0..*] | I_ProfitCenterText | _ProfitCenterText | $projection.ControllingArea = _ProfitCenterText.ControllingArea and $projection.ProfitCenter = _ProfitCenterText.ProfitCenter and $projection.ValidityDate <= _ProfitCenterText.ValidityEndDate |
| [0..1] | I_SalesOrder | _SalesOrder | $projection.SalesOrder = _SalesOrder.SalesOrder |
| [0..1] | I_SalesOrderItem | _SalesOrderItem | $projection.SalesOrderItem = _SalesOrderItem.SalesOrderItem and $projection.SalesOrder = _SalesOrderItem.SalesOrder |
| [0..1] | I_ControllingArea | _ControllingArea | $projection.ControllingArea = _ControllingArea.ControllingArea |
| [0..1] | I_SalesDocumentScheduleLine | _SalesDocumentScheduleLine | $projection.SalesOrder = _SalesDocumentScheduleLine.SalesDocument and $projection.SalesOrderItem = _SalesDocumentScheduleLine.SalesDocumentItem and $projection.SalesOrderScheduleLine = _SalesDocumentScheduleLine.ScheduleLine |
| [0..1] | I_WBSElementByInternalKey | _WBSElementByInternalKey | $projection.WBSElementInternalID = _WBSElementByInternalKey.WBSElementInternalID |
| [0..1] | I_WBSElementBasicData | _WBSElement | _WBSElement.WBSElementInternalID = $projection.WBSElementInternalID |
| [0..1] | I_FunctionalArea | _FunctionalArea | $projection.FunctionalArea = _FunctionalArea.FunctionalArea |
| [0..1] | I_CommitmentItemShortID | _CommitmentItemShortID | $projection.CommitmentItemShortID = _CommitmentItemShortID.CommitmentItemShortID |
| [0..*] | I_FunctionalAreaText | _FunctionalAreaText | $projection.FunctionalArea = _FunctionalAreaText.FunctionalArea |
| [0..1] | I_CostCenterActivityType | _CostCenterActivityType | $projection.ControllingArea = _CostCenterActivityType.ControllingArea and $projection.CostCtrActivityType = _CostCenterActivityType.CostCtrActivityType and $projection.ValidityDate <= _CostCenterActivityType.ValidityEndDate and $projection.ValidityDate >= _CostCenterActivityType.ValidityStartDate |
| [0..*] | I_CostCenterActivityTypeText | _CostCenterActivityTypeText | $projection.ControllingArea = _CostCenterActivityTypeText.ControllingArea and $projection.CostCtrActivityType = _CostCenterActivityTypeText.CostCtrActivityType and $projection.ValidityDate <= _CostCenterActivityTypeText.ValidityEndDate |
| [0..1] | I_BusinessProcess | _BusinessProcess | $projection.ControllingArea = _BusinessProcess.ControllingArea and $projection.BusinessProcess = _BusinessProcess.BusinessProcess |
| [0..*] | I_BusinessProcessText | _BusinessProcessText | $projection.ControllingArea = _BusinessProcessText.ControllingArea and $projection.BusinessProcess = _BusinessProcessText.BusinessProcess and $projection.ValidityDate <= _BusinessProcessText.ValidityEndDate |
| [0..*] | I_TaxCode | _TaxCode | $projection.TaxCode = _TaxCode.TaxCode |
| [0..*] | I_TaxCodeText | _TaxCodeText | $projection.TaxCode = _TaxCodeText.TaxCode |
| [0..*] | I_TaxJurisdiction | _TaxJurisdiction | $projection.TaxJurisdiction = _TaxJurisdiction.TaxJurisdiction |
| [0..*] | I_TaxJurisdictionText | _TaxJurisdictionText | $projection.TaxJurisdiction = _TaxJurisdictionText.TaxJurisdiction |
| [0..*] | I_FixedAsset | _FixedAssetWorklist | $projection.MasterFixedAsset = _FixedAssetWorklist.MasterFixedAsset and $projection.FixedAsset = _FixedAssetWorklist.FixedAsset |
| [0..*] | I_FixedAsset | _FixedAsset | $projection.MasterFixedAsset = _FixedAsset.MasterFixedAsset and $projection.FixedAsset = _FixedAsset.FixedAsset |
| [0..*] | I_FundStdVH | _FundStdVH | _FundStdVH.Fund = $projection.Fund |
| [0..1] | I_BudgetPeriodStdVH | _BudgetPeriodStdVH | _BudgetPeriodStdVH.BudgetPeriod = $projection.BudgetPeriod |
| [0..*] | I_FundsCenterStdVH | _FundsCenterStdVH | _FundsCenterStdVH.FundsCenter = $projection.FundsCenter association[0..*] to I_CommitmentItemStdVH as _CommitmentItemStdVH on _CommitmentItemStdVH.CommitmentItem = $projection.CommitmentItem association[0..*] to I_EmrkdFndsDocumentItemStdVH as _EarmarkedFundsStdVH on _EarmarkedFundsStdVH.EarmarkedFundsDocument = $projection.EarmarkedFundsDocument association[0..1] to I_FndsMgmtFuncnlAreaStdVH as _FndsMgmtFuncnlAreaStdVH on _FndsMgmtFuncnlAreaStdVH.FunctionalArea = $projection.FunctionalArea |
| [0..*] | I_MM_CostCenterValueHelp | _MM_CostCenterValueHelp | $projection.CostCenter = _MM_CostCenterValueHelp.CostCenter |
| [0..1] | I_WBSElementByInternalKey | _WBSElementByInternalKeyVH | $projection.WBSElementInternalID = _WBSElementByInternalKeyVH.WBSElementInternalID |
| [0..*] | I_MM_GLAccountVH | _MM_GLAccountVH | $projection.GLAccount = _MM_GLAccountVH.GLAccount |
| [0..1] | I_AcctgServiceDocumentTypeVH | _AcctgServiceDocumentTypeVH | $projection.ServiceDocumentType = _AcctgServiceDocumentTypeVH.ServiceDocumentType |
| [0..*] | I_AcctgServiceDocumentVH | _AcctgServiceDocumentVH | $projection.ServiceDocument = _AcctgServiceDocumentVH.ServiceDocument |
| [0..*] | I_AcctgServiceDocumentItemVH | _AcctgServiceDocumentItemVH | $projection.ServiceDocumentItem = _AcctgServiceDocumentItemVH.ServiceDocumentItem and $projection.ServiceDocument = _AcctgServiceDocumentItemVH.ServiceDocument |
Annotations (17)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.preserveKey | true | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| EndUserText.label | Purchasing Document Account Assignment | view | |
| VDM.viewType | #BASIC | view | |
| AbapCatalog.sqlViewName | IPDACCTASSGMT | view | |
| AccessControl.authorizationCheck | #PRIVILEGED_ONLY | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| UI.headerInfo.typeName | Account Assignment Details | view | |
| UI.headerInfo.typeNamePlural | Accounts | view | |
| UI.headerInfo.description.label | Account Assignment Number | view | |
| UI.headerInfo.description.value | AccountAssignmentNumber | view | |
| UI.headerInfo.title.label | Purchasing Document | view | |
| UI.headerInfo.title.value | PurchasingDocument | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view |
Fields (104)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | PurchasingDocument | PurchasingDocument | ||
| KEY | PurchasingDocumentItem | PurchasingDocumentItem | ||
| KEY | AccountAssignmentNumber | AccountAssignmentNumber | ||
| tobeclarifiedCostCenter | ||||
| MasterFixedAsset | MasterFixedAsset | |||
| ProjectNetwork | ProjectNetwork | |||
| OrderQuantityUnit | _PurchasingDocumentItem | OrderQuantityUnit | ||
| Quantity | Quantity | |||
| MultipleAcctAssgmtDistrPercent | MultipleAcctAssgmtDistrPercent | |||
| DocumentCurrency | _PurchasingDocumentItem | DocumentCurrency | ||
| PurgDocNetAmount | PurgDocNetAmount | |||
| IsDeleted | IsDeleted | |||
| GLAccount | GLAccount | |||
| BusinessArea | BusinessArea | |||
| SalesOrder | SalesOrder | |||
| SalesOrderItem | SalesOrderItem | |||
| SalesOrderScheduleLine | SalesOrderScheduleLine | |||
| FixedAsset | FixedAsset | |||
| OrderID | OrderID | |||
| UnloadingPointName | UnloadingPointName | |||
| ControllingArea | ControllingArea | |||
| CostObject | CostObject | |||
| ProfitabilitySegment | ||||
| ProfitabilitySegment_2 | ProfitabilitySegment | |||
| ProfitCenter | ProfitCenter | |||
| WBSElementInternalID | ||||
| WBSElementInternalID_2 | WBSElementInternalID | |||
| ProjectNetworkInternalID | ProjectNetworkInternalID | |||
| CommitmentItem | ||||
| CommitmentItemShortID | CommitmentItemShortID | |||
| FundsCenter | FundsCenter | |||
| Fund | Fund | |||
| FunctionalArea | FunctionalArea | |||
| LastChangedDate | LastChangedDate | |||
| CreationDate | CreationDate | |||
| GoodsRecepientName | GoodsRecepientName | |||
| GoodsRecipientName | GoodsRecipientName | |||
| IsFinallyInvoiced | IsFinallyInvoiced | |||
| RealEstateObject | ||||
| REInternalFinNumber | REInternalFinNumber | |||
| NetworkActivityInternalID | NetworkActivityInternalID | |||
| PartnerAccountNumber | PartnerAccountNumber | |||
| JointVentureRecoveryCode | JointVentureRecoveryCode | |||
| SettlementReferenceDate | SettlementReferenceDate | |||
| OrderInternalID | OrderInternalID | |||
| OrderIntBillOfOperationsItem | OrderIntBillOfOperationsItem | |||
| TaxCode | TaxCode | |||
| TaxJurisdiction | TaxJurisdiction | |||
| NonDeductibleInputTaxAmount | NonDeductibleInputTaxAmount | |||
| CostCtrActivityType | CostCtrActivityType | |||
| BusinessProcess | BusinessProcess | |||
| GrantID | GrantID | |||
| BudgetPeriod | BudgetPeriod | |||
| EarmarkedFundsDocument | EarmarkedFundsDocument | |||
| ValidityDate | Validity Date | |||
| ChartOfAccounts | _ControllingArea | ChartOfAccounts | ||
| EarmarkedFundsItem | ||||
| EarmarkedFundsDocumentItem | EarmarkedFundsDocumentItem | |||
| PubSecSplitBatchNumberID | PubSecSplitBatchNumberID | |||
| PubSecSplitAuthznGroup | PubSecSplitAuthznGroup | |||
| IsAcctLineFinal | IsAcctLineFinal | |||
| AcctLineFinalReason | AcctLineFinalReason | |||
| ServiceDocumentType | ServiceDocumentType | |||
| ServiceDocument | ServiceDocument | |||
| ServiceDocumentItem | ServiceDocumentItem | |||
| _CostCenter | _CostCenter | |||
| _BusinessArea | _BusinessArea | |||
| _ProfitCenter | _ProfitCenter | |||
| _SalesOrderItem | _SalesOrderItem | |||
| _SalesOrder | _SalesOrder | |||
| _ControllingArea | _ControllingArea | |||
| _GLAccount | _GLAccount | |||
| _SalesDocumentScheduleLine | _SalesDocumentScheduleLine | |||
| _WBSElementByInternalKey | _WBSElementByInternalKey | |||
| _WBSElement | _WBSElement | |||
| _CommitmentItemShortID | _CommitmentItemShortID | |||
| _FunctionalArea | _FunctionalArea | |||
| _CostCenterActivityType | _CostCenterActivityType | |||
| _BusinessProcess | _BusinessProcess | |||
| _TaxCode | _TaxCode | |||
| _TaxJurisdiction | _TaxJurisdiction | |||
| _FixedAssetWorklist | _FixedAssetWorklist | |||
| _FixedAsset | _FixedAsset | |||
| _CostCenterText | _CostCenterText | |||
| _GLAccountText | _GLAccountText | |||
| _BusinessAreaText | _BusinessAreaText | |||
| _ProfitCenterText | _ProfitCenterText | |||
| _FunctionalAreaText | _FunctionalAreaText | |||
| _CostCenterActivityTypeText | _CostCenterActivityTypeText | |||
| _BusinessProcessText | _BusinessProcessText | |||
| _TaxCodeText | _TaxCodeText | |||
| _TaxJurisdictionText | _TaxJurisdictionText | |||
| _FundStdVH | _FundStdVH | |||
| _BudgetPeriodStdVH | _BudgetPeriodStdVH | |||
| _FundsCenterStdVH | _FundsCenterStdVH | |||
| _CommitmentItemStdVH | _CommitmentItemStdVH | |||
| _EarmarkedFundsStdVH | _EarmarkedFundsStdVH | |||
| _FndsMgmtFuncnlAreaStdVH | _FndsMgmtFuncnlAreaStdVH | |||
| _MM_CostCenterValueHelp | _MM_CostCenterValueHelp | |||
| _WBSElementByInternalKeyVH | _WBSElementByInternalKeyVH | |||
| _MM_GLAccountVH | _MM_GLAccountVH | |||
| _AcctgServiceDocumentTypeVH | _AcctgServiceDocumentTypeVH | |||
| _AcctgServiceDocumentVH | _AcctgServiceDocumentVH | |||
| _AcctgServiceDocumentItemVH | _AcctgServiceDocumentItemVH |
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Purchasing Document Account Assignment'
@VDM.viewType: #BASIC
@AbapCatalog.sqlViewName: 'IPDACCTASSGMT'
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@ClientHandling.algorithm: #SESSION_VARIABLE
@UI.headerInfo: {
typeName: 'Account Assignment Details',
typeNamePlural: 'Accounts',
description.label: 'Account Assignment Number',
description.value: 'AccountAssignmentNumber',
title.label: 'Purchasing Document',
title.value: 'PurchasingDocument'
}
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MIXED
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
define view I_PurgDocAccountAssignment //with parameters P_CompanyCode:BUKRS , P_ChartOfAccounts:KTOPL
as select from I_PurgDocAccountAssignmentBsc
// association [1..1] to I_PurchasingDocument as _PurchasingDocument on $projection.PurchasingDocument = _PurchasingDocument.PurchasingDocument
association [1..1] to I_PurchasingDocumentItem as _PurchasingDocumentItem on $projection.PurchasingDocument = _PurchasingDocumentItem.PurchasingDocument
and $projection.PurchasingDocumentItem = _PurchasingDocumentItem.PurchasingDocumentItem
// association [0..1] to I_MM_CostCenterValueHelp as _CostCenterValueHelp on $projection.CostCenter = _CostCenterValueHelp.CostCenter
// and $projection.ControllingArea = _CostCenterValueHelp.ControllingArea
// and $projection.ValidityDate <= _CostCenterValueHelp.ValidityEndDate
// and $projection.ValidityDate >= _CostCenterValueHelp.ValidityStartDate
association [0..1] to I_CostCenter as _CostCenter on $projection.CostCenter = _CostCenter.CostCenter
and $projection.ControllingArea = _CostCenter.ControllingArea
and $projection.ValidityDate <= _CostCenter.ValidityEndDate
and $projection.ValidityDate >= _CostCenter.ValidityStartDate
association [0..*] to I_CostCenterText as _CostCenterText on $projection.CostCenter = _CostCenterText.CostCenter
and $projection.ControllingArea = _CostCenterText.ControllingArea
and $projection.ValidityDate <= _CostCenterText.ValidityEndDate
and $projection.ValidityDate >= _CostCenterText.ValidityStartDate
association [0..*] to I_GLAccount as _GLAccount on $projection.GLAccount = _GLAccount.GLAccount
//and $projection.CompanyCode = _GLAccount.CompanyCode // to change cardinality to [0..1] when uncommenting this
association [0..*] to I_GLAccountText as _GLAccountText on $projection.GLAccount = _GLAccountText.GLAccount
and $projection.ChartOfAccounts = _GLAccountText.ChartOfAccounts
association [0..1] to I_BusinessArea as _BusinessArea on $projection.BusinessArea = _BusinessArea.BusinessArea
association [0..*] to I_BusinessAreaText as _BusinessAreaText on $projection.BusinessArea = _BusinessAreaText.BusinessArea
association [0..1] to I_ProfitCenter as _ProfitCenter on $projection.ControllingArea = _ProfitCenter.ControllingArea
and $projection.ProfitCenter = _ProfitCenter.ProfitCenter
and $projection.ValidityDate <= _ProfitCenter.ValidityEndDate
and $projection.ValidityDate >= _ProfitCenter.ValidityStartDate
association [0..*] to I_ProfitCenterText as _ProfitCenterText on $projection.ControllingArea = _ProfitCenterText.ControllingArea
and $projection.ProfitCenter = _ProfitCenterText.ProfitCenter
and $projection.ValidityDate <= _ProfitCenterText.ValidityEndDate
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.SalesOrderItem
and $projection.SalesOrder = _SalesOrderItem.SalesOrder
association [0..1] to I_ControllingArea as _ControllingArea on $projection.ControllingArea = _ControllingArea.ControllingArea
association [0..1] to I_SalesDocumentScheduleLine as _SalesDocumentScheduleLine on $projection.SalesOrder = _SalesDocumentScheduleLine.SalesDocument
and $projection.SalesOrderItem = _SalesDocumentScheduleLine.SalesDocumentItem
and $projection.SalesOrderScheduleLine = _SalesDocumentScheduleLine.ScheduleLine
association [0..1] to I_WBSElementByInternalKey as _WBSElementByInternalKey on $projection.WBSElementInternalID = _WBSElementByInternalKey.WBSElementInternalID
association [0..1] to I_WBSElementBasicData as _WBSElement on _WBSElement.WBSElementInternalID = $projection.WBSElementInternalID
association [0..1] to I_FunctionalArea as _FunctionalArea on $projection.FunctionalArea = _FunctionalArea.FunctionalArea
association [0..1] to I_CommitmentItemShortID as _CommitmentItemShortID on $projection.CommitmentItemShortID = _CommitmentItemShortID.CommitmentItemShortID
association [0..*] to I_FunctionalAreaText as _FunctionalAreaText on $projection.FunctionalArea = _FunctionalAreaText.FunctionalArea
association [0..1] to I_CostCenterActivityType as _CostCenterActivityType on $projection.ControllingArea = _CostCenterActivityType.ControllingArea
and $projection.CostCtrActivityType = _CostCenterActivityType.CostCtrActivityType
and $projection.ValidityDate <= _CostCenterActivityType.ValidityEndDate
and $projection.ValidityDate >= _CostCenterActivityType.ValidityStartDate
association [0..*] to I_CostCenterActivityTypeText as _CostCenterActivityTypeText on $projection.ControllingArea = _CostCenterActivityTypeText.ControllingArea
and $projection.CostCtrActivityType = _CostCenterActivityTypeText.CostCtrActivityType
and $projection.ValidityDate <= _CostCenterActivityTypeText.ValidityEndDate
association [0..1] to I_BusinessProcess as _BusinessProcess on $projection.ControllingArea = _BusinessProcess.ControllingArea
and $projection.BusinessProcess = _BusinessProcess.BusinessProcess
association [0..*] to I_BusinessProcessText as _BusinessProcessText on $projection.ControllingArea = _BusinessProcessText.ControllingArea
and $projection.BusinessProcess = _BusinessProcessText.BusinessProcess
and $projection.ValidityDate <= _BusinessProcessText.ValidityEndDate
association [0..*] to I_TaxCode as _TaxCode on $projection.TaxCode = _TaxCode.TaxCode
association [0..*] to I_TaxCodeText as _TaxCodeText on $projection.TaxCode = _TaxCodeText.TaxCode
association [0..*] to I_TaxJurisdiction as _TaxJurisdiction on $projection.TaxJurisdiction = _TaxJurisdiction.TaxJurisdiction
association [0..*] to I_TaxJurisdictionText as _TaxJurisdictionText on $projection.TaxJurisdiction = _TaxJurisdictionText.TaxJurisdiction
//association[0..1] to I_CompanyCode as _CompanyCode on $projection.CompanyCode = _CompanyCode.CompanyCode
association [0..*] to I_FixedAsset as _FixedAssetWorklist on $projection.MasterFixedAsset = _FixedAssetWorklist.MasterFixedAsset
and $projection.FixedAsset = _FixedAssetWorklist.FixedAsset
// and $projection.CompanyCode = _FixedAssetWorklist.CompanyCode // to change cardinality to [0..1] when uncommenting this
association [0..*] to I_FixedAsset as _FixedAsset on $projection.MasterFixedAsset = _FixedAsset.MasterFixedAsset
and $projection.FixedAsset = _FixedAsset.FixedAsset
// and $projection.CompanyCode = _FixedAssetWorklist.CompanyCode // to change cardinality to [0..1] when uncommenting this
association [0..*] to I_FundStdVH as _FundStdVH on _FundStdVH.Fund = $projection.Fund
association [0..1] to I_BudgetPeriodStdVH as _BudgetPeriodStdVH on _BudgetPeriodStdVH.BudgetPeriod = $projection.BudgetPeriod
// association [0..1] to I_FundedProgramStdVH as _FundedProgramStdVH on _FundedProgramStdVH.FundedProgram = $projection.fundedprogram
association [0..*] to I_FundsCenterStdVH as _FundsCenterStdVH on _FundsCenterStdVH.FundsCenter = $projection.FundsCenter
association[0..*] to I_CommitmentItemStdVH as _CommitmentItemStdVH on _CommitmentItemStdVH.CommitmentItem = $projection.CommitmentItem
association[0..*] to I_EmrkdFndsDocumentItemStdVH as _EarmarkedFundsStdVH on _EarmarkedFundsStdVH.EarmarkedFundsDocument = $projection.EarmarkedFundsDocument
association[0..1] to I_FndsMgmtFuncnlAreaStdVH as _FndsMgmtFuncnlAreaStdVH on _FndsMgmtFuncnlAreaStdVH.FunctionalArea = $projection.FunctionalArea
association [0..*] to I_MM_CostCenterValueHelp as _MM_CostCenterValueHelp on $projection.CostCenter = _MM_CostCenterValueHelp.CostCenter
association [0..1] to I_WBSElementByInternalKey as _WBSElementByInternalKeyVH on $projection.WBSElementInternalID = _WBSElementByInternalKeyVH.WBSElementInternalID
association [0..*] to I_MM_GLAccountVH as _MM_GLAccountVH on $projection.GLAccount = _MM_GLAccountVH.GLAccount
association [0..1] to I_AcctgServiceDocumentTypeVH as _AcctgServiceDocumentTypeVH on $projection.ServiceDocumentType = _AcctgServiceDocumentTypeVH.ServiceDocumentType
association [0..*] to I_AcctgServiceDocumentVH as _AcctgServiceDocumentVH on $projection.ServiceDocument = _AcctgServiceDocumentVH.ServiceDocument
association [0..*] to I_AcctgServiceDocumentItemVH as _AcctgServiceDocumentItemVH on $projection.ServiceDocumentItem = _AcctgServiceDocumentItemVH.ServiceDocumentItem
and $projection.ServiceDocument = _AcctgServiceDocumentItemVH.ServiceDocument
{
key PurchasingDocument,
key PurchasingDocumentItem,
@ObjectModel.readOnly: 'undefined'
@ObjectModel.mandatory: 'undefined'
key AccountAssignmentNumber,
--@Consumption: { valueHelp: '_CostCenterValueHelp', semanticObject: 'CostCenter' }
@ObjectModel.foreignKey.association: '_CostCenter' -- to be clarified --
@ObjectModel.text.association: '_CostCenterText'
@ObjectModel.readOnly: 'undefined'
@ObjectModel.mandatory: 'undefined'
@Consumption.valueHelp: '_MM_CostCenterValueHelp'
CostCenter,
@ObjectModel.foreignKey.association: '_FixedAsset'
@ObjectModel.readOnly: 'undefined'
@ObjectModel.mandatory: 'undefined'
MasterFixedAsset,
@ObjectModel.readOnly: 'undefined'
@ObjectModel.mandatory: 'undefined'
ProjectNetwork,
@Semantics.unitOfMeasure: true
_PurchasingDocumentItem.OrderQuantityUnit,
@Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
@ObjectModel.readOnly: 'undefined'
@ObjectModel.mandatory: 'undefined'
Quantity,
@ObjectModel.readOnly: 'undefined'
@ObjectModel.mandatory: 'undefined'
MultipleAcctAssgmtDistrPercent,
@Semantics.currencyCode: true
_PurchasingDocumentItem.DocumentCurrency,
@Semantics.amount.currencyCode: 'DocumentCurrency'
@ObjectModel.readOnly: 'undefined'
@ObjectModel.mandatory: 'undefined'
PurgDocNetAmount,
@ObjectModel.readOnly: 'undefined'
@ObjectModel.mandatory: 'undefined'
IsDeleted,
@ObjectModel.foreignKey.association: '_GLAccount'
//@ObjectModel.text.association: '_GLAccountText'
@ObjectModel.readOnly: 'undefined'
@ObjectModel.mandatory: 'undefined'
@Consumption.valueHelp: '_MM_GLAccountVH'
GLAccount,
@ObjectModel.foreignKey.association: '_BusinessArea'
@ObjectModel.text.association: '_BusinessAreaText'
@ObjectModel.readOnly: 'undefined'
@ObjectModel.mandatory: 'undefined'
BusinessArea,
@ObjectModel.foreignKey.association: '_SalesOrder'
@ObjectModel.readOnly: 'undefined'
@ObjectModel.mandatory: 'undefined'
SalesOrder,
@ObjectModel.foreignKey.association: '_SalesOrderItem'
@ObjectModel.readOnly: 'undefined'
@ObjectModel.mandatory: 'undefined'
SalesOrderItem,
@ObjectModel.foreignKey.association: '_SalesDocumentScheduleLine'
@ObjectModel.readOnly: 'undefined'
@ObjectModel.mandatory: 'undefined'
SalesOrderScheduleLine,
@ObjectModel.foreignKey.association: '_FixedAsset'
@ObjectModel.readOnly: 'undefined'
@ObjectModel.mandatory: 'undefined'
FixedAsset,
@ObjectModel.readOnly: 'undefined'
@ObjectModel.mandatory: 'undefined'
OrderID,
@ObjectModel.readOnly: 'undefined'
@ObjectModel.mandatory: 'undefined'
UnloadingPointName,
@ObjectModel.foreignKey.association: '_ControllingArea'
@ObjectModel.readOnly: 'undefined'
@ObjectModel.mandatory: 'undefined'
ControllingArea,
@ObjectModel.readOnly: 'undefined'
@ObjectModel.mandatory: 'undefined'
CostObject,
@ObjectModel.readOnly: 'undefined'
@ObjectModel.mandatory: 'undefined'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'ProfitabilitySegment_2'
cast( ProfitabilitySegment as rkeobjnr ) as ProfitabilitySegment,
ProfitabilitySegment as ProfitabilitySegment_2,
@ObjectModel.foreignKey.association: '_ProfitCenter'
@ObjectModel.text.association: '_ProfitCenterText'
@ObjectModel.readOnly: 'undefined'
@ObjectModel.mandatory: 'undefined'
ProfitCenter,
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'WBSElementInternalID_2'
@ObjectModel.foreignKey.association: '_WBSElementByInternalKey'
@ObjectModel.readOnly: 'undefined'
@ObjectModel.mandatory: 'undefined'
cast( WBSElementInternalID as ps_psp_pnr ) as WBSElementInternalID,
@ObjectModel.readOnly: 'undefined'
@ObjectModel.mandatory: 'undefined'
WBSElementInternalID as WBSElementInternalID_2,
@ObjectModel.readOnly: 'undefined'
@ObjectModel.mandatory: 'undefined'
ProjectNetworkInternalID,
@ObjectModel.readOnly: 'undefined'
@ObjectModel.mandatory: 'undefined'
@Consumption.valueHelp: '_CommitmentItemStdVH'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'CommitmentItemShortID'
cast( CommitmentItemShortID as fipos ) as CommitmentItem,
CommitmentItemShortID,
@ObjectModel.readOnly: 'undefined'
@ObjectModel.mandatory: 'undefined'
@Consumption.valueHelp: '_FundsCenterStdVH'
FundsCenter,
@ObjectModel.readOnly: 'undefined'
@ObjectModel.mandatory: 'undefined'
@Consumption.valueHelp: '_FundStdVH'
Fund,
//@ObjectModel.readOnly: 'undefined'
//@ObjectModel.mandatory: 'undefined'
//geber as Funds,//Deprectaed . Please use AssetFund
@ObjectModel.foreignKey.association: '_FunctionalArea'
@ObjectModel.text.association: '_FunctionalAreaText'
@ObjectModel.readOnly: 'undefined'
@ObjectModel.mandatory: 'undefined'
@Consumption.valueHelp: '_FndsMgmtFuncnlAreaStdVH'
FunctionalArea,
LastChangedDate, // obsolete, do not use
@ObjectModel.readOnly: 'undefined'
@ObjectModel.mandatory: 'undefined'
CreationDate, //new , modified
@ObjectModel.readOnly: 'undefined'
@ObjectModel.mandatory: 'undefined'
GoodsRecepientName, //obsolete, use GoodsRecipientName instead
@ObjectModel.readOnly: 'undefined'
@ObjectModel.mandatory: 'undefined'
GoodsRecipientName, //new , added
@ObjectModel.readOnly: 'undefined'
@ObjectModel.mandatory: 'undefined'
IsFinallyInvoiced, //new , added
@ObjectModel.readOnly: 'undefined'
@ObjectModel.mandatory: 'undefined'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'REInternalFinNumber'
cast( REInternalFinNumber as imkey ) as RealEstateObject, //new , added
REInternalFinNumber,
@ObjectModel.readOnly: 'undefined'
@ObjectModel.mandatory: 'undefined'
NetworkActivityInternalID, //new, added
@ObjectModel.readOnly: 'undefined'
@ObjectModel.mandatory: 'undefined'
PartnerAccountNumber, //new, added
@ObjectModel.readOnly: 'undefined'
@ObjectModel.mandatory: 'undefined'
JointVentureRecoveryCode, // new, added
@ObjectModel.readOnly: 'undefined'
@ObjectModel.mandatory: 'undefined'
SettlementReferenceDate, // new, added
@ObjectModel.readOnly: 'undefined'
@ObjectModel.mandatory: 'undefined'
OrderInternalID, // new, added
@ObjectModel.readOnly: 'undefined'
@ObjectModel.mandatory: 'undefined'
OrderIntBillOfOperationsItem, // new, added
@ObjectModel.foreignKey.association: '_TaxCode'
@ObjectModel.text.association: '_TaxCodeText'
@ObjectModel.readOnly: 'undefined'
@ObjectModel.mandatory: 'undefined'
TaxCode, // new, added
@ObjectModel.foreignKey.association: '_TaxJurisdiction'
@ObjectModel.text.association: '_TaxJurisdictionText'
@ObjectModel.readOnly: 'undefined'
@ObjectModel.mandatory: 'undefined'
TaxJurisdiction, // new, added
@ObjectModel.readOnly: 'undefined'
@ObjectModel.mandatory: 'undefined'
@Semantics.amount.currencyCode: 'DocumentCurrency'
NonDeductibleInputTaxAmount, //new, added
@ObjectModel.foreignKey.association: '_CostCenterActivityType'
@ObjectModel.text.association: '_CostCenterActivityTypeText'
@ObjectModel.readOnly: 'undefined'
@ObjectModel.mandatory: 'undefined'
CostCtrActivityType, // new, added
@ObjectModel.foreignKey.association: '_BusinessProcess'
@ObjectModel.text.association: '_BusinessProcessText'
@ObjectModel.readOnly: 'undefined'
@ObjectModel.mandatory: 'undefined'
BusinessProcess, // new, added
@ObjectModel.readOnly: 'undefined'
@ObjectModel.mandatory: 'undefined'
@Consumption.valueHelp: '_BudgetPeriodStdVH'
GrantID, // new, added
@ObjectModel.readOnly: 'undefined'
@ObjectModel.mandatory: 'undefined'
// @Consumption.valueHelp: ' '
BudgetPeriod, // new, added
@ObjectModel.readOnly: 'undefined'
@ObjectModel.mandatory: 'undefined'
@Consumption.valueHelp: '_EarmarkedFundsStdVH'
EarmarkedFundsDocument, // new, added
@Semantics.businessDate.at: true
@ObjectModel.readOnly: 'undefined'
@ObjectModel.mandatory: 'undefined'
@EndUserText.label: 'Validity Date'
$session.system_date as ValidityDate, // new, added
_ControllingArea.ChartOfAccounts as ChartOfAccounts,
cast( EarmarkedFundsDocumentItem as kblpos) as EarmarkedFundsItem, // new, added
EarmarkedFundsDocumentItem, // new, added
PubSecSplitBatchNumberID, // new, added
PubSecSplitAuthznGroup, // new, added
IsAcctLineFinal, // new, added
AcctLineFinalReason, // new, added
@ObjectModel.readOnly: 'undefined'
@ObjectModel.mandatory: 'undefined'
@Consumption.valueHelp: '_AcctgServiceDocumentTypeVH'
ServiceDocumentType, // new, added
@ObjectModel.readOnly: 'undefined'
@ObjectModel.mandatory: 'undefined'
@Consumption.valueHelp: '_AcctgServiceDocumentVH'
ServiceDocument, // new, added
@ObjectModel.readOnly: 'undefined'
@ObjectModel.mandatory: 'undefined'
@Consumption.valueHelp: '_AcctgServiceDocumentItemVH'
ServiceDocumentItem, // new, added
//@ObjectModel.foreignKey.association: '_CompanyCode'
//@UI:{
// fieldGroup: {qualifier: 'ThirdGroup', position: 10, importance: #HIGH}
// }
//@ObjectModel.readOnly: 'undefined'
//@ObjectModel.mandatory: 'undefined'
//_GLAccount.CompanyCode as CompanyCode, //new, added
//_CostCenterValueHelp,
_CostCenter,
_BusinessArea,
_ProfitCenter,
_SalesOrderItem,
_SalesOrder,
_ControllingArea,
_GLAccount,
_SalesDocumentScheduleLine, // new, added
_WBSElementByInternalKey, // new, added
_WBSElement,
_CommitmentItemShortID,
_FunctionalArea, // new, added
_CostCenterActivityType, // new, added
_BusinessProcess, // new, added
_TaxCode, // new, added
_TaxJurisdiction, //new, added
//_CompanyCode, // new, added
_FixedAssetWorklist,
_FixedAsset,
_CostCenterText, // new, added
_GLAccountText, //new, added
_BusinessAreaText, //new, added
_ProfitCenterText, //new, added
_FunctionalAreaText, //new, added
_CostCenterActivityTypeText, //new, added
_BusinessProcessText, // new, added
_TaxCodeText, //new, added
_TaxJurisdictionText, // new, added
_FundStdVH,
_BudgetPeriodStdVH,
_FundsCenterStdVH,
_CommitmentItemStdVH,
_EarmarkedFundsStdVH,
_FndsMgmtFuncnlAreaStdVH,
_MM_CostCenterValueHelp,
_WBSElementByInternalKeyVH,
_MM_GLAccountVH,
_AcctgServiceDocumentTypeVH,
_AcctgServiceDocumentVH,
_AcctgServiceDocumentItemVH
}
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