R_CADocumentDraft

DDL: R_CADOCUMENTDRAFT Type: view_entity BASIC Package: RAP_FICA_CADOC
53 Fields 1 Data Sources

Contract Accounting Document - Draft

R_CADocumentDraft is a Basic CDS View that provides data about "Contract Accounting Document - Draft" in SAP S/4HANA. It reads from 1 data source (dfkkko_d) and exposes 53 fields with key fields CADocumentNumber, DraftUUID. Part of development package RAP_FICA_CADOC.

Data Sources (1)

SourceAliasJoin Type
dfkkko_d dfkkko_d from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Contract Accounting Document - 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 (53)

KeyFieldSource TableSource FieldDescription
KEY CADocumentNumber cadocumentnumber Document Number
KEY DraftUUID draftuuid UUID
CAReconciliationKey careconciliationkey Reconcil. Key
CAApplicationArea caapplicationarea ApplicationArea
CADocumentType cadocumenttype Document Type
CADocumentOriginCode cadocumentorigincode Document Origin
CreatedByUser createdbyuser User Name
CreationDate creationdate Time Stamp
CreationTime creationtime Time of Change
TransactionCurrency transactioncurrency Transaction Currency
DocumentDate documentdate Journal Entry Date
CAPostingDate capostingdate Posting Date
ExchangeRateDate exchangeratedate Translatn Date
CAReferenceDocument careferencedocument Reference
CAReturnReason careturnreason Return Reason
CAPostingReason capostingreason Posting Reason
CASeparateDocIsCreatedInGL caseparatedociscreatedingl Single Document
ReferenceDocumentType referencedocumenttype Reference Document Type
OriginalReferenceDocument originalreferencedocument Reference Key
CAReversedDocumentNumber careverseddocumentnumber Rev. Doc. For
CADocumentClass cadocumentclass Document Class
CAClearingInformation caclearinginformation Clearing Info
CATaxCompanyCode cataxcompanycode Tax comp. code
CAReversalDocumentNumber careversaldocumentnumber Revers.document
CADocumentSupplements cadocumentsupplements Doc supps
LogicalSystem logicalsystem Logical System
CADocumentVersion cadocumentversion Version
CAWorkflowCheckReason caworkflowcheckreason Check Reason
CAWorkflowCheckProcess caworkflowcheckprocess Process
CADocumentTransactionClass cadocumenttransactionclass Transact.type
CADocumentTypeForGLTransfer cadocumenttypeforgltransfer Tfr Doc. Type
CADocContainsCashFlowItems cadoccontainscashflowitems Cash Flow
CATaxCodeWasExchanged cataxcodewasexchanged New Tax Code
TaxReportingDate taxreportingdate Tax Reporting Date
TaxFulfillmentDate taxfulfillmentdate Tax Settlement Date
CARequestedPeriodForGLTransfer carequestedperiodforgltransfer Special Period
IsIndividualPosting isindividualposting Indiv. Posting
CADocumentIsAged cadocumentisaged Data Aging
LastChangeDate lastchangedate Time Stamp
LastChangeTime lastchangetime Time changed
CAInvcgRefPostingDocType cainvcgrefpostingdoctype Ref. Doc. Type
CAInvoicingDocument cainvoicingdocument Invoic. Doc.
CA1stCountrySpecificReference ca1stcountryspecificreference Reference
CAFirstCountrySpecificDate cafirstcountryspecificdate Date
CAClassificationKey caclassificationkey Classif. Key
CreationDateTime creationdatetime Timestamp
LastChangeDateTime lastchangedatetime Timestamp
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

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_CADocumentDraft.
-- 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_CADocumentDraft AS
SELECT
  CADocumentNumber,
  DraftUUID,
  CAReconciliationKey,
  CAApplicationArea,
  CADocumentType,
  CADocumentOriginCode,
  CreatedByUser,
  CreationDate,
  CreationTime,
  TransactionCurrency,
  DocumentDate,
  CAPostingDate,
  ExchangeRateDate,
  CAReferenceDocument,
  CAReturnReason,
  CAPostingReason,
  CASeparateDocIsCreatedInGL,
  ReferenceDocumentType,
  OriginalReferenceDocument,
  CAReversedDocumentNumber,
  CADocumentClass,
  CAClearingInformation,
  CATaxCompanyCode,
  CAReversalDocumentNumber,
  CADocumentSupplements,
  LogicalSystem,
  CADocumentVersion,
  CAWorkflowCheckReason,
  CAWorkflowCheckProcess,
  CADocumentTransactionClass,
  CADocumentTypeForGLTransfer,
  CADocContainsCashFlowItems,
  CATaxCodeWasExchanged,
  TaxReportingDate,
  TaxFulfillmentDate,
  CARequestedPeriodForGLTransfer,
  IsIndividualPosting,
  CADocumentIsAged,
  LastChangeDate,
  LastChangeTime,
  CAInvcgRefPostingDocType,
  CAInvoicingDocument,
  CA1stCountrySpecificReference,
  CAFirstCountrySpecificDate,
  CAClassificationKey,
  CreationDateTime,
  LastChangeDateTime,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM dfkkko_d
;

Learn More