R_CADocumentGLItemDraft

DDL: R_CADOCUMENTGLITEMDRAFT Type: view_entity BASIC Package: RAP_FICA_CADOC
95 Fields 1 Data Sources 1 Associations

Document General Ledger Item - Draft

R_CADocumentGLItemDraft is a Basic CDS View that provides data about "Document General Ledger Item - Draft" in SAP S/4HANA. It reads from 1 data source (dfkkopk_d) and exposes 95 fields with key fields CADocumentNumber, CAGLItemNumber, DraftUUID. It has 1 association to related views. Part of development package RAP_FICA_CADOC.

Data Sources (1)

SourceAliasJoin Type
dfkkopk_d dfkkopk_d from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_CADocument _CADocument $projection.CADocumentNumber = _CADocument.CADocumentNumber

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Document General Ledger Item - Draft view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #BASIC view

Fields (95)

KeyFieldSource TableSource FieldDescription
KEY CADocumentNumber cadocumentnumber Document Number
KEY CAGLItemNumber caglitemnumber Item
KEY DraftUUID draftuuid UUID
ParentDraftUUID parentdraftuuid NodeID
CompanyCode companycode Receiver Company Code
BusinessArea businessarea Business Area
BusinessPlace businessplace Business place
Segment segment Segment number
ProfitCenter profitcenter Profit Center
PartnerCompany partnercompany Trading Partner
GLAccount glaccount General Ledger
WBSElementInternalID wbselementinternalid WBS Internal ID
ValueDate valuedate Value Date
CAExchangeRate caexchangerate Absolute Exchange Rate
ExchRateIsIndirectQuotation exchrateisindirectquotation Exchange Rate Is Indirect Quotation
TransactionCurrency transactioncurrency Transaction Currency
Currency currency Valuation Crcy
AdditionalCurrency1 additionalcurrency1 Local curr. 2
AdditionalCurrency2 additionalcurrency2 Local curr. 3
CAAmountInLocalCurrency caamountinlocalcurrency Local Crcy Amt
CAAmountInTransactionCurrency caamountintransactioncurrency Amount
CAAmountInSecondCurrency caamountinsecondcurrency Amount in LC 2
CAAmountInThirdCurrency caamountinthirdcurrency Amount in LC3
CAAccountAssignmentCategory caaccountassignmentcategory Acct Assgt Cat.
CAAccountAssignment caaccountassignment Acct assignment
CostCenter costcenter Cost Center
SalesOrder salesorder SD Document
SalesOrderItem salesorderitem Sales Order Item
CAReconciliationKey careconciliationkey Reconcil. Key
CAInternalPostingReasonCode cainternalpostingreasoncode Posting Reason
CANegativePostingControlCode canegativepostingcontrolcode Negative Pstng
CAGLPostingCurrency caglpostingcurrency G/L Currency
LedgerGroup ledgergroup Ledger Group
ProfitabilitySegment_2 profitabilitysegment_2 Profit. segment
ProfitabilitySegmentChanges profitabilitysegmentchanges Subnumber
PlanningLevel planninglevel Planning Level
CARepetitionGroup carepetitiongroup Repetition grp
CATransactionKeyAccountDetn catransactionkeyaccountdetn Autom. Posting
ConditionType conditiontype Condition type
CAIsSeparateLineItemInGL caisseparatelineitemingl Line item
QuantityInBaseUnit quantityinbaseunit Quantity
BaseUnit baseunit Unit of Measure
CAGroupingKeyDocumentItems cagroupingkeydocumentitems Item Grouping
TaxCode taxcode Tax Code
CASupplementaryTaxCode casupplementarytaxcode Supplem. Tax
CAWithholdingTaxSupplement cawithholdingtaxsupplement WT supplmt
CAOtherTaxCode caothertaxcode TxCde:Oth.Taxes
CAGroupingCodeForTaxItems cagroupingcodefortaxitems Tax Group
TaxJurisdiction taxjurisdiction Tax Jurisdiction
CAEnteredTaxJurisdictionCode caenteredtaxjurisdictioncode Orig.jurisdict.
CATaxJurisdictionLevelCounter cataxjurisdictionlevelcounter Tax level
CATaxExceptionID cataxexceptionid Tax exception
CATaxDate cataxdate Tax Date
CATaxBaseAmountInLocalCurrency cataxbaseamountinlocalcurrency Tax base in LC
CATaxBaseAmount cataxbaseamount Tax Base Amount
CANonDeductibleTxAmtInDocCrcy canondeductibletxamtindoccrcy Non-Ded. Tax
CANonDeductibleTxAmtInLoclCrcy canondeductibletxamtinloclcrcy Non-Ded.Tax LC
CAContainsNonDeductibleInptTax cacontainsnondeductibleinpttax Non-Ded. Input Tax
CATaxRate cataxrate Tax rate
GrossIncomeTaxActivityCode grossincometaxactivitycode Activity Code
EmploymentTaxDistributionType employmenttaxdistributiontype Distr. Type
CATaxPortionInLocalCurrency cataxportioninlocalcurrency FI-CA Tax Portion
CATaxPortionInTransCurrency cataxportionintranscurrency Tax Portion
CATaxIsCalculatedExternally cataxiscalculatedexternally Tax by Document
CAAltvExchangeRateSetCode caaltvexchangeratesetcode Alt.Exch.Rate
TaxCountry taxcountry Tax Ctry/Reg.
TransToTaxCntryCrcyCnvrsnFctr transtotaxcntrycrcycnvrsnfctr Tax Factor C/R
CAIsCashFlowItem caiscashflowitem Cash Flow
CACashFlowAccount cacashflowaccount Cash Flow Acct
CACashFlowCompanyCode cacashflowcompanycode Cash Flow CoCd
HouseBank housebank House Bank
HouseBankAccount housebankaccount House Bank Account
QuantitySignCode quantitysigncode Qty +/- Sign
BankStatementShortID bankstatementshortid Statement Short Key
BankStatementItem bankstatementitem Memo Record No.
CashManagementLinkType cashmanagementlinktype Link Type
CashManagementLink cashmanagementlink Link ID
CAItmIsCreatedByPostgInterface caitmiscreatedbypostginterface Created Int.
CAProfitAnalysisUpdtIsDirect caprofitanalysisupdtisdirect CO-PA updated
CAInvcgGroupingKey cainvcggroupingkey Inv. Grouping
CACtrlFieldForAcctAssgmtDistr cactrlfieldforacctassgmtdistr Distribution Status
CAUpdateMethodForFundsMgmt caupdatemethodforfundsmgmt FM Type
OriginalFinancialMgmtArea originalfinancialmgmtarea Original FMArea
OriglYearForFinMgmtAcctAssgmt origlyearforfinmgmtacctassgmt Original Year
EarmarkedFundsDocument earmarkedfundsdocument Earmarked Funds
ChartOfAccounts chartofaccounts Node Class
Country country Venue: Ctry/Reg
TaxCalculationProcedure taxcalculationprocedure Tax Procedure
DraftEntityCreationDateTime draftentitycreationdatetime Draft Created On
DraftEntityLastChangeDateTime draftentitylastchangedatetime Draft Last Changed On
DraftAdministrativeDataUUID draftadministrativedatauuid UUID
DraftEntityOperationCode draftentityoperationcode Draft - Operation Code
HasActiveEntity hasactiveentity TRUE
DraftFieldChanges draftfieldchanges Field Changes
_CADocument _CADocument

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view R_CADocumentGLItemDraft.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW R_CADocumentGLItemDraft AS
SELECT
  CADocumentNumber,
  CAGLItemNumber,
  DraftUUID,
  ParentDraftUUID,
  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,
  CAProfitAnalysisUpdtIsDirect,
  CAInvcgGroupingKey,
  CACtrlFieldForAcctAssgmtDistr,
  CAUpdateMethodForFundsMgmt,
  OriginalFinancialMgmtArea,
  OriglYearForFinMgmtAcctAssgmt,
  EarmarkedFundsDocument,
  ChartOfAccounts,
  Country,
  TaxCalculationProcedure,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM dfkkopk_d
LEFT OUTER JOIN I_CADocument AS _CADocument ON CADocumentNumber = _CADocument.CADocumentNumber  -- association [1..1]
;

Learn More