CNRREASSGMTITM_D

Transparent Table Application Table
109 Fields 2 CDS Views

Draft table for entity R_COSTANDREVNREASSGMTITEMTP

CNRREASSGMTITM_D is an SAP database table in S/4HANA. Draft table for entity R_COSTANDREVNREASSGMTITEMTP. It contains 109 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_CostAndRevnReassgmtItemDraft view_entity from EXTENSION CnR Reassgmt Item - Extension
R_CostAndRevnReassgmtItemDraft view_entity from BASIC Cost and Revn Reassgmt Item - Draft

Fields (109)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY fiscalyear fis_gjahr_no_conv Fiscal Year
KEY referencedocument referencedocument Reference Document
KEY controllingarea fis_kokrs Controlling Area
KEY referencedocumentitem fis_awitem Reference Document Item
KEY ledgergllineitem fis_docln Journal Entry Item
KEY referencedocumenttype fis_awtyp Reference Document Type
KEY referencedocumentcontext fis_aworg Reference Document Context
KEY accountingdocument fis_belnr Journal Entry
KEY draftuuid sdraft_uuid Draft Document ID
parentdraftuuid sdraft_uuid Draft Document ID
fiscalyearforedit fis_gjahr_no_conv Fiscal Year
referencedocumentforedit referencedocument Reference Document
controllingareaforedit fis_kokrs Controlling Area
referencedocumentitemforedit fis_awitem Reference Document Item
ledgergllineitemforedit fis_docln Journal Entry Item
referencedocumenttypeforedit fis_awtyp Reference Document Type
accountingdocumentforedit fis_belnr Journal Entry
referencedocumentcontextfoed fis_aworg Reference Document Context
companycode receivercompanycode Receiver Company Code
transactionsubitem fins_subta Sub Transaction
controllingdocumentitem co_buzei_acd Controlling Doc Item
sourceledger fins_ledger_pers Source Ledger
sendercompanycode sendercompanycode Sender Company Code
accountassignment accas_sender Sender Acct Assgmt
accountassignmenttype accasty_sender Sndr AcctAssgmt Type
partneraccountassignment fis_paccas Partner Account Assignment
partneraccountassignmenttype fis_paccasty Part.AcctAssgmtType
partnercostcenter fis_skost Partner Cost Center
sendercostcenter sendercostcenter Sender Cost Center
documentitemtext farp_sgtxt Item Text
glaccount fco_allocation_account Account for Allocation
baseunit meins Base Unit
quantity lstxx Activity Qty
transactioncurrency fis_rwcur Transaction Currency
amountintransactioncurrency fis_wsl Amount in Transaction Currency
companycodecurrency fis_hwaer Company Code Currency
amountincompanycodecurrency fis_hsl Amount in Company Code Currency
globalcurrency fis_rkcur Global Currency
amountinglobalcurrency fis_ksl Amount in Global Currency
partnerwbselementexternalid fis_par_psp_pnr_ext Partner WBSElmnt ext
partnerwbselementinternalid fis_partner_wbsint_no_conv Partner WBS Element Internal ID
wbselementinternalid fis_wbsint_no_conv WBS Element Internal ID
wbselementexternalid fis_wbsext_no_conv WBS Element External ID
partnerservicedocumenttype fco_psrvdoc_type Par. Service DocType
partnerservicedocument fco_psrvdoc_id Partner Service Doc.
partnerservicedocumentitem fco_psrvdoc_item_id Par. Service DocItem
servicedocumenttype fco_srvdoc_type Service Doc. Type
servicedocument fco_srvdoc_id Service Document
servicedocumentitem fco_srvdoc_item_id Service Doc. Item
partnerorder fis_par_aufnr Partner Order
orderid fis_aufnr Order ID
partnersalesdocument fis_par_kdauf Partner Sales Doc.
partnersalesdocumentitem fis_par_kdpos Partner Sales Document Item
salesdocument vbeln_va Sales Document
salesdocumentitem fis_posnr_va Sales Document Item
workitem /cpd/pfp_workitem_id Work Item ID
partnerworkitem /cpd/pfp_workitem_id Work Item ID
personnelnumber pernr_d Personnel No.
costaccountingdocumentaction costaccountingdocumentaction Cost Accounting Document Action
controllingbustransactype co_vorgang Bus.Transaction
fund fm_sfonds Sender Fund
functionalarea fm_sfarea Sendr Fctl Area
grantid gm_grant_sender Sender Grant
budgetperiod fm_budget_period Budget Period
partnerfund fm_efonds Receiver Fund
partnerfunctionalarea fm_efarea Rec. Fntcl Area
partnergrant gm_grant_receiver Receiver Grant
partnerbudgetperiod fm_pbudget_period Par. BudPer
financialmanagementarea fikrs FM Area
rcvracctgindcode ebemot Rec. acct. ind.
accountingindicatorcode bemot AcctIndicator
postingdate fis_budat Posting Date
partnercostrecoverycode jv_recind_cds Joint Venture Cost Recovery Code
sendercostrecoverycode jv_srecind_cds Sender Cost Recovery Code
operatingconcern erkrs Operating concern
partnerprofitabilitysegment rkepobj PartnerPrf.Seg.
partprofitabilitysgmtisassgd profitabilitysegmentisassigned Profitability Segment Is Assigned
profitabilitysegment rkeobjnr Profit. segment
profitabilitysegmentisassigned profitabilitysegmentisassigned Profitability Segment Is Assigned
receiverrecompanycode pbukrs Partner CoCode
realestatepartnercontract recnvdmpcnnr Real Estate Partner Contract
senderrecompanycode vvsbukrs Send.comp.code
realestatecontract recnvdmcnnr Real Estate Contract
partnerprofitcenter fis_prctr Profit Center
profitcenter fis_prctr Profit Center
servicesrendereddate fbuda Serv. Rend. Dte
freedefinedcurrency1 fis_rocur Freely Defined Currency 1
amountinfreedefinedcurrency1 fis_osl Amount in Freely Defined Currency 1
freedefinedcurrency2 fis_rvcur Freely Defined Currency 2
amountinfreedefinedcurrency2 fis_vsl Amount in Freely Defined Currency 2
freedefinedcurrency3 fis_curr3 Freely Defined Currency 3
amountinfreedefinedcurrency3 fis_bsl Amount in Freely Defined Currency 3
freedefinedcurrency4 fis_curr4 Freely Defined Currency 4
amountinfreedefinedcurrency4 fis_csl Amount in Freely Defined Currency 4
freedefinedcurrency5 fis_curr5 Freely Defined Currency 5
amountinfreedefinedcurrency5 fis_dsl Amount in Freely Defined Currency 5
freedefinedcurrency6 fis_curr6 Freely Defined Currency 6
amountinfreedefinedcurrency6 fis_esl Amount in Freely Defined Currency 6
freedefinedcurrency7 fis_rfcur Freely Defined Currency 7
amountinfreedefinedcurrency7 fis_fsl Amount in Freely Defined Currency 7
freedefinedcurrency8 fis_curr8 Freely Defined Currency 8
amountinfreedefinedcurrency8 fis_gsl Amount in Freely Defined Currency 8
functionalcurrency fins_currfc Functional Currency
amountinfunctionalcurrency fis_vfccur12 Amount in Functional Currency
chartofaccounts fis_ktopl Chart of Accounts
accountingdocumenttype fis_blart Journal Entry Type
draftcreationdatetime timestampl Time Stamp
accountingdocumentitemref posnr_acc Position

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_COSTANDREVNREASSGMTITEMTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CNRREASSGMTITM_D (
    MANDT,                           -- Client [mandt]
    FISCALYEAR,                      -- Fiscal Year [fis_gjahr_no_conv]
    REFERENCEDOCUMENT,               -- Reference Document [referencedocument]
    CONTROLLINGAREA,                 -- Controlling Area [fis_kokrs]
    REFERENCEDOCUMENTITEM,           -- Reference Document Item [fis_awitem]
    LEDGERGLLINEITEM,                -- Journal Entry Item [fis_docln]
    REFERENCEDOCUMENTTYPE,           -- Reference Document Type [fis_awtyp]
    REFERENCEDOCUMENTCONTEXT,        -- Reference Document Context [fis_aworg]
    ACCOUNTINGDOCUMENT,              -- Journal Entry [fis_belnr]
    DRAFTUUID,                       -- Draft Document ID [sdraft_uuid]
    PARENTDRAFTUUID,                 -- Draft Document ID [sdraft_uuid]
    FISCALYEARFOREDIT,               -- Fiscal Year [fis_gjahr_no_conv]
    REFERENCEDOCUMENTFOREDIT,        -- Reference Document [referencedocument]
    CONTROLLINGAREAFOREDIT,          -- Controlling Area [fis_kokrs]
    REFERENCEDOCUMENTITEMFOREDIT,    -- Reference Document Item [fis_awitem]
    LEDGERGLLINEITEMFOREDIT,         -- Journal Entry Item [fis_docln]
    REFERENCEDOCUMENTTYPEFOREDIT,    -- Reference Document Type [fis_awtyp]
    ACCOUNTINGDOCUMENTFOREDIT,       -- Journal Entry [fis_belnr]
    REFERENCEDOCUMENTCONTEXTFOED,    -- Reference Document Context [fis_aworg]
    COMPANYCODE,                     -- Receiver Company Code [receivercompanycode]
    TRANSACTIONSUBITEM,              -- Sub Transaction [fins_subta]
    CONTROLLINGDOCUMENTITEM,         -- Controlling Doc Item [co_buzei_acd]
    SOURCELEDGER,                    -- Source Ledger [fins_ledger_pers]
    SENDERCOMPANYCODE,               -- Sender Company Code [sendercompanycode]
    ACCOUNTASSIGNMENT,               -- Sender Acct Assgmt [accas_sender]
    ACCOUNTASSIGNMENTTYPE,           -- Sndr AcctAssgmt Type [accasty_sender]
    PARTNERACCOUNTASSIGNMENT,        -- Partner Account Assignment [fis_paccas]
    PARTNERACCOUNTASSIGNMENTTYPE,    -- Part.AcctAssgmtType [fis_paccasty]
    PARTNERCOSTCENTER,               -- Partner Cost Center [fis_skost]
    SENDERCOSTCENTER,                -- Sender Cost Center [sendercostcenter]
    DOCUMENTITEMTEXT,                -- Item Text [farp_sgtxt]
    GLACCOUNT,                       -- Account for Allocation [fco_allocation_account]
    BASEUNIT,                        -- Base Unit [meins]
    QUANTITY,                        -- Activity Qty [lstxx]
    TRANSACTIONCURRENCY,             -- Transaction Currency [fis_rwcur]
    AMOUNTINTRANSACTIONCURRENCY,     -- Amount in Transaction Currency [fis_wsl]
    COMPANYCODECURRENCY,             -- Company Code Currency [fis_hwaer]
    AMOUNTINCOMPANYCODECURRENCY,     -- Amount in Company Code Currency [fis_hsl]
    GLOBALCURRENCY,                  -- Global Currency [fis_rkcur]
    AMOUNTINGLOBALCURRENCY,          -- Amount in Global Currency [fis_ksl]
    PARTNERWBSELEMENTEXTERNALID,     -- Partner WBSElmnt ext [fis_par_psp_pnr_ext]
    PARTNERWBSELEMENTINTERNALID,     -- Partner WBS Element Internal ID [fis_partner_wbsint_no_conv]
    WBSELEMENTINTERNALID,            -- WBS Element Internal ID [fis_wbsint_no_conv]
    WBSELEMENTEXTERNALID,            -- WBS Element External ID [fis_wbsext_no_conv]
    PARTNERSERVICEDOCUMENTTYPE,      -- Par. Service DocType [fco_psrvdoc_type]
    PARTNERSERVICEDOCUMENT,          -- Partner Service Doc. [fco_psrvdoc_id]
    PARTNERSERVICEDOCUMENTITEM,      -- Par. Service DocItem [fco_psrvdoc_item_id]
    SERVICEDOCUMENTTYPE,             -- Service Doc. Type [fco_srvdoc_type]
    SERVICEDOCUMENT,                 -- Service Document [fco_srvdoc_id]
    SERVICEDOCUMENTITEM,             -- Service Doc. Item [fco_srvdoc_item_id]
    PARTNERORDER,                    -- Partner Order [fis_par_aufnr]
    ORDERID,                         -- Order ID [fis_aufnr]
    PARTNERSALESDOCUMENT,            -- Partner Sales Doc. [fis_par_kdauf]
    PARTNERSALESDOCUMENTITEM,        -- Partner Sales Document Item [fis_par_kdpos]
    SALESDOCUMENT,                   -- Sales Document [vbeln_va]
    SALESDOCUMENTITEM,               -- Sales Document Item [fis_posnr_va]
    WORKITEM,                        -- Work Item ID [/cpd/pfp_workitem_id]
    PARTNERWORKITEM,                 -- Work Item ID [/cpd/pfp_workitem_id]
    PERSONNELNUMBER,                 -- Personnel No. [pernr_d]
    COSTACCOUNTINGDOCUMENTACTION,    -- Cost Accounting Document Action [costaccountingdocumentaction]
    CONTROLLINGBUSTRANSACTYPE,       -- Bus.Transaction [co_vorgang]
    FUND,                            -- Sender Fund [fm_sfonds]
    FUNCTIONALAREA,                  -- Sendr Fctl Area [fm_sfarea]
    GRANTID,                         -- Sender Grant [gm_grant_sender]
    BUDGETPERIOD,                    -- Budget Period [fm_budget_period]
    PARTNERFUND,                     -- Receiver Fund [fm_efonds]
    PARTNERFUNCTIONALAREA,           -- Rec. Fntcl Area [fm_efarea]
    PARTNERGRANT,                    -- Receiver Grant [gm_grant_receiver]
    PARTNERBUDGETPERIOD,             -- Par. BudPer [fm_pbudget_period]
    FINANCIALMANAGEMENTAREA,         -- FM Area [fikrs]
    RCVRACCTGINDCODE,                -- Rec. acct. ind. [ebemot]
    ACCOUNTINGINDICATORCODE,         -- AcctIndicator [bemot]
    POSTINGDATE,                     -- Posting Date [fis_budat]
    PARTNERCOSTRECOVERYCODE,         -- Joint Venture Cost Recovery Code [jv_recind_cds]
    SENDERCOSTRECOVERYCODE,          -- Sender Cost Recovery Code [jv_srecind_cds]
    OPERATINGCONCERN,                -- Operating concern [erkrs]
    PARTNERPROFITABILITYSEGMENT,     -- PartnerPrf.Seg. [rkepobj]
    PARTPROFITABILITYSGMTISASSGD,    -- Profitability Segment Is Assigned [profitabilitysegmentisassigned]
    PROFITABILITYSEGMENT,            -- Profit. segment [rkeobjnr]
    PROFITABILITYSEGMENTISASSIGNED,  -- Profitability Segment Is Assigned [profitabilitysegmentisassigned]
    RECEIVERRECOMPANYCODE,           -- Partner CoCode [pbukrs]
    REALESTATEPARTNERCONTRACT,       -- Real Estate Partner Contract [recnvdmpcnnr]
    SENDERRECOMPANYCODE,             -- Send.comp.code [vvsbukrs]
    REALESTATECONTRACT,              -- Real Estate Contract [recnvdmcnnr]
    PARTNERPROFITCENTER,             -- Profit Center [fis_prctr]
    PROFITCENTER,                    -- Profit Center [fis_prctr]
    SERVICESRENDEREDDATE,            -- Serv. Rend. Dte [fbuda]
    FREEDEFINEDCURRENCY1,            -- Freely Defined Currency 1 [fis_rocur]
    AMOUNTINFREEDEFINEDCURRENCY1,    -- Amount in Freely Defined Currency 1 [fis_osl]
    FREEDEFINEDCURRENCY2,            -- Freely Defined Currency 2 [fis_rvcur]
    AMOUNTINFREEDEFINEDCURRENCY2,    -- Amount in Freely Defined Currency 2 [fis_vsl]
    FREEDEFINEDCURRENCY3,            -- Freely Defined Currency 3 [fis_curr3]
    AMOUNTINFREEDEFINEDCURRENCY3,    -- Amount in Freely Defined Currency 3 [fis_bsl]
    FREEDEFINEDCURRENCY4,            -- Freely Defined Currency 4 [fis_curr4]
    AMOUNTINFREEDEFINEDCURRENCY4,    -- Amount in Freely Defined Currency 4 [fis_csl]
    FREEDEFINEDCURRENCY5,            -- Freely Defined Currency 5 [fis_curr5]
    AMOUNTINFREEDEFINEDCURRENCY5,    -- Amount in Freely Defined Currency 5 [fis_dsl]
    FREEDEFINEDCURRENCY6,            -- Freely Defined Currency 6 [fis_curr6]
    AMOUNTINFREEDEFINEDCURRENCY6,    -- Amount in Freely Defined Currency 6 [fis_esl]
    FREEDEFINEDCURRENCY7,            -- Freely Defined Currency 7 [fis_rfcur]
    AMOUNTINFREEDEFINEDCURRENCY7,    -- Amount in Freely Defined Currency 7 [fis_fsl]
    FREEDEFINEDCURRENCY8,            -- Freely Defined Currency 8 [fis_curr8]
    AMOUNTINFREEDEFINEDCURRENCY8,    -- Amount in Freely Defined Currency 8 [fis_gsl]
    FUNCTIONALCURRENCY,              -- Functional Currency [fins_currfc]
    AMOUNTINFUNCTIONALCURRENCY,      -- Amount in Functional Currency [fis_vfccur12]
    CHARTOFACCOUNTS,                 -- Chart of Accounts [fis_ktopl]
    ACCOUNTINGDOCUMENTTYPE,          -- Journal Entry Type [fis_blart]
    DRAFTCREATIONDATETIME,           -- Time Stamp [timestampl]
    ACCOUNTINGDOCUMENTITEMREF,       -- Position [posnr_acc]
    PRIMARY KEY (MANDT, FISCALYEAR, REFERENCEDOCUMENT, CONTROLLINGAREA, REFERENCEDOCUMENTITEM, LEDGERGLLINEITEM, REFERENCEDOCUMENTTYPE, REFERENCEDOCUMENTCONTEXT, ACCOUNTINGDOCUMENT, DRAFTUUID)
);

Learn More