I_RABUSINESSRECONCILIATION

CDS View

Revenue Accounting Business Recncln

I_RABUSINESSRECONCILIATION is a CDS View in S/4HANA. Revenue Accounting Business Recncln. It contains 20 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
P_RABusRecnclnDetWithCndnType view_entity inner COMPOSITE
P_RABusRecnclnPostdAmtForContr view_entity from COMPOSITE
P_RABusRecnclnWithUnqCndnType view_entity from COMPOSITE
P_RARecnclnPostdAmtPerfOblgn view_entity from COMPOSITE

Fields (20)

KeyField CDS FieldsUsed in Views
AllocatedPriceInSalesDocCrcy AllocatedPriceInSalesDocCrcy 1
BusRecnclnItemCreatedByUser BusRecnclnItemCreatedByUser 1
BusRecnclnItmCreatedDateTime BusRecnclnItmCreatedDateTime 1
ContractualPrcInSlsDocCrcy ContractualPrcInSlsDocCrcy 1
DataValidationHasError DataValidationHasError 1
DeltaEffectiveAmtInSlsDocCrcy DeltaEffectiveAmtInSlsDocCrcy 1
OperationalDocItemQty OperationalDocItemQty 1
OplContractualPrcInSlsDocCrcy OplContractualPrcInSlsDocCrcy 1
PerfOblgnContractualQuantity PerfOblgnContractualQuantity 1
RAContrLiabilityAssetIsCalcd RAContrLiabilityAssetIsCalcd 1
RAGenLdgrCorrectionAccount RAGenLdgrCorrectionAccount 1
RAGenLdgrRecognitionAccount RAGenLdgrRecognitionAccount 1
RAOplCostAmtInSlsDocCrcy RAOplCostAmtInSlsDocCrcy 1
RAOplCostPriceAmtInSlsDocCrcy RAOplCostPriceAmtInSlsDocCrcy 1
RAPerfOblgnCostAmtInSlsDocCrcy RAPerfOblgnCostAmtInSlsDocCrcy 1
RAPerfOblgnIsFrozen RAPerfOblgnIsFrozen 1
RevnAcctgPerfOblgnStatus RevnAcctgPerfOblgnStatus 1
SSPriceInSalesDocCrcy SSPriceInSalesDocCrcy 1
TotalInvoicedAmtInSlsDocCrcy TotalInvoicedAmtInSlsDocCrcy 1
ValidationDateTime ValidationDateTime 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.

-- Revenue Accounting Business Recncln
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_RABUSINESSRECONCILIATION (
    ALLOCATEDPRICEINSALESDOCCRCY,
    BUSRECNCLNITEMCREATEDBYUSER,
    BUSRECNCLNITMCREATEDDATETIME,
    CONTRACTUALPRCINSLSDOCCRCY,
    DATAVALIDATIONHASERROR,
    DELTAEFFECTIVEAMTINSLSDOCCRCY,
    OPERATIONALDOCITEMQTY,
    OPLCONTRACTUALPRCINSLSDOCCRCY,
    PERFOBLGNCONTRACTUALQUANTITY,
    RACONTRLIABILITYASSETISCALCD,
    RAGENLDGRCORRECTIONACCOUNT,
    RAGENLDGRRECOGNITIONACCOUNT,
    RAOPLCOSTAMTINSLSDOCCRCY,
    RAOPLCOSTPRICEAMTINSLSDOCCRCY,
    RAPERFOBLGNCOSTAMTINSLSDOCCRCY,
    RAPERFOBLGNISFROZEN,
    REVNACCTGPERFOBLGNSTATUS,
    SSPRICEINSALESDOCCRCY,
    TOTALINVOICEDAMTINSLSDOCCRCY,
    VALIDATIONDATETIME
);