I_RACONTRWITHPOSTEDBALANCETP
RA Posted Contract Balance
I_RACONTRWITHPOSTEDBALANCETP is a CDS View in S/4HANA. RA Posted Contract Balance. It contains 37 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_RAContrWithPostedBalanceTP | view_entity | from | CONSUMPTION | Consumption RA Posted Contract Balance |
Fields (37)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | RevenueAccountingContract | RevenueAccountingContract | 1 |
| AccountingPrinciple | AccountingPrinciple | 1 | |
| AllocEffctAmountInSalesDocCrcy | AllocEffctAmountInSalesDocCrcy | 1 | |
| BusinessPartner | BusinessPartner | 1 | |
| BusinessPartnerName | BusinessPartnerName | 1 | |
| CompanyCode | CompanyCode | 1 | |
| CreatedByUserDescription | CreatedByUserDescription | 1 | |
| Customer | Customer | 1 | |
| CustomerName | CustomerName | 1 | |
| HasAttachment | HasAttachment | 1 | |
| LastChangedByUserDescription | LastChangedByUserDescription | 1 | |
| NumberOfPerformanceObligations | NumberOfPerformanceObligations | 1 | |
| RAContractCompletionDate | RAContractCompletionDate | 1 | |
| RAContractHasAllocationEffect | RAContractHasAllocationEffect | 1 | |
| RAContractHasAssetsImpairment | RAContractHasAssetsImpairment | 1 | |
| RAContractHasCompoundPerfOblgn | RAContractHasCompoundPerfOblgn | 1 | |
| RAContractIsSoftDeleted | RAContractIsSoftDeleted | 1 | |
| RAContractIsUniversal | RAContractIsUniversal | 1 | |
| RAContractLastChangeDate | RAContractLastChangeDate | 1 | |
| RAContractLastChangedByUsr | RAContractLastChangedByUsr | 1 | |
| RAContractPostingMode | RAContractPostingMode | 1 | |
| RAContractPostingModeName | RAContractPostingModeName | 1 | |
| RAContractStatusCriticality | RAContractStatusCriticality | 1 | |
| RAContractVersionCode | RAContractVersionCode | 1 | |
| RAContrBalanceIsDfrrdRevn | RAContrBalanceIsDfrrdRevn | 1 | |
| RAContrBalanceIsLiability | RAContrBalanceIsLiability | 1 | |
| RAContrIsNotActvUnivRevnRecgn | RAContrIsNotActvUnivRevnRecgn | 1 | |
| RAContrManualChgBusinessReason | RAContrManualChgBusinessReason | 1 | |
| RevnAcctgContractCreatedByUser | RevnAcctgContractCreatedByUser | 1 | |
| RevnAcctgContractCreationDate | RevnAcctgContractCreationDate | 1 | |
| RevnAcctgContractDescription | RevnAcctgContractDescription | 1 | |
| RevnAcctgContractStatus | RevnAcctgContractStatus | 1 | |
| RevnAcctgContractStatusName | RevnAcctgContractStatusName | 1 | |
| RevnAcctgSalesOrganization | RevnAcctgSalesOrganization | 1 | |
| RevnContrAssetsImpairmentDate | RevnContrAssetsImpairmentDate | 1 | |
| SalesDocumentCurrency | SalesDocumentCurrency | 1 | |
| TotContractualPrcInSlsDocCrcy | TotContractualPrcInSlsDocCrcy | 1 |
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.
-- RA Posted Contract Balance
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_RACONTRWITHPOSTEDBALANCETP (
REVENUEACCOUNTINGCONTRACT,
ACCOUNTINGPRINCIPLE,
ALLOCEFFCTAMOUNTINSALESDOCCRCY,
BUSINESSPARTNER,
BUSINESSPARTNERNAME,
COMPANYCODE,
CREATEDBYUSERDESCRIPTION,
CUSTOMER,
CUSTOMERNAME,
HASATTACHMENT,
LASTCHANGEDBYUSERDESCRIPTION,
NUMBEROFPERFORMANCEOBLIGATIONS,
RACONTRACTCOMPLETIONDATE,
RACONTRACTHASALLOCATIONEFFECT,
RACONTRACTHASASSETSIMPAIRMENT,
RACONTRACTHASCOMPOUNDPERFOBLGN,
RACONTRACTISSOFTDELETED,
RACONTRACTISUNIVERSAL,
RACONTRACTLASTCHANGEDATE,
RACONTRACTLASTCHANGEDBYUSR,
RACONTRACTPOSTINGMODE,
RACONTRACTPOSTINGMODENAME,
RACONTRACTSTATUSCRITICALITY,
RACONTRACTVERSIONCODE,
RACONTRBALANCEISDFRRDREVN,
RACONTRBALANCEISLIABILITY,
RACONTRISNOTACTVUNIVREVNRECGN,
RACONTRMANUALCHGBUSINESSREASON,
REVNACCTGCONTRACTCREATEDBYUSER,
REVNACCTGCONTRACTCREATIONDATE,
REVNACCTGCONTRACTDESCRIPTION,
REVNACCTGCONTRACTSTATUS,
REVNACCTGCONTRACTSTATUSNAME,
REVNACCTGSALESORGANIZATION,
REVNCONTRASSETSIMPAIRMENTDATE,
SALESDOCUMENTCURRENCY,
TOTCONTRACTUALPRCINSLSDOCCRCY,
PRIMARY KEY (REVENUEACCOUNTINGCONTRACT)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA