R_CADocumentGLItemTP_2
Document General Ledger Item - TP
R_CADocumentGLItemTP_2 is a Transactional CDS View that provides data about "Document General Ledger Item - TP" in SAP S/4HANA. It reads from 1 data source (I_CADocumentGLItemEnhanced) and exposes 113 fields with key fields CADocumentNumber, CAGLItemNumber. It has 1 association to related views. Part of development package RAP_FICA_CADOC.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_CADocumentGLItemEnhanced | I_CADocumentGLItemEnhanced | from |
Associations (1)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | E_CADocumentGLItem | _Extension | $projection.CADocumentNumber = _Extension.CADocumentNumber and $projection.CAGLItemNumber = _Extension.CAGLItemNumber |
Annotations (9)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #MANDATORY | view | |
| EndUserText.label | Document General Ledger Item - TP | view | |
| ObjectModel.modelingPattern | #NONE | view | |
| ObjectModel.sapObjectNodeType.name | ContrAcctgDocumentGenLdgrItem | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #XXL | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view | |
| VDM.viewType | #TRANSACTIONAL | view |
Fields (113)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | CADocumentNumber | CADocumentNumber | ||
| KEY | CAGLItemNumber | CAGLItemNumber | ||
| CompanyCode | CompanyCode | |||
| BusinessArea | BusinessArea | |||
| BusinessPlace | BusinessPlace | |||
| Segment | Segment | |||
| ProfitCenter | ProfitCenter | |||
| PartnerCompany | PartnerCompany | |||
| GLAccount | GLAccount | |||
| WBSElementInternalID | WBSElementInternalID | |||
| ValueDate | ValueDate | |||
| CAExchangeRate | CAExchangeRate | |||
| ExchRateIsIndirectQuotation | ExchRateIsIndirectQuotation | |||
| TransactionCurrency | TransactionCurrency | |||
| Currency | Currency | |||
| AdditionalCurrency1 | AdditionalCurrency1 | |||
| AdditionalCurrency2 | AdditionalCurrency2 | |||
| CAAmountInLocalCurrency | CAAmountInLocalCurrency | |||
| CAAmountInTransactionCurrency | CAAmountInTransactionCurrency | |||
| CAAmountInSecondCurrency | CAAmountInSecondCurrency | |||
| CAAmountInThirdCurrency | CAAmountInThirdCurrency | |||
| CAAccountAssignmentCategory | CAAccountAssignmentCategory | |||
| CAAccountAssignment | CAAccountAssignment | |||
| CostCenter | CostCenter | |||
| SalesOrder | SalesOrder | |||
| SalesOrderItem | SalesOrderItem | |||
| CAReconciliationKey | CAReconciliationKey | |||
| CAInternalPostingReasonCode | CAInternalPostingReasonCode | |||
| CANegativePostingControlCode | CANegativePostingControlCode | |||
| CAGLPostingCurrency | CAGLPostingCurrency | |||
| LedgerGroup | LedgerGroup | |||
| ProfitabilitySegment_2 | ProfitabilitySegment_2 | |||
| ProfitabilitySegmentChanges | ProfitabilitySegmentChanges | |||
| PlanningLevel | PlanningLevel | |||
| CARepetitionGroup | CARepetitionGroup | |||
| CATransactionKeyAccountDetn | CATransactionKeyAccountDetn | |||
| ConditionType | ConditionType | |||
| CAIsSeparateLineItemInGL | CAIsSeparateLineItemInGL | |||
| QuantityInBaseUnit | QuantityInBaseUnit | |||
| BaseUnit | BaseUnit | |||
| CAGroupingKeyDocumentItems | CAGroupingKeyDocumentItems | |||
| TaxCode | TaxCode | |||
| CASupplementaryTaxCode | CASupplementaryTaxCode | |||
| CAWithholdingTaxSupplement | CAWithholdingTaxSupplement | |||
| CAOtherTaxCode | CAOtherTaxCode | |||
| CAGroupingCodeForTaxItems | CAGroupingCodeForTaxItems | |||
| TaxJurisdiction | TaxJurisdiction | |||
| CAEnteredTaxJurisdictionCode | CAEnteredTaxJurisdictionCode | |||
| CATaxJurisdictionLevelCounter | CATaxJurisdictionLevelCounter | |||
| CATaxExceptionID | CATaxExceptionID | |||
| CATaxDate | CATaxDate | |||
| CATaxBaseAmountInLocalCurrency | CATaxBaseAmountInLocalCurrency | |||
| CATaxBaseAmount | CATaxBaseAmount | |||
| CANonDeductibleTxAmtInDocCrcy | CANonDeductibleTxAmtInDocCrcy | |||
| CANonDeductibleTxAmtInLoclCrcy | CANonDeductibleTxAmtInLoclCrcy | |||
| CAContainsNonDeductibleInptTax | CAContainsNonDeductibleInptTax | |||
| CATaxRate | CATaxRate | |||
| GrossIncomeTaxActivityCode | GrossIncomeTaxActivityCode | |||
| EmploymentTaxDistributionType | EmploymentTaxDistributionType | |||
| CATaxPortionInLocalCurrency | CATaxPortionInLocalCurrency | |||
| CATaxPortionInTransCurrency | CATaxPortionInTransCurrency | |||
| CATaxIsCalculatedExternally | CATaxIsCalculatedExternally | |||
| CAAltvExchangeRateSetCode | CAAltvExchangeRateSetCode | |||
| TaxCountry | TaxCountry | |||
| TransToTaxCntryCrcyCnvrsnFctr | TransToTaxCntryCrcyCnvrsnFctr | |||
| CAIsCashFlowItem | CAIsCashFlowItem | |||
| CACashFlowAccount | CACashFlowAccount | |||
| CACashFlowCompanyCode | CACashFlowCompanyCode | |||
| HouseBank | HouseBank | |||
| HouseBankAccount | HouseBankAccount | |||
| QuantitySignCode | QuantitySignCode | |||
| BankStatementShortID | BankStatementShortID | |||
| BankStatementItem | BankStatementItem | |||
| CashManagementLinkType | CashManagementLinkType | |||
| CashManagementLink | CashManagementLink | |||
| CAItmIsCreatedByPostgInterface | CAItmIsCreatedByPostgInterface | |||
| CAProfitAnalysisUpdtIsDirect | CAProfitAnalysisUpdtIsDirect | |||
| CAInvcgGroupingKey | CAInvcgGroupingKey | |||
| CACtrlFieldForAcctAssgmtDistr | CACtrlFieldForAcctAssgmtDistr | |||
| CAUpdateMethodForFundsMgmt | CAUpdateMethodForFundsMgmt | |||
| OriginalFinancialMgmtArea | OriginalFinancialMgmtArea | |||
| OriglYearForFinMgmtAcctAssgmt | OriglYearForFinMgmtAcctAssgmt | |||
| EarmarkedFundsDocument | EarmarkedFundsDocument | |||
| ChartOfAccounts | ChartOfAccounts | |||
| Country | Country | |||
| TaxCalculationProcedure | TaxCalculationProcedure | |||
| _CADocument | _CADocument | |||
| _BaseUnit | _BaseUnit | |||
| _BusinessArea | _BusinessArea | |||
| _CAAccountAssignmentCategory | _CAAccountAssignmentCategory | |||
| _CAAcctAssgmtDistrCode | _CAAcctAssgmtDistrCode | |||
| _CAAcctDetnTransKey | _CAAcctDetnTransKey | |||
| _CAAltvExchangeRateSetCode | _CAAltvExchangeRateSetCode | |||
| _CAEuroConversionStatus | _CAEuroConversionStatus | |||
| _CAIntPostingReasonCode | _CAIntPostingReasonCode | |||
| _CANegativePostingCtrlCode | _CANegativePostingCtrlCode | |||
| _CANonDcblInputTaxCode | _CANonDcblInputTaxCode | |||
| _CAOtherTaxCode | _CAOtherTaxCode | |||
| _CashFlowAccount | _CashFlowAccount | |||
| _CashFlowCompanyCode | _CashFlowCompanyCode | |||
| _CAWithholdingTaxSupplement | _CAWithholdingTaxSupplement | |||
| _ChartOfAccounts | _ChartOfAccounts | |||
| _CompanyCode | _CompanyCode | |||
| _CompanyCodeCurrency | _CompanyCodeCurrency | |||
| _Country | _Country | |||
| _GLAccount | _GLAccount | |||
| _GLPostingCurrency | _GLPostingCurrency | |||
| _ProfitCenter | _ProfitCenter | |||
| _PartnerCompany | _PartnerCompany | |||
| _Segment | _Segment | |||
| _TaxCountry | _TaxCountry | |||
| _TransactionCurrency | _TransactionCurrency | |||
| _WBSElementBasicData | _WBSElementBasicData |
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Document General Ledger Item - TP'
@ObjectModel: { modelingPattern: #NONE,
//representativeKey: 'CAGLItemNumber',
sapObjectNodeType.name: 'ContrAcctgDocumentGenLdgrItem',
usageType: { dataClass: #TRANSACTIONAL,
serviceQuality: #C,
sizeCategory: #XXL } }
@VDM: { lifecycle.contract.type: #SAP_INTERNAL_API,
viewType: #TRANSACTIONAL }
define view entity R_CADocumentGLItemTP_2
as select from I_CADocumentGLItemEnhanced
association to parent R_CADocumentTP_2 as _CADocument on _CADocument.CADocumentNumber = $projection.CADocumentNumber
// Key User Extensibility. Is registered in transaction SCFD_REGISTRY. Do not change E_CADocumentGLItem or alias _Extension without adopting CFD regestry entry
association [1..1] to E_CADocumentGLItem as _Extension on $projection.CADocumentNumber = _Extension.CADocumentNumber
and $projection.CAGLItemNumber = _Extension.CAGLItemNumber
{
//I_CADocumentGLItem
key CADocumentNumber,
key CAGLItemNumber,
CompanyCode,
BusinessArea,
BusinessPlace,
Segment,
ProfitCenter,
PartnerCompany,
GLAccount,
WBSElementInternalID,
ValueDate,
CAExchangeRate,
ExchRateIsIndirectQuotation,
TransactionCurrency,
Currency,
AdditionalCurrency1,
AdditionalCurrency2,
CAAmountInLocalCurrency,
CAAmountInTransactionCurrency,
CAAmountInSecondCurrency,
CAAmountInThirdCurrency,
CAAccountAssignmentCategory,
CAAccountAssignment,
CostCenter,
SalesOrder,
SalesOrderItem,
CAReconciliationKey,
CAInternalPostingReasonCode,
CANegativePostingControlCode,
CAGLPostingCurrency,
LedgerGroup,
ProfitabilitySegment_2,
ProfitabilitySegmentChanges,
PlanningLevel,
CARepetitionGroup,
CATransactionKeyAccountDetn,
ConditionType,
CAIsSeparateLineItemInGL,
QuantityInBaseUnit,
BaseUnit,
CAGroupingKeyDocumentItems,
TaxCode,
CASupplementaryTaxCode,
CAWithholdingTaxSupplement,
CAOtherTaxCode,
CAGroupingCodeForTaxItems,
TaxJurisdiction,
CAEnteredTaxJurisdictionCode,
CATaxJurisdictionLevelCounter,
CATaxExceptionID,
CATaxDate,
CATaxBaseAmountInLocalCurrency,
CATaxBaseAmount,
CANonDeductibleTxAmtInDocCrcy,
CANonDeductibleTxAmtInLoclCrcy,
CAContainsNonDeductibleInptTax,
CATaxRate,
GrossIncomeTaxActivityCode,
EmploymentTaxDistributionType,
CATaxPortionInLocalCurrency,
CATaxPortionInTransCurrency,
CATaxIsCalculatedExternally,
CAAltvExchangeRateSetCode,
TaxCountry,
TransToTaxCntryCrcyCnvrsnFctr,
CAIsCashFlowItem,
CACashFlowAccount,
CACashFlowCompanyCode,
HouseBank,
HouseBankAccount,
QuantitySignCode,
BankStatementShortID,
BankStatementItem,
CashManagementLinkType,
CashManagementLink,
CAItmIsCreatedByPostgInterface,
CAStatusOfEuroConversion,
CAProfitAnalysisUpdtIsDirect,
CAInvcgGroupingKey,
CACtrlFieldForAcctAssgmtDistr,
CAUpdateMethodForFundsMgmt,
OriginalFinancialMgmtArea,
OriglYearForFinMgmtAcctAssgmt,
EarmarkedFundsDocument,
ChartOfAccounts,
Country,
TaxCalculationProcedure,
/* Associations */
//own associations
_CADocument,
//associations from I_CADocumentGLItem
_BaseUnit,
_BusinessArea,
_CAAccountAssignmentCategory,
_CAAcctAssgmtDistrCode,
_CAAcctDetnTransKey,
_CAAltvExchangeRateSetCode,
_CAEuroConversionStatus,
_CAIntPostingReasonCode,
_CANegativePostingCtrlCode,
_CANonDcblInputTaxCode,
_CAOtherTaxCode,
_CashFlowAccount,
_CashFlowCompanyCode,
_CAWithholdingTaxSupplement,
_ChartOfAccounts,
_CompanyCode,
_CompanyCodeCurrency,
_Country,
_GLAccount,
_GLPostingCurrency,
_ProfitCenter,
_PartnerCompany,
_Segment,
_TaxCountry,
_TransactionCurrency,
_WBSElementBasicData
}
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