R_CADocumentGLItemTP
Document General Ledger Item - TP
R_CADocumentGLItemTP 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_CADocumentGLItem) and exposes 103 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_CADocumentGLItem | I_CADocumentGLItem | 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 (103)
| 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 | |||
| ValueDate | ValueDate | |||
| CAExchangeRate | CAExchangeRate | |||
| ExchRateIsIndirectQuotation | ExchRateIsIndirectQuotation | |||
| TransactionCurrency | TransactionCurrency | |||
| Currency | Currency | |||
| 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 | |||
| BaseUnit | BaseUnit | |||
| 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 | |||
| 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 | |||
| WBSElementInternalID | WBSElementInternalID | |||
| _DocHeader | _DocHeader | |||
| _CAAccountAssignmentCategory | _CAAccountAssignmentCategory | |||
| _BusinessArea | _BusinessArea | |||
| _CAAcctAssgmtDistrCode | _CAAcctAssgmtDistrCode | |||
| _CAAcctDetnTransKey | _CAAcctDetnTransKey | |||
| _CAAltvExchangeRateSetCode | _CAAltvExchangeRateSetCode | |||
| _CAEuroConversionStatus | _CAEuroConversionStatus | |||
| _CAIntPostingReasonCode | _CAIntPostingReasonCode | |||
| _CANegativePostingCtrlCode | _CANegativePostingCtrlCode | |||
| _CANonDcblInputTaxCode | _CANonDcblInputTaxCode | |||
| _CashFlowAccount | _CashFlowAccount | |||
| _CAWithholdingTaxSupplement | _CAWithholdingTaxSupplement | |||
| _ChartOfAccounts | _ChartOfAccounts | |||
| _CompanyCode | _CompanyCode | |||
| _CashFlowCompanyCode | _CashFlowCompanyCode | |||
| _Country | _Country | |||
| _GLAccount | _GLAccount | |||
| _GLPostingCurrency | _GLPostingCurrency | |||
| _CAOtherTaxCode | _CAOtherTaxCode | |||
| _ProfitCenter | _ProfitCenter | |||
| _PartnerCompany | _PartnerCompany | |||
| _Segment | _Segment | |||
| _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
as select from I_CADocumentGLItem
association to parent R_CADocumentTP as _DocHeader on _DocHeader.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,
ValueDate,
CAExchangeRate,
ExchRateIsIndirectQuotation,
TransactionCurrency,
Currency,
CAAmountInLocalCurrency,
CAAmountInTransactionCurrency,
CAAmountInSecondCurrency,
CAAmountInThirdCurrency,
CAAccountAssignmentCategory,
CAAccountAssignment,
CostCenter,
SalesOrder,
SalesOrderItem,
CAReconciliationKey,
CAInternalPostingReasonCode,
CANegativePostingControlCode,
CAGLPostingCurrency,
LedgerGroup,
ProfitabilitySegment_2,
ProfitabilitySegmentChanges,
PlanningLevel,
CARepetitionGroup,
CATransactionKeyAccountDetn,
ConditionType,
CAIsSeparateLineItemInGL,
BaseUnit,
TaxCode,
CASupplementaryTaxCode,
CAWithholdingTaxSupplement,
CAOtherTaxCode,
CAGroupingCodeForTaxItems,
TaxJurisdiction,
CAEnteredTaxJurisdictionCode,
CATaxJurisdictionLevelCounter,
CATaxExceptionID,
CATaxDate,
CATaxBaseAmountInLocalCurrency,
CATaxBaseAmount,
CANonDeductibleTxAmtInDocCrcy,
CANonDeductibleTxAmtInLoclCrcy,
CAContainsNonDeductibleInptTax,
CATaxRate,
GrossIncomeTaxActivityCode,
EmploymentTaxDistributionType,
CATaxPortionInLocalCurrency,
CATaxPortionInTransCurrency,
CATaxIsCalculatedExternally,
CAAltvExchangeRateSetCode,
CAIsCashFlowItem,
CACashFlowAccount,
CACashFlowCompanyCode,
HouseBank,
HouseBankAccount,
QuantitySignCode,
BankStatementShortID,
BankStatementItem,
CashManagementLinkType,
CashManagementLink,
CAItmIsCreatedByPostgInterface,
CAStatusOfEuroConversion,
CAProfitAnalysisUpdtIsDirect,
CAInvcgGroupingKey,
CACtrlFieldForAcctAssgmtDistr,
CAUpdateMethodForFundsMgmt,
OriginalFinancialMgmtArea,
OriglYearForFinMgmtAcctAssgmt,
EarmarkedFundsDocument,
ChartOfAccounts,
Country,
TaxCalculationProcedure,
WBSElementInternalID,
/* Associations */
//own associations
_DocHeader,
//associations from I_CADocumentGLItem
_CAAccountAssignmentCategory,
_BusinessArea,
_CAAcctAssgmtDistrCode,
_CAAcctDetnTransKey,
_CAAltvExchangeRateSetCode,
_CAEuroConversionStatus,
_CAIntPostingReasonCode,
_CANegativePostingCtrlCode,
_CANonDcblInputTaxCode,
_CashFlowAccount,
_CAWithholdingTaxSupplement,
_ChartOfAccounts,
_CompanyCode,
_CashFlowCompanyCode,
_Country,
_GLAccount,
_GLPostingCurrency,
_CAOtherTaxCode,
_ProfitCenter,
_PartnerCompany,
_Segment,
_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