I_PURCTRACCOUNT
Account Assignment For Contracts
I_PURCTRACCOUNT is a CDS View in S/4HANA. Account Assignment For Contracts. It contains 54 fields. 8 CDS views read from this table.
CDS Views using this table (8)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| A_PurchaseContractAccount_2 | view | from | COMPOSITE | Purchase Contract Item Acc. Assignment |
| A_PurCtrAccount | view | from | COMPOSITE | Account Assignment |
| C_ContractFactSheetAcctAssgmt | view | from | CONSUMPTION | Contract FactSheet Account Assignment |
| I_PurCtrAccountWD | view | from | TRANSACTIONAL | BO View for I_PurCtrAccountWD |
| P_ContractItemAcctMntr | view | from | CONSUMPTION | Private View for Calculated Fields |
| P_FixedAssetDescription | view | from | CONSUMPTION | Fixed Asset Description |
| R_PPS_PurContrAcctAssignmentTP | view_entity | from | TRANSACTIONAL | Purchase Contract Account - TP |
| R_PurContrAccountTP | view_entity | from | TRANSACTIONAL | Purchase Contract Account |
Fields (54)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | AccountAssignment | AccountAssignment,AccountAssignmentForEdit,AccountAssignmentNumber | 3 |
| KEY | PurchaseContract | PurchaseContract,PurchaseContractForEdit | 4 |
| KEY | PurchaseContractItem | PurchaseContractItem,PurchaseContractItemForEdit | 4 |
| _CostCenterText | _CostCenterText | 1 | |
| _FixedAsset | _FixedAsset | 1 | |
| BudgetPeriod | BudgetPeriod | 4 | |
| BusinessArea | BusinessArea | 4 | |
| BusinessProcess | BusinessProcess | 3 | |
| CommitmentItemShortID | CommitmentItemShortID | 2 | |
| ControllingArea | ControllingArea | 4 | |
| CostCenter | CostCenter | 4 | |
| CostCtrActivityType | CostCtrActivityType | 4 | |
| CostObject | CostObject | 4 | |
| DocumentCurrency | DocumentCurrency | 4 | |
| EarmarkedFundsDocument | EarmarkedFundsDocument | 4 | |
| FixedAsset | FixedAsset | 4 | |
| FunctionalArea | FunctionalArea | 4 | |
| Fund | Fund | 4 | |
| FundsCenter | FundsCenter | 3 | |
| GLAccount | GLAccount | 4 | |
| GoodsRecipientName | GoodsRecipientName | 4 | |
| GrantID | GrantID | 4 | |
| IsDeleted | IsDeleted | 4 | |
| IsFinallyInvoiced | IsFinallyInvoiced | 4 | |
| JointVentureRecoveryCode | JointVentureRecoveryCode | 4 | |
| LastChangedDate | LastChangedDate | 3 | |
| MasterFixedAsset | MasterFixedAsset | 4 | |
| MultipleAcctAssgmtDistrPercent | MultipleAcctAssgmtDistrPercent | 4 | |
| NetworkActivityDescription | NetworkActivityDescription | 1 | |
| NetworkActivityInternalID | NetworkActivityInternalID | 4 | |
| NonDeductibleInputTaxAmount | NonDeductibleInputTaxAmount | 4 | |
| OrderID | OrderID | 4 | |
| OrderIntBillOfOperationsItem | OrderIntBillOfOperationsItem | 3 | |
| OrderInternalID | OrderInternalID | 4 | |
| OrderQuantityUnit | OrderQuantityUnit | 4 | |
| PartnerAccountNumber | PartnerAccountNumber | 4 | |
| ProfitabilitySegment_2 | ProfitabilitySegment | 1 | |
| ProfitCenter | ProfitCenter | 4 | |
| ProjectNetwork | ProjectNetwork | 4 | |
| ProjectNetworkInternalID | ProjectNetworkInternalID | 4 | |
| PurgDocNetAmount | PurgDocNetAmount | 4 | |
| Quantity | Quantity | 4 | |
| SalesOrder | SalesOrder | 4 | |
| SalesOrderItem | SalesOrderItem | 4 | |
| SalesOrderScheduleLine | SalesOrderScheduleLine | 4 | |
| SettlementReferenceDate | SettlementReferenceDate | 4 | |
| TaxCode | TaxCode | 4 | |
| TaxJurisdiction | TaxJurisdiction | 4 | |
| UnloadingPointName | UnloadingPointName | 4 | |
| ValidityDate | ValidityDate | 4 | |
| WBSDescription | WBSDescription | 2 | |
| WBSElement | WBSElement | 1 | |
| WBSElementExternalID | WBSElement,WBSElementExternalID | 2 | |
| WBSElementInternalID_2 | WBSElementInternalID | 1 |
@AbapCatalog.sqlViewName: 'IPURCTRACCNT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'Account Assignment For Contracts'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MIXED
@ClientHandling.algorithm: #SESSION_VARIABLE
//@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
define view I_PurCtrAccount
as select from I_PurgDocAccountAssignment
inner join I_PurchaseContractItem on I_PurgDocAccountAssignment.PurchasingDocument = I_PurchaseContractItem.PurchaseContract
and I_PurgDocAccountAssignment.PurchasingDocumentItem = I_PurchaseContractItem.PurchaseContractItem
association [1..1] to I_PurchaseContract as _PurchaseContract on _PurchaseContract.PurchaseContract = $projection.PurchaseContract
association [1..1] to I_PurchaseContractItem as _PurchaseContractItem on _PurchaseContractItem.PurchaseContract = $projection.PurchaseContract
and _PurchaseContractItem.PurchaseContractItem = $projection.PurchaseContractItem
association [1..1] to I_REObjectByIntFinNumber as _RealEstateObject on _RealEstateObject.REInternalFinNumber = $projection.REInternalFinNumber
association [1..1] to I_NetworkActivity as _NetworkActivity on $projection.ProjectNetwork = _NetworkActivity.ProjectNetwork //^3342349
and $projection.ProjectNetworkInternalID = _NetworkActivity.ProjectNetworkInternalID
and $projection.NetworkActivityInternalID = _NetworkActivity.NetworkActivityInternalID //v3342349
{
key AccountAssignmentNumber as AccountAssignment,
key PurchasingDocumentItem as PurchaseContractItem,
key PurchasingDocument as PurchaseContract,
CostCenter,
MasterFixedAsset,
ProjectNetwork,
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION' //^3342349
cast (_NetworkActivity.NetworkActivity as ps_s4_vornr) as NetworkActivity,
_NetworkActivity.NetworkActivityDescription, //v3342349
Quantity,
I_PurgDocAccountAssignment.OrderQuantityUnit,
MultipleAcctAssgmtDistrPercent,
PurgDocNetAmount,
I_PurgDocAccountAssignment.DocumentCurrency,
IsDeleted,
GLAccount,
BusinessArea,
SalesOrder,
SalesOrderItem,
SalesOrderScheduleLine,
FixedAsset,
OrderID,
UnloadingPointName,
ControllingArea,
CostObject,
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'ProfitabilitySegment_2'
ProfitabilitySegment,
ProfitabilitySegment_2,
ProfitCenter,
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'WBSElementInternalID_2'
WBSElementInternalID,
cast( WBSElementInternalID as ps_s4_pspnr ) as WBSElementInternalID_2,
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: '_WBSElement.WBSElementExternalID'
_WBSElementByInternalKey.WBSElement,
_WBSElementByInternalKey.WBSDescription,
_WBSElement.WBSElementExternalID,
ProjectNetworkInternalID,
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'CommitmentItemShortID'
CommitmentItem,
cast(CommitmentItem as fmis_ci_internalname) as CommitmentItemShortID,
// FundsManagementCenter as FundsCenter,
FundsCenter,
Fund,
FunctionalArea,
cast(LastChangedDate as abap.dats) as LastChangedDate,
GoodsRecepientName as GoodsRecipientName, //new , added
IsFinallyInvoiced, //new , added
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'REInternalFinNumber'
RealEstateObject, //new , added
REInternalFinNumber, //new , added
NetworkActivityInternalID, //new, added
PartnerAccountNumber, //new, added
JointVentureRecoveryCode, // new, added
SettlementReferenceDate, // new, added
OrderInternalID, // new, added
OrderIntBillOfOperationsItem, // new, added
I_PurgDocAccountAssignment.TaxCode, // new, added
TaxJurisdiction, // new, added
NonDeductibleInputTaxAmount, //new, added
CostCtrActivityType, // new, added
BusinessProcess, // new, added
GrantID, // new, added
BudgetPeriod, // new, added
EarmarkedFundsDocument, // new, added
ValidityDate, // new, added
@ObjectModel.association.type: [ #TO_COMPOSITION_PARENT]
_PurchaseContractItem,
@ObjectModel.association.type: [ #TO_COMPOSITION_ROOT]
_PurchaseContract,
_CostCenter,
_BusinessArea,
_ProfitCenter,
_SalesOrderItem,
_SalesOrder,
_ControllingArea,
_NetworkActivity, //3342349
_SalesDocumentScheduleLine, // new, added
_WBSElementByInternalKey, // new, added
_WBSElement,
_FunctionalArea, // new, added
_CostCenterActivityType, // new, added
_BusinessProcess, // new, added
_FixedAssetWorklist, // new, added
_CostCenterText, // new, added
_RealEstateObject, //new, added
_BusinessAreaText, //new, added
_ProfitCenterText, //new, added
_FunctionalAreaText, //new, added
_CostCenterActivityTypeText, //new, added
_BusinessProcessText, // new, added
_GLAccount,
_FixedAsset
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_NETWORKACTIVITY",
"I_PURCHASECONTRACTITEM",
"I_PURGDOCACCOUNTASSIGNMENT",
"I_WBSELEMENTBASICDATA",
"I_WBSELEMENTBYINTERNALKEY"
],
"ASSOCIATED":
[
"I_BUSINESSAREA",
"I_BUSINESSAREATEXT",
"I_BUSINESSPROCESS",
"I_BUSINESSPROCESSTEXT",
"I_CONTROLLINGAREA",
"I_COSTCENTER",
"I_COSTCENTERACTIVITYTYPE",
"I_COSTCENTERACTIVITYTYPETEXT",
"I_COSTCENTERTEXT",
"I_FIXEDASSET",
"I_FUNCTIONALAREA",
"I_FUNCTIONALAREATEXT",
"I_GLACCOUNT",
"I_NETWORKACTIVITY",
"I_PROFITCENTER",
"I_PROFITCENTERTEXT",
"I_PURCHASECONTRACT",
"I_PURCHASECONTRACTITEM",
"I_REOBJECTBYINTFINNUMBER",
"I_SALESDOCUMENTSCHEDULELINE",
"I_SALESORDER",
"I_SALESORDERITEM",
"I_WBSELEMENTBASICDATA",
"I_WBSELEMENTBYINTERNALKEY"
],
"BASE":
[
"I_PURGDOCACCOUNTASSIGNMENT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/