I_REVENUEACCOUNTINGCONTRACT

CDS View
41 Fields 25 CDS Views

Revenue Accounting Contract

I_REVENUEACCOUNTINGCONTRACT is a CDS View in S/4HANA. Revenue Accounting Contract. It contains 41 fields. 25 CDS views read from this table.

CDS Views using this table (25)

ViewTypeJoinVDMDescription
C_RAContrManualSpreadingTP view_entity from CONSUMPTION Revenue Accounting Contract Entity
C_RAContrMnlFlfmtOverview view_entity from CONSUMPTION Manual Fulfillment Overview
C_RAContrMnlFlfmtTP view_entity from CONSUMPTION Revenue Accounting Contract Entity
C_RAToBeCombinedContract view_entity from CONSUMPTION Consumption RA To Be Combined Contracts
ESH_N_RACONTRACT view from
FINOC_HARD_DEPENDENCY_RAR view_entity inner Orgl Change: RAR Hard Dependencies
FINOC_RT_RAR_FROM_SOI_OR_SRV view_entity inner Orgl Change: RAR from SOI or SRV
FINOC_RULE_RAR_BASE view_entity inner Orgl Change-Rule: Perf. Obligation Base
I_RAContrWithPostedBalance view_entity from COMPOSITE Interface RA Posted Contract Balance
I_RAContrWithPostedBalanceTP view from TRANSACTIONAL RA Posted Contract Balance
I_RAToBeMonitoredContract view_entity from COMPOSITE Contract to Be Monitored
I_RevnAcctgContractEnhanced view from COMPOSITE Revenue Contract With Aggregated Amount
I_RevnAcctgSchedule view_entity from COMPOSITE Composite Revenue Accounting Schedule
P_ConflictedContrPendingDays view_entity from COMPOSITE
P_RAContractByStatus view_entity from COMPOSITE
P_RAContractForChangeItem view_entity from COMPOSITE
P_RAContractWithPerfOblgnStdVH view_entity union COMPOSITE
P_RAContrTotRecognizedRevenue view_entity from COMPOSITE
P_RAContrWithPostedBalance view_entity from COMPOSITE
P_RAFlmtRecnclnKeyGroup view_entity inner COMPOSITE
P_RARevnExplMigrationRevn view from COMPOSITE
P_RARevnExplRecnclnKeyGroup view_entity inner COMPOSITE
R_RAContrConflictWrkListTP view_entity from TRANSACTIONAL Conflict Worklist
R_RAContrMngRevnContrTP view_entity from TRANSACTIONAL Manage Revenue Contract
R_RevenueAccountingContractTP view_entity from TRANSACTIONAL Revenue Accounting Contract Entity

Fields (41)

KeyField CDS FieldsUsed in Views
KEY AccountingPrinciple AccountingPrinciple 12
KEY CompanyCode CompanyCode 14
KEY RAContractTransformRecnclnKey RAContractTransformRecnclnKey 1
KEY RevenueAccountingContract RevenueAccountingContract 15
_AccountingPrinciple _AccountingPrinciple 11
_BusinessPartner _BusinessPartner 10
_ChangedByUser _ChangedByUser 2
_CompanyCode _CompanyCode 11
_CreatedByUser _CreatedByUser 2
_Currency _Currency 2
_Customer _Customer 7
_RAContractStatus _RAContractStatus 2
_SalesOrganization _SalesOrganization 11
AllocEffctAmountInSalesDocCrcy AllocEffctAmountInSalesDocCrcy 9
BusinessPartner BusinessPartner 11
Customer Customer 11
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 10
NumberOfPerformanceObligations NumberOfPerformanceObligations 9
RAContractCompletionDate RAContractCompletionDate 9
RAContractHasAllocationEffect RAContractHasAllocationEffect 10
RAContractHasAssetsImpairment RAContractHasAssetsImpairment 9
RAContractIsManuallyAllocated RAContractIsManuallyAllocated 3
RAContractIsManuallyChanged RAContractIsManuallyChanged 1
RAContractIsSoftDeleted RAContractIsSoftDeleted 4
RAContractIsUniversal RAContractIsUniversal 7
RAContractLastChangeDate RAContractLastChangeDate 6
RAContractLastChangedByUsr RAContractLastChangedByUsr 10
RAContractLastSavedDateTime RAContractLastSavedDateTime 7
RAContractPostingMode RAContractPostingMode 2
RAContractVersionCode RAContractVersionCode 10
RAContrBalanceDerivationRule RAContrBalanceDerivationRule 1
RAContrHasMnlPrcAllocConflict RAContrHasMnlPrcAllocConflict 5
RevnAcctgContractCategory RevnAcctgContractCategory 1
RevnAcctgContractCreatedByUser RevnAcctgContractCreatedByUser 9
RevnAcctgContractCreationDate RevnAcctgContractCreationDate 10
RevnAcctgContractDescription RevnAcctgContractDescription 9
RevnAcctgContractStatus RevnAcctgContractStatus 11
RevnAcctgSalesOrganization RevnAcctgSalesOrganization 11
RevnContrAssetsImpairmentDate RevnContrAssetsImpairmentDate 7
SalesDocumentCurrency SalesDocumentCurrency 13
TotContractualPrcInSlsDocCrcy TotContractualPrcInSlsDocCrcy 10

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Revenue Accounting Contract
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_REVENUEACCOUNTINGCONTRACT (
    ACCOUNTINGPRINCIPLE,
    COMPANYCODE,
    RACONTRACTTRANSFORMRECNCLNKEY,
    REVENUEACCOUNTINGCONTRACT,
    _ACCOUNTINGPRINCIPLE,
    _BUSINESSPARTNER,
    _CHANGEDBYUSER,
    _COMPANYCODE,
    _CREATEDBYUSER,
    _CURRENCY,
    _CUSTOMER,
    _RACONTRACTSTATUS,
    _SALESORGANIZATION,
    ALLOCEFFCTAMOUNTINSALESDOCCRCY,
    BUSINESSPARTNER,
    CUSTOMER,
    ISBUSINESSPURPOSECOMPLETED,
    NUMBEROFPERFORMANCEOBLIGATIONS,
    RACONTRACTCOMPLETIONDATE,
    RACONTRACTHASALLOCATIONEFFECT,
    RACONTRACTHASASSETSIMPAIRMENT,
    RACONTRACTISMANUALLYALLOCATED,
    RACONTRACTISMANUALLYCHANGED,
    RACONTRACTISSOFTDELETED,
    RACONTRACTISUNIVERSAL,
    RACONTRACTLASTCHANGEDATE,
    RACONTRACTLASTCHANGEDBYUSR,
    RACONTRACTLASTSAVEDDATETIME,
    RACONTRACTPOSTINGMODE,
    RACONTRACTVERSIONCODE,
    RACONTRBALANCEDERIVATIONRULE,
    RACONTRHASMNLPRCALLOCCONFLICT,
    REVNACCTGCONTRACTCATEGORY,
    REVNACCTGCONTRACTCREATEDBYUSER,
    REVNACCTGCONTRACTCREATIONDATE,
    REVNACCTGCONTRACTDESCRIPTION,
    REVNACCTGCONTRACTSTATUS,
    REVNACCTGSALESORGANIZATION,
    REVNCONTRASSETSIMPAIRMENTDATE,
    SALESDOCUMENTCURRENCY,
    TOTCONTRACTUALPRCINSLSDOCCRCY,
    PRIMARY KEY (ACCOUNTINGPRINCIPLE, COMPANYCODE, RACONTRACTTRANSFORMRECNCLNKEY, REVENUEACCOUNTINGCONTRACT)
);

Learn More