CNRREASSGMT_D

Transparent Table Application Table
39 Fields 1 CDS Views

Draft table for entity R_COSTANDREVENUEREASSIGNMENTTP

CNRREASSGMT_D is an SAP database table in S/4HANA. Draft table for entity R_COSTANDREVENUEREASSIGNMENTTP. It contains 39 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_CostAndRevnReassignmentDraft view_entity from BASIC Cost and Revenue Reassignment - Draft

Fields (39)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY fiscalyear fis_gjahr_no_conv Fiscal Year
KEY referencedocument awref Reference Doc.
KEY controllingarea fis_kokrs Controlling Area
KEY referencedocumenttype fis_awtyp Reference Document Type
KEY referencedocumentcontext fis_aworg Reference Document Context
KEY draftuuid sdraft_uuid Draft Document ID
fiscalyearforedit fis_gjahr_no_conv Fiscal Year
referencedocumentforedit awref Reference Doc.
controllingareaforedit fis_kokrs Controlling Area
referencedocumenttypeforedit fis_awtyp Reference Document Type
referencedocumentcontextfoed fis_aworg Reference Document Context
accountingdocumentheadertext bktxt Doc.Header Text
documentdate fis_bldat Journal Entry Date
postingdate fis_budat Posting Date
currentfiscalperiod fins_fiscalperiod Fiscal Period
fiscalperiod fins_fiscalperiod Fiscal Period
fiscalyearperiod fis_jahrper_conv Fiscal Year Period
accountingdocumentcreationdate farp_cpudt Entered On
accountingdoccreatedbyuser fco_cc_createdby Created By
conditionratevalueisnull abap.char
isreversal fins_xreversing Is Reversing
isreversed fins_xreversed Is Reversed
controllingdocumentstatus fco_document_status Status
ctrlgoverheadstatuscriticality abap.int1
allocationpostingtype fco_posting_type Posting Type
exchangeratedate fin_currconvdat Translation Date
reversalreferencedocument fis_awref_rev Reversal Reference Document
reversedreferencedocument reversedreferencedocument Reversed Reference Document
globalcurrency fis_rkcur Global Currency
totalamountinglobalcurrency fis_ksl Amount in Global Currency
controllingbustransactype fins_co_bus_trans CO Bus. Transaction
costrevenuereassignmenttype costrevenuereassignmenttype Assignment Type
accountingdocumenttype fis_blart Journal Entry Type
referencefiscalyear fis_gjahr_no_conv Fiscal Year
costaccountingdocumentaction costaccountingdocumentaction Cost Accounting Document Action
costacctgdocumentactionsource costacctgdocumentactionsource Cost Accounting Document Action Source
locallastchangedatetime abp_lastchange_tstmpl Changed On
lastchangedatetime vdm_lastchangedon Last Changed On

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.

-- Draft table for entity R_COSTANDREVENUEREASSIGNMENTTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CNRREASSGMT_D (
    MANDT,                           -- Client [mandt]
    FISCALYEAR,                      -- Fiscal Year [fis_gjahr_no_conv]
    REFERENCEDOCUMENT,               -- Reference Doc. [awref]
    CONTROLLINGAREA,                 -- Controlling Area [fis_kokrs]
    REFERENCEDOCUMENTTYPE,           -- Reference Document Type [fis_awtyp]
    REFERENCEDOCUMENTCONTEXT,        -- Reference Document Context [fis_aworg]
    DRAFTUUID,                       -- Draft Document ID [sdraft_uuid]
    FISCALYEARFOREDIT,               -- Fiscal Year [fis_gjahr_no_conv]
    REFERENCEDOCUMENTFOREDIT,        -- Reference Doc. [awref]
    CONTROLLINGAREAFOREDIT,          -- Controlling Area [fis_kokrs]
    REFERENCEDOCUMENTTYPEFOREDIT,    -- Reference Document Type [fis_awtyp]
    REFERENCEDOCUMENTCONTEXTFOED,    -- Reference Document Context [fis_aworg]
    ACCOUNTINGDOCUMENTHEADERTEXT,    -- Doc.Header Text [bktxt]
    DOCUMENTDATE,                    -- Journal Entry Date [fis_bldat]
    POSTINGDATE,                     -- Posting Date [fis_budat]
    CURRENTFISCALPERIOD,             -- Fiscal Period [fins_fiscalperiod]
    FISCALPERIOD,                    -- Fiscal Period [fins_fiscalperiod]
    FISCALYEARPERIOD,                -- Fiscal Year Period [fis_jahrper_conv]
    ACCOUNTINGDOCUMENTCREATIONDATE,  -- Entered On [farp_cpudt]
    ACCOUNTINGDOCCREATEDBYUSER,      -- Created By [fco_cc_createdby]
    CONDITIONRATEVALUEISNULL,        -- abap.char
    ISREVERSAL,                      -- Is Reversing [fins_xreversing]
    ISREVERSED,                      -- Is Reversed [fins_xreversed]
    CONTROLLINGDOCUMENTSTATUS,       -- Status [fco_document_status]
    CTRLGOVERHEADSTATUSCRITICALITY,  -- abap.int1
    ALLOCATIONPOSTINGTYPE,           -- Posting Type [fco_posting_type]
    EXCHANGERATEDATE,                -- Translation Date [fin_currconvdat]
    REVERSALREFERENCEDOCUMENT,       -- Reversal Reference Document [fis_awref_rev]
    REVERSEDREFERENCEDOCUMENT,       -- Reversed Reference Document [reversedreferencedocument]
    GLOBALCURRENCY,                  -- Global Currency [fis_rkcur]
    TOTALAMOUNTINGLOBALCURRENCY,     -- Amount in Global Currency [fis_ksl]
    CONTROLLINGBUSTRANSACTYPE,       -- CO Bus. Transaction [fins_co_bus_trans]
    COSTREVENUEREASSIGNMENTTYPE,     -- Assignment Type [costrevenuereassignmenttype]
    ACCOUNTINGDOCUMENTTYPE,          -- Journal Entry Type [fis_blart]
    REFERENCEFISCALYEAR,             -- Fiscal Year [fis_gjahr_no_conv]
    COSTACCOUNTINGDOCUMENTACTION,    -- Cost Accounting Document Action [costaccountingdocumentaction]
    COSTACCTGDOCUMENTACTIONSOURCE,   -- Cost Accounting Document Action Source [costacctgdocumentactionsource]
    LOCALLASTCHANGEDATETIME,         -- Changed On [abp_lastchange_tstmpl]
    LASTCHANGEDATETIME,              -- Last Changed On [vdm_lastchangedon]
    PRIMARY KEY (MANDT, FISCALYEAR, REFERENCEDOCUMENT, CONTROLLINGAREA, REFERENCEDOCUMENTTYPE, REFERENCEDOCUMENTCONTEXT, DRAFTUUID)
);

Learn More