IPRODNUCB_DOC

Transparent Table Application Table
170 Fields 1 CDS Views

Document Table for CDS View:I_PRODNCOSTACTCOMPBRKDWNC

IPRODNUCB_DOC is an SAP database table in S/4HANA. Document Table for CDS View:I_PRODNCOSTACTCOMPBRKDWNC. It contains 170 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ProdnCostActlCmpBrkdnDSt view_entity from BASIC Commenting Doc

Fields (170)

KeyField Data ElementDescription
KEY client abap.clnt
KEY docid abap.numc
KEY version abap.numc
doctag abap.char
docqprov abap.char
tra_00001 abap.char
sva_00001 abap.char
tra_billtoparty abap.char
sva_billtoparty abap.char
tra_00002 abap.char
sva_00002 abap.char
svh_00002 abap.char
hnm_00002 abap.char
hno_00002 abap.char
hio_00002 abap.char
tra_functionalarea abap.char
sva_functionalarea abap.char
tra_00003 abap.char
sva_00003 abap.char
tra_00004 abap.char
sva_00004 abap.char
tra_salesdistrict abap.char
sva_salesdistrict abap.char
tra_00005 abap.char
sva_00005 abap.char
tra_costcenter abap.char
sva_costcenter abap.char
tra_00006 abap.char
sva_00006 abap.char
tra_product abap.char
sva_product abap.char
svh_product abap.char
hnm_product abap.char
hno_product abap.char
hio_product abap.char
tra_customergroup abap.char
sva_customergroup abap.char
tra_customer abap.char
sva_customer abap.char
tra_segment abap.char
sva_segment abap.char
tra_00007 abap.char
sva_00007 abap.char
tra_plant abap.char
sva_plant abap.char
svh_plant abap.char
hnm_plant abap.char
hno_plant abap.char
hio_plant abap.char
tra_costestimate abap.numc
sva_costestimate abap.char
tra_00008 abap.char
sva_00008 abap.char
tra_00009 abap.char
sva_00009 abap.char
tra_sourceledger abap.char
sva_sourceledger abap.char
tra_companycode abap.char
sva_companycode abap.char
svh_companycode abap.char
hnm_companycode abap.char
hno_companycode abap.char
hio_companycode abap.char
tra_p_ledger abap.char
sva_p_ledger abap.char
tra_profitcenter abap.char
sva_profitcenter abap.char
svh_profitcenter abap.char
hnm_profitcenter abap.char
hno_profitcenter abap.char
hio_profitcenter abap.char
tra_00010 abap.char
sva_00010 abap.char
tra_00011 abap.char
sva_00011 abap.char
tra_shiptoparty abap.char
sva_shiptoparty abap.char
tra_00012 abap.char
sva_00012 abap.char
tra_orderid abap.char
sva_orderid abap.char
tra_00013 abap.numc
sva_00013 abap.char
tra_00014 abap.char
sva_00014 abap.char
tra_00015 abap.cuky
sva_00015 abap.char
tra_00016 abap.char
sva_00016 abap.char
tra_00017 abap.char
sva_00017 abap.char
tra_00018 abap.numc
sva_00018 abap.char
tra_fiscalyear abap.numc
sva_fiscalyear abap.char
tra_00019 abap.char
sva_00019 abap.char
tra_00020 abap.char
sva_00020 abap.char
tra_p_companycode abap.char
sva_p_companycode abap.char
tra_postingdate abap.dats
sva_postingdate abap.char
svh_postingdate abap.char
hnm_postingdate abap.char
hno_postingdate abap.char
hio_postingdate abap.char
tra_p_currencyrole abap.char
sva_p_currencyrole abap.char
tra_fiscalperiod abap.numc
sva_fiscalperiod abap.char
tra_00021 abap.char
sva_00021 abap.char
tra_soldproduct abap.char
sva_soldproduct abap.char
tra_businessarea abap.char
sva_businessarea abap.char
tra_salesdocument abap.char
sva_salesdocument abap.char
tra_00022 abap.char
sva_00022 abap.char
tra_glaccount abap.char
sva_glaccount abap.char
svh_glaccount abap.char
hnm_glaccount abap.char
hno_glaccount abap.char
hio_glaccount abap.char
tra_orderitem abap.numc
sva_orderitem abap.char
tra_ordercategory abap.numc
sva_ordercategory abap.char
tra_00023 abap.char
sva_00023 abap.char
tra_00024 abap.char
sva_00024 abap.char
svh_00024 abap.char
hnm_00024 abap.char
hno_00024 abap.char
hio_00024 abap.char
tra_00025 abap.char
sva_00025 abap.char
tra_00026 abap.char
sva_00026 abap.char
tra_00027 abap.char
sva_00027 abap.char
tra_00028 abap.numc
sva_00028 abap.char
tra_00029 abap.char
sva_00029 abap.char
svh_00029 abap.char
hnm_00029 abap.char
hno_00029 abap.char
hio_00029 abap.char
tra_00030 abap.char
sva_00030 abap.char
svh_00030 abap.char
hnm_00030 abap.char
hno_00030 abap.char
hio_00030 abap.char
doctype abap.char
owner abap.char
infoprov abap.char
sva_infoprov abap.char
kyfnm abap.char
docstat abap.char
session_id abap.char
timestamp abap.dec
document abap.rawstring
seldr abap.rawstring
docprop abap.rawstring

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.

-- Document Table for CDS View:I_PRODNCOSTACTCOMPBRKDWNC
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE IPRODNUCB_DOC (
    CLIENT,              -- abap.clnt
    DOCID,               -- abap.numc
    VERSION,             -- abap.numc
    DOCTAG,              -- abap.char
    DOCQPROV,            -- abap.char
    TRA_00001,           -- abap.char
    SVA_00001,           -- abap.char
    TRA_BILLTOPARTY,     -- abap.char
    SVA_BILLTOPARTY,     -- abap.char
    TRA_00002,           -- abap.char
    SVA_00002,           -- abap.char
    SVH_00002,           -- abap.char
    HNM_00002,           -- abap.char
    HNO_00002,           -- abap.char
    HIO_00002,           -- abap.char
    TRA_FUNCTIONALAREA,  -- abap.char
    SVA_FUNCTIONALAREA,  -- abap.char
    TRA_00003,           -- abap.char
    SVA_00003,           -- abap.char
    TRA_00004,           -- abap.char
    SVA_00004,           -- abap.char
    TRA_SALESDISTRICT,   -- abap.char
    SVA_SALESDISTRICT,   -- abap.char
    TRA_00005,           -- abap.char
    SVA_00005,           -- abap.char
    TRA_COSTCENTER,      -- abap.char
    SVA_COSTCENTER,      -- abap.char
    TRA_00006,           -- abap.char
    SVA_00006,           -- abap.char
    TRA_PRODUCT,         -- abap.char
    SVA_PRODUCT,         -- abap.char
    SVH_PRODUCT,         -- abap.char
    HNM_PRODUCT,         -- abap.char
    HNO_PRODUCT,         -- abap.char
    HIO_PRODUCT,         -- abap.char
    TRA_CUSTOMERGROUP,   -- abap.char
    SVA_CUSTOMERGROUP,   -- abap.char
    TRA_CUSTOMER,        -- abap.char
    SVA_CUSTOMER,        -- abap.char
    TRA_SEGMENT,         -- abap.char
    SVA_SEGMENT,         -- abap.char
    TRA_00007,           -- abap.char
    SVA_00007,           -- abap.char
    TRA_PLANT,           -- abap.char
    SVA_PLANT,           -- abap.char
    SVH_PLANT,           -- abap.char
    HNM_PLANT,           -- abap.char
    HNO_PLANT,           -- abap.char
    HIO_PLANT,           -- abap.char
    TRA_COSTESTIMATE,    -- abap.numc
    SVA_COSTESTIMATE,    -- abap.char
    TRA_00008,           -- abap.char
    SVA_00008,           -- abap.char
    TRA_00009,           -- abap.char
    SVA_00009,           -- abap.char
    TRA_SOURCELEDGER,    -- abap.char
    SVA_SOURCELEDGER,    -- abap.char
    TRA_COMPANYCODE,     -- abap.char
    SVA_COMPANYCODE,     -- abap.char
    SVH_COMPANYCODE,     -- abap.char
    HNM_COMPANYCODE,     -- abap.char
    HNO_COMPANYCODE,     -- abap.char
    HIO_COMPANYCODE,     -- abap.char
    TRA_P_LEDGER,        -- abap.char
    SVA_P_LEDGER,        -- abap.char
    TRA_PROFITCENTER,    -- abap.char
    SVA_PROFITCENTER,    -- abap.char
    SVH_PROFITCENTER,    -- abap.char
    HNM_PROFITCENTER,    -- abap.char
    HNO_PROFITCENTER,    -- abap.char
    HIO_PROFITCENTER,    -- abap.char
    TRA_00010,           -- abap.char
    SVA_00010,           -- abap.char
    TRA_00011,           -- abap.char
    SVA_00011,           -- abap.char
    TRA_SHIPTOPARTY,     -- abap.char
    SVA_SHIPTOPARTY,     -- abap.char
    TRA_00012,           -- abap.char
    SVA_00012,           -- abap.char
    TRA_ORDERID,         -- abap.char
    SVA_ORDERID,         -- abap.char
    TRA_00013,           -- abap.numc
    SVA_00013,           -- abap.char
    TRA_00014,           -- abap.char
    SVA_00014,           -- abap.char
    TRA_00015,           -- abap.cuky
    SVA_00015,           -- abap.char
    TRA_00016,           -- abap.char
    SVA_00016,           -- abap.char
    TRA_00017,           -- abap.char
    SVA_00017,           -- abap.char
    TRA_00018,           -- abap.numc
    SVA_00018,           -- abap.char
    TRA_FISCALYEAR,      -- abap.numc
    SVA_FISCALYEAR,      -- abap.char
    TRA_00019,           -- abap.char
    SVA_00019,           -- abap.char
    TRA_00020,           -- abap.char
    SVA_00020,           -- abap.char
    TRA_P_COMPANYCODE,   -- abap.char
    SVA_P_COMPANYCODE,   -- abap.char
    TRA_POSTINGDATE,     -- abap.dats
    SVA_POSTINGDATE,     -- abap.char
    SVH_POSTINGDATE,     -- abap.char
    HNM_POSTINGDATE,     -- abap.char
    HNO_POSTINGDATE,     -- abap.char
    HIO_POSTINGDATE,     -- abap.char
    TRA_P_CURRENCYROLE,  -- abap.char
    SVA_P_CURRENCYROLE,  -- abap.char
    TRA_FISCALPERIOD,    -- abap.numc
    SVA_FISCALPERIOD,    -- abap.char
    TRA_00021,           -- abap.char
    SVA_00021,           -- abap.char
    TRA_SOLDPRODUCT,     -- abap.char
    SVA_SOLDPRODUCT,     -- abap.char
    TRA_BUSINESSAREA,    -- abap.char
    SVA_BUSINESSAREA,    -- abap.char
    TRA_SALESDOCUMENT,   -- abap.char
    SVA_SALESDOCUMENT,   -- abap.char
    TRA_00022,           -- abap.char
    SVA_00022,           -- abap.char
    TRA_GLACCOUNT,       -- abap.char
    SVA_GLACCOUNT,       -- abap.char
    SVH_GLACCOUNT,       -- abap.char
    HNM_GLACCOUNT,       -- abap.char
    HNO_GLACCOUNT,       -- abap.char
    HIO_GLACCOUNT,       -- abap.char
    TRA_ORDERITEM,       -- abap.numc
    SVA_ORDERITEM,       -- abap.char
    TRA_ORDERCATEGORY,   -- abap.numc
    SVA_ORDERCATEGORY,   -- abap.char
    TRA_00023,           -- abap.char
    SVA_00023,           -- abap.char
    TRA_00024,           -- abap.char
    SVA_00024,           -- abap.char
    SVH_00024,           -- abap.char
    HNM_00024,           -- abap.char
    HNO_00024,           -- abap.char
    HIO_00024,           -- abap.char
    TRA_00025,           -- abap.char
    SVA_00025,           -- abap.char
    TRA_00026,           -- abap.char
    SVA_00026,           -- abap.char
    TRA_00027,           -- abap.char
    SVA_00027,           -- abap.char
    TRA_00028,           -- abap.numc
    SVA_00028,           -- abap.char
    TRA_00029,           -- abap.char
    SVA_00029,           -- abap.char
    SVH_00029,           -- abap.char
    HNM_00029,           -- abap.char
    HNO_00029,           -- abap.char
    HIO_00029,           -- abap.char
    TRA_00030,           -- abap.char
    SVA_00030,           -- abap.char
    SVH_00030,           -- abap.char
    HNM_00030,           -- abap.char
    HNO_00030,           -- abap.char
    HIO_00030,           -- abap.char
    DOCTYPE,             -- abap.char
    OWNER,               -- abap.char
    INFOPROV,            -- abap.char
    SVA_INFOPROV,        -- abap.char
    KYFNM,               -- abap.char
    DOCSTAT,             -- abap.char
    SESSION_ID,          -- abap.char
    TIMESTAMP,           -- abap.dec
    DOCUMENT,            -- abap.rawstring
    SELDR,               -- abap.rawstring
    DOCPROP,             -- abap.rawstring
    PRIMARY KEY (CLIENT, DOCID, VERSION)
);

Learn More