R_RAContrManualSpreadingDraft

DDL: R_RACONTRMANUALSPREADINGDRAFT Type: view_entity BASIC
40 Fields 1 Data Sources

Revenue Contract - Draft

R_RAContrManualSpreadingDraft is a Basic CDS View that provides data about "Revenue Contract - Draft" in SAP S/4HANA. It reads from 1 data source (farr_contrmnlspd) and exposes 40 fields with key field RevenueAccountingContract.

Data Sources (1)

SourceAliasJoin Type
farr_contrmnlspd Draft from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Revenue Contract - Draft view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #BASIC view

Fields (40)

KeyFieldSource TableSource FieldDescription
KEY RevenueAccountingContract revenueaccountingcontract Revenue Contract
CompanyCode companycode Receiver Company Code
CompanyCodeName companycodename Company Name
AccountingPrinciple accountingprinciple AP Ledger/CoCode
AccountingPrincipleName accountingprinciplename Name of AP
BusinessPartner businesspartner Issuing Authority
BusinessPartnerName businesspartnername Extracted Customer Name
Customer customer Sold-to Party
CustomerName customername Name of Customer
TotContractualPrcInSlsDocCrcy totcontractualprcinslsdoccrcy Contractual Price
AllocEffctAmountInSalesDocCrcy alloceffctamountinsalesdoccrcy Allocation Effect
RevnAcctgContractStatus revnacctgcontractstatus Contract Status
RevnAcctgContractStatusName revnacctgcontractstatusname Contract Status Description
RAContractLastSavedDateTime racontractlastsaveddatetime Time Stamp
RAContrHasMnlPrcAllocConflict racontrhasmnlprcallocconflict Allocation Conflict
RevnAcctgContractCreationDate revnacctgcontractcreationdate Created On
RevnAcctgContractCreatedByUser revnacctgcontractcreatedbyuser Last Changed By
CreatedByUserDescription createdbyuserdescription Description
IsBusinessPurposeCompleted isbusinesspurposecompleted Purpose Completed
SalesDocumentCurrency salesdocumentcurrency Currency
RAContractLastChangedByUsr racontractlastchangedbyusr Last Changed By
RAContractLastChangeDate racontractlastchangedate Changed on
LastChangedByUserDescription lastchangedbyuserdescription Description
RAContractHasAllocationEffect racontracthasallocationeffect Has Allocation Effect
RAAttributeHasConflict raattributehasconflict Attr conflict
RevnAcctgSalesOrganization revnacctgsalesorganization Sales Org.
PerfOblgnHasSprdgConflict perfoblgnhassprdgconflict Spreading Conflict
RAContractIsSoftDeleted racontractissoftdeleted Soft Deleted
RAContractHasAssetsImpairment racontracthasassetsimpairment Contract was Terminated Early
RAContractStatusCriticality racontractstatuscriticality INT1
SalesOrganizationName salesorganizationname Sales Organization Description
RAContractIsUniversal racontractisuniversal Universal Rev Contr
RAContractVersionCode racontractversioncode RAR version code
RAContractCompletionDate racontractcompletiondate Completion Date
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_RAContrManualSpreadingDraft.
-- 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_RAContrManualSpreadingDraft AS
SELECT
  RevenueAccountingContract,
  CompanyCode,
  CompanyCodeName,
  AccountingPrinciple,
  AccountingPrincipleName,
  BusinessPartner,
  BusinessPartnerName,
  Customer,
  CustomerName,
  TotContractualPrcInSlsDocCrcy,
  AllocEffctAmountInSalesDocCrcy,
  RevnAcctgContractStatus,
  RevnAcctgContractStatusName,
  RAContractLastSavedDateTime,
  RAContrHasMnlPrcAllocConflict,
  RevnAcctgContractCreationDate,
  RevnAcctgContractCreatedByUser,
  CreatedByUserDescription,
  IsBusinessPurposeCompleted,
  SalesDocumentCurrency,
  RAContractLastChangedByUsr,
  RAContractLastChangeDate,
  LastChangedByUserDescription,
  RAContractHasAllocationEffect,
  RAAttributeHasConflict,
  RevnAcctgSalesOrganization,
  PerfOblgnHasSprdgConflict,
  RAContractIsSoftDeleted,
  RAContractHasAssetsImpairment,
  RAContractStatusCriticality,
  SalesOrganizationName,
  RAContractIsUniversal,
  RAContractVersionCode,
  RAContractCompletionDate,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM farr_contrmnlspd AS Draft
;

Learn More