DRCTACTYITMPS_D

Transparent Table Application Table
43 Fields 2 CDS Views

Draft table for entity R_DRCTACTYALLOCPRFTBLTYSGMTTP

DRCTACTYITMPS_D is an SAP database table in S/4HANA. Draft table for entity R_DRCTACTYALLOCPRFTBLTYSGMTTP. It contains 43 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_ActgActAlcPrftbltySgmtDraft view_entity from EXTENSION Direct Activity Allocation PS - Extension
R_ActgActAlcPrftbltySgmtDraft view_entity from BASIC Direct Activity Allocation PS - Draft

Fields (43)

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
companycode fis_bukrs Company Code
transactionsubitem fins_subta Sub Transaction
controllingdocumentitem co_buzei_acd Controlling Doc Item
sourceledger fins_ledger_pers Source Ledger
customer kunnr Customer
customergroup kdgrp Customer Group
customersupplierindustry fis_brsch Customer Supplier Industry
customersuppliercountry fis_land1_gp Customer or Supplier Country/Region
salesdistrict bzirk Sales District
soldproduct fins_matnr_pa Product Sold
soldproductgroup fins_matkl_pa Product Sold Group
salesorganization vkorg Sales Org.
distributionchannel vtweg Distr. Channel
organizationdivision spart Division
billtoparty kunre Bill-to Party
shiptoparty kunwe Ship-to Party
wbselementinternalid fis_wbsint_no_conv WBS Element Internal ID
wbselementexternalid fis_wbsext_no_conv WBS Element External ID
servicedocumenttype fco_srvdoc_type Service Doc. Type
servicedocument fco_srvdoc_id Service Document
servicedocumentitem fco_srvdoc_item_id Service Doc. Item
salesdocument vbeln_va Sales Document
salesdocumentitem posnr_va Item
profitcenter fis_prctr Profit Center
partnerprofitcenter fis_pprctr Partner Profit Center
functionalarea fm_farea Functional Area
partnercompanycode fis_pbukrs Partner Company Code
controllingbustransactype co_vorgang Bus.Transaction
businesstransactioncategory fis_bttype Business Transaction Category
originctrlgdebitcreditcode beknz_mask Debit/CreditInd
debitcreditcode fis_shkzg Debit/Credit Code
actyallocationdraftuuid sdraft_uuid Draft Document ID

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_DRCTACTYALLOCPRFTBLTYSGMTTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DRCTACTYITMPS_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]
    COMPANYCODE,                  -- Company Code [fis_bukrs]
    TRANSACTIONSUBITEM,           -- Sub Transaction [fins_subta]
    CONTROLLINGDOCUMENTITEM,      -- Controlling Doc Item [co_buzei_acd]
    SOURCELEDGER,                 -- Source Ledger [fins_ledger_pers]
    CUSTOMER,                     -- Customer [kunnr]
    CUSTOMERGROUP,                -- Customer Group [kdgrp]
    CUSTOMERSUPPLIERINDUSTRY,     -- Customer Supplier Industry [fis_brsch]
    CUSTOMERSUPPLIERCOUNTRY,      -- Customer or Supplier Country/Region [fis_land1_gp]
    SALESDISTRICT,                -- Sales District [bzirk]
    SOLDPRODUCT,                  -- Product Sold [fins_matnr_pa]
    SOLDPRODUCTGROUP,             -- Product Sold Group [fins_matkl_pa]
    SALESORGANIZATION,            -- Sales Org. [vkorg]
    DISTRIBUTIONCHANNEL,          -- Distr. Channel [vtweg]
    ORGANIZATIONDIVISION,         -- Division [spart]
    BILLTOPARTY,                  -- Bill-to Party [kunre]
    SHIPTOPARTY,                  -- Ship-to Party [kunwe]
    WBSELEMENTINTERNALID,         -- WBS Element Internal ID [fis_wbsint_no_conv]
    WBSELEMENTEXTERNALID,         -- WBS Element External ID [fis_wbsext_no_conv]
    SERVICEDOCUMENTTYPE,          -- Service Doc. Type [fco_srvdoc_type]
    SERVICEDOCUMENT,              -- Service Document [fco_srvdoc_id]
    SERVICEDOCUMENTITEM,          -- Service Doc. Item [fco_srvdoc_item_id]
    SALESDOCUMENT,                -- Sales Document [vbeln_va]
    SALESDOCUMENTITEM,            -- Item [posnr_va]
    PROFITCENTER,                 -- Profit Center [fis_prctr]
    PARTNERPROFITCENTER,          -- Partner Profit Center [fis_pprctr]
    FUNCTIONALAREA,               -- Functional Area [fm_farea]
    PARTNERCOMPANYCODE,           -- Partner Company Code [fis_pbukrs]
    CONTROLLINGBUSTRANSACTYPE,    -- Bus.Transaction [co_vorgang]
    BUSINESSTRANSACTIONCATEGORY,  -- Business Transaction Category [fis_bttype]
    ORIGINCTRLGDEBITCREDITCODE,   -- Debit/CreditInd [beknz_mask]
    DEBITCREDITCODE,              -- Debit/Credit Code [fis_shkzg]
    ACTYALLOCATIONDRAFTUUID,      -- Draft Document ID [sdraft_uuid]
    PRIMARY KEY (MANDT, FISCALYEAR, REFERENCEDOCUMENT, CONTROLLINGAREA, REFERENCEDOCUMENTITEM, LEDGERGLLINEITEM, REFERENCEDOCUMENTTYPE, REFERENCEDOCUMENTCONTEXT, ACCOUNTINGDOCUMENT, DRAFTUUID)
);

Learn More