DRCTACTYALLOC_D

Transparent Table Application Table
45 Fields 1 CDS Views

Draft table for entity R_DIRECTACTIVITYALLOCATIONTP

DRCTACTYALLOC_D is an SAP database table in S/4HANA. Draft table for entity R_DIRECTACTIVITYALLOCATIONTP. It contains 45 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_DrctActivityAllocationDraft view_entity from BASIC Direct Activity Allocation - Draft

Fields (45)

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
fiscalperiod FINS_FISCALPERIOD Fiscal Period
fiscalyearperiod FIS_JAHRPER_CONV Fiscal Year Period
accountingdocumentcreationdate FARP_CPUDT Entered On
accountingdoccreatedbyuser FCO_CC_CREATEDBY Created By
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
predecessorreferencedocument FIS_PREC_AWREF Predecessor Reference Document
reversalreferencedocument FIS_AWREF_REV Reversal Reference Document
reversedreferencedocument REVERSEDREFERENCEDOCUMENT Reversed Reference Document
successorreferencedocument SUCCESSORREFERENCEDOCUMENT Successor Reference Document
globalcurrency FIS_RKCUR Global Currency
totalamountinglobalcurrency FIS_KSL Amount in Global Currency
controllingbustransactype FINS_CO_BUS_TRANS CO Bus. Transaction
businesstransactioncategory FIS_BTTYPE Business Transaction Category
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
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Draft - Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Field Changes

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_DIRECTACTIVITYALLOCATIONTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DRCTACTYALLOC_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]
    FISCALPERIOD,                    -- Fiscal Period [FINS_FISCALPERIOD]
    FISCALYEARPERIOD,                -- Fiscal Year Period [FIS_JAHRPER_CONV]
    ACCOUNTINGDOCUMENTCREATIONDATE,  -- Entered On [FARP_CPUDT]
    ACCOUNTINGDOCCREATEDBYUSER,      -- Created By [FCO_CC_CREATEDBY]
    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]
    PREDECESSORREFERENCEDOCUMENT,    -- Predecessor Reference Document [FIS_PREC_AWREF]
    REVERSALREFERENCEDOCUMENT,       -- Reversal Reference Document [FIS_AWREF_REV]
    REVERSEDREFERENCEDOCUMENT,       -- Reversed Reference Document [REVERSEDREFERENCEDOCUMENT]
    SUCCESSORREFERENCEDOCUMENT,      -- Successor Reference Document [SUCCESSORREFERENCEDOCUMENT]
    GLOBALCURRENCY,                  -- Global Currency [FIS_RKCUR]
    TOTALAMOUNTINGLOBALCURRENCY,     -- Amount in Global Currency [FIS_KSL]
    CONTROLLINGBUSTRANSACTYPE,       -- CO Bus. Transaction [FINS_CO_BUS_TRANS]
    BUSINESSTRANSACTIONCATEGORY,     -- Business Transaction Category [FIS_BTTYPE]
    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]
    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]
    PRIMARY KEY (MANDT, FISCALYEAR, REFERENCEDOCUMENT, CONTROLLINGAREA, REFERENCEDOCUMENTTYPE, REFERENCEDOCUMENTCONTEXT, DRAFTUUID)
);

Learn More