IPUBSECBDDSTTAB
Document Table for CDS View:I_PUBSECBDGTLINEITEMCUBE
IPUBSECBDDSTTAB is an SAP database table in S/4HANA. Document Table for CDS View:I_PUBSECBDGTLINEITEMCUBE. It contains 430 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_PubSecBdgtLineItemDSt | view_entity | from | BASIC | Budget Line Items Doc Store |
Fields (430)
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_PUBSECBDGTLINEITEMCUBE
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE IPUBSECBDDSTTAB (
CLIENT, -- abap.clnt
DOCID, -- abap.numc
VERSION, -- abap.numc
DOCTAG, -- abap.char
DOCQPROV, -- abap.char
TRA_00001, -- abap.char
SVA_00001, -- abap.char
SVH_00001, -- abap.char
HNM_00001, -- abap.char
HNO_00001, -- abap.char
HIO_00001, -- 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_00003, -- abap.int4
SVA_00003, -- abap.char
TRA_00004, -- abap.char
SVA_00004, -- abap.char
TRA_00005, -- abap.numc
SVA_00005, -- abap.char
TRA_00006, -- abap.char
SVA_00006, -- abap.char
SVH_00006, -- abap.char
HNM_00006, -- abap.char
HNO_00006, -- abap.char
HIO_00006, -- abap.char
TRA_00007, -- abap.char
SVA_00007, -- abap.char
TRA_00008, -- abap.numc
SVA_00008, -- abap.char
SVH_00008, -- abap.char
HNM_00008, -- abap.char
HNO_00008, -- abap.char
HIO_00008, -- abap.char
TRA_BUDGETDOCUMENT, -- abap.char
SVA_BUDGETDOCUMENT, -- abap.char
TRA_GRANTHIERARCHY, -- abap.char
SVA_GRANTHIERARCHY, -- abap.char
SVH_GRANTHIERARCHY, -- abap.char
HNM_GRANTHIERARCHY, -- abap.char
HNO_GRANTHIERARCHY, -- abap.char
HIO_GRANTHIERARCHY, -- abap.char
TRA_00009, -- abap.char
SVA_00009, -- abap.char
SVH_00009, -- abap.char
HNM_00009, -- abap.char
HNO_00009, -- abap.char
HIO_00009, -- abap.char
TRA_SALESDISTRICT, -- abap.char
SVA_SALESDISTRICT, -- abap.char
SVH_SALESDISTRICT, -- abap.char
HNM_SALESDISTRICT, -- abap.char
HNO_SALESDISTRICT, -- abap.char
HIO_SALESDISTRICT, -- abap.char
TRA_PARTNERORDER_2, -- abap.char
SVA_PARTNERORDER_2, -- abap.char
SVH_PARTNERORDER_2, -- abap.char
HNM_PARTNERORDER_2, -- abap.char
HNO_PARTNERORDER_2, -- abap.char
HIO_PARTNERORDER_2, -- abap.char
TRA_GLOBALCURRENCY, -- abap.cuky
SVA_GLOBALCURRENCY, -- abap.char
TRA_00010, -- abap.char
SVA_00010, -- abap.char
SVH_00010, -- abap.char
HNM_00010, -- abap.char
HNO_00010, -- abap.char
HIO_00010, -- abap.char
TRA_00011, -- abap.char
SVA_00011, -- abap.char
SVH_00011, -- abap.char
HNM_00011, -- abap.char
HNO_00011, -- abap.char
HIO_00011, -- abap.char
TRA_00012, -- abap.numc
SVA_00012, -- abap.char
TRA_00013, -- abap.cuky
SVA_00013, -- abap.char
TRA_00014, -- abap.char
SVA_00014, -- abap.char
TRA_00015, -- abap.char
SVA_00015, -- abap.char
TRA_00016, -- abap.char
SVA_00016, -- abap.char
SVH_00016, -- abap.char
HNM_00016, -- abap.char
HNO_00016, -- abap.char
HIO_00016, -- abap.char
TRA_PARTNERCOMPANY, -- abap.char
SVA_PARTNERCOMPANY, -- abap.char
SVH_PARTNERCOMPANY, -- abap.char
HNM_PARTNERCOMPANY, -- abap.char
HNO_PARTNERCOMPANY, -- abap.char
HIO_PARTNERCOMPANY, -- abap.char
TRA_00017, -- abap.char
SVA_00017, -- abap.char
TRA_ASSETCLASS, -- abap.char
SVA_ASSETCLASS, -- abap.char
TRA_COSTCENTER, -- abap.char
SVA_COSTCENTER, -- abap.char
SVH_COSTCENTER, -- abap.char
HNM_COSTCENTER, -- abap.char
HNO_COSTCENTER, -- abap.char
HIO_COSTCENTER, -- abap.char
TRA_CUSTOMER, -- abap.char
SVA_CUSTOMER, -- abap.char
SVH_CUSTOMER, -- abap.char
HNM_CUSTOMER, -- abap.char
HNO_CUSTOMER, -- abap.char
HIO_CUSTOMER, -- abap.char
TRA_FISCALYEAR, -- abap.numc
SVA_FISCALYEAR, -- abap.char
TRA_FIXEDASSET, -- abap.char
SVA_FIXEDASSET, -- abap.char
TRA_FUND, -- abap.char
SVA_FUND, -- abap.char
SVH_FUND, -- abap.char
HNM_FUND, -- abap.char
HNO_FUND, -- abap.char
HIO_FUND, -- abap.char
TRA_FUNDTYPE, -- abap.char
SVA_FUNDTYPE, -- 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_GRANTID, -- abap.char
SVA_GRANTID, -- abap.char
SVH_GRANTID, -- abap.char
HNM_GRANTID, -- abap.char
HNO_GRANTID, -- abap.char
HIO_GRANTID, -- abap.char
TRA_LEDGER, -- abap.char
SVA_LEDGER, -- abap.char
TRA_ORDERID, -- abap.char
SVA_ORDERID, -- abap.char
SVH_ORDERID, -- abap.char
HNM_ORDERID, -- abap.char
HNO_ORDERID, -- abap.char
HIO_ORDERID, -- abap.char
TRA_ORDERITEM, -- abap.numc
SVA_ORDERITEM, -- abap.char
TRA_ORDERTYPE, -- abap.char
SVA_ORDERTYPE, -- 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_PRODUCT, -- abap.char
SVA_PRODUCT, -- abap.char
SVH_PRODUCT, -- abap.char
HNM_PRODUCT, -- abap.char
HNO_PRODUCT, -- abap.char
HIO_PRODUCT, -- abap.char
TRA_SEGMENT, -- abap.char
SVA_SEGMENT, -- abap.char
SVH_SEGMENT, -- abap.char
HNM_SEGMENT, -- abap.char
HNO_SEGMENT, -- abap.char
HIO_SEGMENT, -- abap.char
TRA_WORKITEM, -- abap.char
SVA_WORKITEM, -- abap.char
TRA_COSTSOURCEUNIT, -- abap.unit
SVA_COSTSOURCEUNIT, -- abap.char
TRA_ORDEROPERATION, -- abap.char
SVA_ORDEROPERATION, -- abap.char
TRA_00018, -- abap.char
SVA_00018, -- abap.char
SVH_00018, -- abap.char
HNM_00018, -- abap.char
HNO_00018, -- abap.char
HIO_00018, -- abap.char
TRA_SHIPTOPARTY, -- abap.char
SVA_SHIPTOPARTY, -- abap.char
SVH_SHIPTOPARTY, -- abap.char
HNM_SHIPTOPARTY, -- abap.char
HNO_SHIPTOPARTY, -- abap.char
HIO_SHIPTOPARTY, -- abap.char
TRA_00019, -- abap.char
SVA_00019, -- abap.char
TRA_00020, -- abap.char
SVA_00020, -- abap.char
TRA_00021, -- abap.char
SVA_00021, -- abap.char
SVH_00021, -- abap.char
HNM_00021, -- abap.char
HNO_00021, -- abap.char
HIO_00021, -- abap.char
TRA_00022, -- abap.numc
SVA_00022, -- 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_00023, -- abap.numc
SVA_00023, -- abap.char
TRA_00024, -- abap.char
SVA_00024, -- 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_00025, -- abap.numc
SVA_00025, -- abap.char
TRA_00026, -- abap.numc
SVA_00026, -- abap.char
TRA_00027, -- abap.char
SVA_00027, -- abap.char
SVH_00027, -- abap.char
HNM_00027, -- abap.char
HNO_00027, -- abap.char
HIO_00027, -- abap.char
TRA_00028, -- abap.char
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_BUDGETPERIOD, -- abap.char
SVA_BUDGETPERIOD, -- abap.char
SVH_BUDGETPERIOD, -- abap.char
HNM_BUDGETPERIOD, -- abap.char
HNO_BUDGETPERIOD, -- abap.char
HIO_BUDGETPERIOD, -- abap.char
TRA_00030, -- abap.char
SVA_00030, -- abap.char
TRA_00031, -- abap.char
SVA_00031, -- abap.char
SVH_00031, -- abap.char
HNM_00031, -- abap.char
HNO_00031, -- abap.char
HIO_00031, -- abap.char
TRA_PARTNERSEGMENT, -- abap.char
SVA_PARTNERSEGMENT, -- abap.char
SVH_PARTNERSEGMENT, -- abap.char
HNM_PARTNERSEGMENT, -- abap.char
HNO_PARTNERSEGMENT, -- abap.char
HIO_PARTNERSEGMENT, -- abap.char
TRA_00032, -- abap.char
SVA_00032, -- abap.char
TRA_00033, -- abap.char
SVA_00033, -- abap.char
SVH_00033, -- abap.char
HNM_00033, -- abap.char
HNO_00033, -- abap.char
HIO_00033, -- abap.char
TRA_FUNCTIONALAREA, -- abap.char
SVA_FUNCTIONALAREA, -- abap.char
SVH_FUNCTIONALAREA, -- abap.char
HNM_FUNCTIONALAREA, -- abap.char
HNO_FUNCTIONALAREA, -- abap.char
HIO_FUNCTIONALAREA, -- abap.char
TRA_00034, -- abap.char
SVA_00034, -- abap.char
SVH_00034, -- abap.char
HNM_00034, -- abap.char
HNO_00034, -- abap.char
HIO_00034, -- abap.char
TRA_00035, -- abap.numc
SVA_00035, -- abap.char
TRA_00036, -- abap.char
SVA_00036, -- abap.char
TRA_PARTNERORDER, -- abap.char
SVA_PARTNERORDER, -- abap.char
TRA_00037, -- abap.cuky
SVA_00037, -- abap.char
TRA_00038, -- abap.numc
SVA_00038, -- abap.char
TRA_CUSTOMERGROUP, -- abap.char
SVA_CUSTOMERGROUP, -- abap.char
SVH_CUSTOMERGROUP, -- abap.char
HNM_CUSTOMERGROUP, -- abap.char
HNO_CUSTOMERGROUP, -- abap.char
HIO_CUSTOMERGROUP, -- abap.char
TRA_00039, -- abap.numc
SVA_00039, -- abap.char
TRA_FUNDHIERARCHY, -- abap.char
SVA_FUNDHIERARCHY, -- abap.char
SVH_FUNDHIERARCHY, -- abap.char
HNM_FUNDHIERARCHY, -- abap.char
HNO_FUNDHIERARCHY, -- abap.char
HIO_FUNDHIERARCHY, -- abap.char
TRA_00040, -- abap.char
SVA_00040, -- abap.char
SVH_00040, -- abap.char
HNM_00040, -- abap.char
HNO_00040, -- abap.char
HIO_00040, -- abap.char
TRA_00041, -- abap.char
SVA_00041, -- abap.char
TRA_00042, -- abap.char
SVA_00042, -- abap.char
TRA_BILLTOPARTY, -- abap.char
SVA_BILLTOPARTY, -- abap.char
SVH_BILLTOPARTY, -- abap.char
HNM_BILLTOPARTY, -- abap.char
HNO_BILLTOPARTY, -- abap.char
HIO_BILLTOPARTY, -- abap.char
TRA_00043, -- abap.char
SVA_00043, -- abap.char
TRA_00044, -- abap.char
SVA_00044, -- abap.char
TRA_00045, -- abap.char
SVA_00045, -- abap.char
TRA_00046, -- abap.char
SVA_00046, -- abap.char
TRA_00047, -- abap.char
SVA_00047, -- abap.char
SVH_00047, -- abap.char
HNM_00047, -- abap.char
HNO_00047, -- abap.char
HIO_00047, -- abap.char
TRA_SOLDPRODUCT, -- abap.char
SVA_SOLDPRODUCT, -- abap.char
SVH_SOLDPRODUCT, -- abap.char
HNM_SOLDPRODUCT, -- abap.char
HNO_SOLDPRODUCT, -- abap.char
HIO_SOLDPRODUCT, -- abap.char
TRA_00048, -- abap.char
SVA_00048, -- abap.char
TRA_BUSINESSAREA, -- abap.char
SVA_BUSINESSAREA, -- abap.char
SVH_BUSINESSAREA, -- abap.char
HNM_BUSINESSAREA, -- abap.char
HNO_BUSINESSAREA, -- abap.char
HIO_BUSINESSAREA, -- abap.char
TRA_00049, -- abap.char
SVA_00049, -- abap.char
TRA_00050, -- abap.char
SVA_00050, -- abap.char
TRA_00051, -- abap.char
SVA_00051, -- abap.char
TRA_00052, -- abap.char
SVA_00052, -- abap.char
SVH_00052, -- abap.char
HNM_00052, -- abap.char
HNO_00052, -- abap.char
HIO_00052, -- abap.char
TRA_00053, -- abap.numc
SVA_00053, -- abap.char
TRA_00054, -- abap.char
SVA_00054, -- abap.char
TRA_BUDGETINGTYPE, -- abap.char
SVA_BUDGETINGTYPE, -- abap.char
TRA_00055, -- abap.cuky
SVA_00055, -- abap.char
TRA_00056, -- abap.char
SVA_00056, -- abap.char
TRA_00057, -- abap.char
SVA_00057, -- abap.char
SVH_00057, -- abap.char
HNM_00057, -- abap.char
HNO_00057, -- abap.char
HIO_00057, -- abap.char
TRA_SPONSOREDCLASS, -- abap.char
SVA_SPONSOREDCLASS, -- abap.char
SVH_SPONSOREDCLASS, -- abap.char
HNM_SPONSOREDCLASS, -- abap.char
HNO_SPONSOREDCLASS, -- abap.char
HIO_SPONSOREDCLASS, -- abap.char
TRA_WORKPACKAGE, -- abap.char
SVA_WORKPACKAGE, -- abap.char
TRA_00058, -- abap.char
SVA_00058, -- abap.char
SVH_00058, -- abap.char
HNM_00058, -- abap.char
HNO_00058, -- abap.char
HIO_00058, -- abap.char
TRA_00059, -- abap.char
SVA_00059, -- abap.char
SVH_00059, -- abap.char
HNM_00059, -- abap.char
HNO_00059, -- abap.char
HIO_00059, -- abap.char
TRA_SALESDOCUMENT, -- abap.char
SVA_SALESDOCUMENT, -- abap.char
TRA_00060, -- abap.char
SVA_00060, -- abap.char
TRA_00061, -- abap.char
SVA_00061, -- abap.char
TRA_00062, -- abap.char
SVA_00062, -- abap.char
TRA_00063, -- abap.char
SVA_00063, -- abap.char
TRA_00064, -- abap.char
SVA_00064, -- abap.char
TRA_BUDGETPROCESS, -- abap.char
SVA_BUDGETPROCESS, -- abap.char
TRA_SALESORDERTYPE, -- abap.char
SVA_SALESORDERTYPE, -- 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_FISCALPERIOD, -- abap.numc
SVA_FISCALPERIOD, -- abap.char
SVH_FISCALPERIOD, -- abap.char
HNM_FISCALPERIOD, -- abap.char
HNO_FISCALPERIOD, -- abap.char
HIO_FISCALPERIOD, -- abap.char
TRA_00065, -- abap.char
SVA_00065, -- abap.char
TRA_00066, -- abap.numc
SVA_00066, -- 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
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA