DRCTACTYITM_D

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_DRCTACTIVITYALLOCATIONITEMTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DRCTACTYITM_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]
    SOURCELEDGER,                    -- Source Ledger [FINS_LEDGER_PERS]
    COMPANYCODE,                     -- Company Code [FIS_BUKRS]
    SENDERCOMPANYCODE,               -- Sender Company Code [SENDERCOMPANYCODE]
    ACCOUNTASSIGNMENT,               -- Account Assignment [ACCAS]
    ACCOUNTASSIGNMENTTYPE,           -- Account Assignment Type [FIS_ACCASTY]
    PARTNERACCOUNTASSIGNMENT,        -- Partner Account Assignment [FIS_PACCAS]
    PARTNERACCOUNTASSIGNMENTTYPE,    -- Partner Account Assignment Type [FINS_PACCASTY]
    PARTNERCOSTCTRACTIVITYTYPE,      -- Partner Cost Center Activity Type [FIS_PAR_LSTAR]
    COSTCTRACTIVITYTYPE,             -- Activity Type [LSTAR]
    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]
    PRCTOTAMTINTRANSACTIONCURRENCY,  -- Total Cost Rate in Trans. Crcy [PRICETOTALAMTINTRANSCRCY]
    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]
    PRCTOTAMTINCOMPANYCODECURRENCY,  -- Total Cost Rate in CC Crcy [PRICETOTALAMTINCOCODECRCY]
    GLOBALCURRENCY,                  -- Global Currency [FIS_RKCUR]
    AMOUNTINGLOBALCURRENCY,          -- Amount in Global Currency [FIS_KSL]
    PRCTOTAMTINGLOBALCURRENCY,       -- Total Cost Rate in Global Crcy [PRCTOTAMTINGLOBALCURRENCY]
    PARTNERWBSELEMENTEXTERNALID,     -- Partner WBSElmnt ext [FIS_PAR_PSP_PNR_EXT]
    PARTNERWBSELEMENTINTERNALID,     -- Partner WBS Element Internal ID [FIS_PARTNER_WBSINT_NO_CONV]
    PARTNERPROJECTEXTERNALID,        -- Partner Project External ID [FIS_PART_PROJECTEXT_NO_CONV]
    PARTNERSERVICEDOCUMENTTYPE,      -- Par. Service DocType [FCO_PSRVDOC_TYPE]
    PARTNERSERVICEDOCUMENT,          -- Partner Service Doc. [FCO_PSRVDOC_ID]
    PARTNERSERVICEDOCUMENTITEM,      -- Par. Service DocItem [FCO_PSRVDOC_ITEM_ID]
    PARTNERPROJECTNETWORK,           -- Part. Proj. Network [PAR_NPLN]
    PARTNERORDER,                    -- Partner Order [FIS_PAR_AUFNR]
    PARTNERPROJECTNETWORKACTIVITY,   -- Partner Project Network Activity [FIS_PAR_VORNR_AUF_NO_CONV]
    PARTNERCOMPANYCODE,              -- Partner CoCode [PBUKRS]
    PARTNERCOSTOBJECT,               -- Partner Cost Object [PAR_KSTRG]
    PARTNERSALESDOCUMENT,            -- Partner Sales Doc. [FIS_PAR_KDAUF]
    PARTNERSALESDOCUMENTITEM,        -- Partner Sales Document Item [FIS_PAR_KDPOS]
    WORKITEM,                        -- Work Item ID [/CPD/PFP_WORKITEM_ID]
    PERSONNELNUMBER,                 -- Personnel No. [PERNR_D]
    RECEIVERPROCUREMENTPROCESS,      -- Prod. Proc. No. [CKML_F_PROCNR]
    PLANT,                           -- Plant [WERKS_D]
    PARTNERBUSINESSPROCESS,          -- Part. Bus. Process [PAR_PRZNR]
    PRODUCT,                         -- Product [PRODUCTNUMBER]
    COSTACCOUNTINGDOCUMENTACTION,    -- Cost Accounting Document Action [COSTACCOUNTINGDOCUMENTACTION]
    CONTROLLINGDOCUMENTSTATUS,       -- Is Posted [FCO_DRCT_ACTY_IS_POSTED]
    CONTROLLINGBUSTRANSACTYPE,       -- Bus.Transaction [CO_VORGANG]
    CONTROLLINGDOCUMENTITEM,         -- Controlling Doc Item [CO_BUZEI_ACD]
    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]
    ISSETTLED,                       -- Is Settled [FINS_XSETTLED]
    BILLABLECONTROL,                 -- Billable Control [FIS_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,     -- Profit. segment [RKEOBJNR]
    PARTPROFITABILITYSGMTISASSGD,    -- Profitability Segment Is Assigned [PROFITABILITYSEGMENTISASSIGNED]
    ORDEROPERATION,                  -- Operation or Phase [VDM_VORNR]
    RECEIVERRECOMPANYCODE,           -- Partner CoCode [PBUKRS]
    REPARTNERBUSINESSENTITY,         -- RE Partner Business Entity [REBDVDMPBENO]
    REALESTATEPARTNERBUILDING,       -- Real Estate Partner Building [REBDVDMPBUNO]
    REALESTATEPARTNERPROPERTY,       -- Real Estate Partner Property [REBDVDMPPRNO]
    REPARTNERRENTALOBJECT,           -- RE Partner Rental Object [REBDVDMPRONO]
    REALESTATEPARTNERCONTRACT,       -- Real Estate Partner Contract [RECNVDMPCNNR]
    REPARTNERSERVICECHARGEKEY,       -- RE Partner Service Charge Key [RESCVDMPSCKEY]
    REPARTNERSETTLEMENTUNITID,       -- RE Partner Settlement Unit [RESCVDMPSUID]
    PARTNERSETTLEMENTREFERENCEDATE,  -- Ptnr. Reference Date [FINS_PAR_DABRBEZ]
    PARTNERPROFITCENTER,             -- Partner Profit Center [FIS_PPRCTR]
    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]
    TRANSACTIONSUBITEM,              -- Sub Transaction [FINS_SUBTA]
    ACCOUNTINGDOCUMENTTYPE,          -- Journal Entry Type [FIS_BLART]
    DRAFTCREATIONDATETIME,           -- Time Stamp [TIMESTAMPL]
    DRAFTENTITYCREATIONDATETIME,     -- Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,        -- Draft - Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                 -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,               -- Field Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    DUMMY_INCL_EEW_COBL,             -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, FISCALYEAR, REFERENCEDOCUMENT, CONTROLLINGAREA, REFERENCEDOCUMENTITEM, LEDGERGLLINEITEM, REFERENCEDOCUMENTTYPE, REFERENCEDOCUMENTCONTEXT, ACCOUNTINGDOCUMENT, DRAFTUUID)
);