I_PUBSECBDGTLINEITEMBASIC
Budget Line Items Basic
I_PUBSECBDGTLINEITEMBASIC is a CDS View in S/4HANA. Budget Line Items Basic. It contains 180 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_PubSecBdgtLineItemCube | view | from | COMPOSITE | Budget Line Items - Cube |
Fields (180)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | FinancialPlanningDataPacket | FinancialPlanningDataPacket | 1 |
| KEY | FinancialPlanningEntryItem | FinancialPlanningEntryItem | 1 |
| KEY | FinancialPlanningReqTransSqnc | FinancialPlanningReqTransSqnc | 1 |
| _BillingDocumentType | _BillingDocumentType | 1 | |
| _BillToParty | _BillToParty | 1 | |
| _BudgetingType | _BudgetingType | 1 | |
| _BudgetPeriod | _BudgetPeriod | 1 | |
| _BudgetProcess | _BudgetProcess | 1 | |
| _BusinessArea | _BusinessArea | 1 | |
| _BusinessTransactionType | _BusinessTransactionType | 1 | |
| _CalendarDate | _CalendarDate | 1 | |
| _ChartOfAccounts | _ChartOfAccounts | 1 | |
| _CompanyCode | _CompanyCode | 1 | |
| _CompanyCodeCurrency | _CompanyCodeCurrency | 1 | |
| _ControllingArea | _ControllingArea | 1 | |
| _ControllingDebitCreditCode | _ControllingDebitCreditCode | 1 | |
| _ControllingObjectCurrency | _ControllingObjectCurrency | 1 | |
| _CostAnalysisResource | _CostAnalysisResource | 1 | |
| _CostCenter | _CostCenter | 1 | |
| _CostCtrActivityType | _CostCtrActivityType | 1 | |
| _CostSourceUnit | _CostSourceUnit | 1 | |
| _CurrentCostCenter | _CurrentCostCenter | 1 | |
| _CurrentProfitCenter | _CurrentProfitCenter | 1 | |
| _Customer | _Customer | 1 | |
| _CustomerGroup | _CustomerGroup | 1 | |
| _CustomerSupplierCountry | _CustomerSupplierCountry | 1 | |
| _CustomerSupplierIndustryText | _CustomerSupplierIndustryText | 1 | |
| _DistributionChannel | _DistributionChannel | 1 | |
| _Employment | _Employment | 1 | |
| _FinancialManagementArea | _FinancialManagementArea | 1 | |
| _FinancialTransactionType | _FinancialTransactionType | 1 | |
| _FiscalCalendarDate | _FiscalCalendarDate | 1 | |
| _FiscalPeriodForVariant | _FiscalPeriodForVariant | 1 | |
| _FiscalYear | _FiscalYear | 1 | |
| _FiscalYearPeriodForVariant | _FiscalYearPeriodForVariant | 1 | |
| _FiscalYearVariant | _FiscalYearVariant | 1 | |
| _FixedAsset | _FixedAsset | 1 | |
| _FunctionalArea | _FunctionalArea | 1 | |
| _Fund | _Fund | 1 | |
| _GLAccountInChartOfAccounts | _GLAccountInChartOfAccounts | 1 | |
| _GLAccountInCompanyCode | _GLAccountInCompanyCode | 1 | |
| _GlobalCurrency | _GlobalCurrency | 1 | |
| _Grant | _Grant | 1 | |
| _InternalOrder | _InternalOrder | 1 | |
| _Ledger | _Ledger | 1 | |
| _LedgerFiscalYear | _LedgerFiscalYear | 1 | |
| _LedgerFiscalYearForVariant | _LedgerFiscalYearForVariant | 1 | |
| _MasterFixedAsset | _MasterFixedAsset | 1 | |
| _Order | _Order | 1 | |
| _OrganizationDivision | _OrganizationDivision | 1 | |
| _PartnerBusinessArea | _PartnerBusinessArea | 1 | |
| _PartnerCompany | _PartnerCompany | 1 | |
| _PartnerCompanyCode | _PartnerCompanyCode | 1 | |
| _PartnerCostCenter | _PartnerCostCenter | 1 | |
| _PartnerCostCtrActivityType | _PartnerCostCtrActivityType | 1 | |
| _PartnerFunctionalArea | _PartnerFunctionalArea | 1 | |
| _PartnerOrder | _PartnerOrder | 1 | |
| _PartnerOrder_2 | _PartnerOrder_2 | 1 | |
| _PartnerProfitCenter | _PartnerProfitCenter | 1 | |
| _PartnerProjectBasicData | _PartnerProjectBasicData | 1 | |
| _PartnerSegment | _PartnerSegment | 1 | |
| _PartnerWBSElementBasicData | _PartnerWBSElementBasicData | 1 | |
| _PlanningCategory | _PlanningCategory | 1 | |
| _Plant | _Plant | 1 | |
| _Product | _Product | 1 | |
| _ProfitCenter | _ProfitCenter | 1 | |
| _ProjectBasicData | _ProjectBasicData | 1 | |
| _SalesDistrict | _SalesDistrict | 1 | |
| _SalesDocument | _SalesDocument | 1 | |
| _SalesDocumentItem | _SalesDocumentItem | 1 | |
| _SalesOrganization | _SalesOrganization | 1 | |
| _Segment | _Segment | 1 | |
| _SemTagGLAccount | _SemTagGLAccount | 1 | |
| _ShipToParty | _ShipToParty | 1 | |
| _SoldProduct | _SoldProduct | 1 | |
| _SponsoredClass | _SponsoredClass | 1 | |
| _SponsoredProgram | _SponsoredProgram | 1 | |
| _TransactionCurrency | _TransactionCurrency | 1 | |
| _WBSElementBasicData | _WBSElementBasicData | 1 | |
| _WorkPackage | _WorkPackage | 1 | |
| _WorkPackageWorkItem | _WorkPackageWorkItem | 1 | |
| AccountAssignmentType | AccountAssignmentType | 1 | |
| AmountInCompanyCodeCurrency | AmountInCompanyCodeCurrency | 1 | |
| AmountInGlobalCurrency | AmountInGlobalCurrency | 1 | |
| AmountInObjectCurrency | AmountInObjectCurrency | 1 | |
| AmountInTransactionCurrency | AmountInTransactionCurrency | 1 | |
| AssetAcctTransClassfctn | AssetAcctTransClassfctn | 1 | |
| AssetClass | AssetClass | 1 | |
| AssetDepreciationArea | AssetDepreciationArea | 1 | |
| BillingDocumentType | BillingDocumentType | 1 | |
| BillToParty | BillToParty | 1 | |
| BudgetDocWorkFlowStatus | BudgetDocWorkFlowStatus | 1 | |
| BudgetingType | BudgetingType | 1 | |
| BudgetPeriod | BudgetPeriod | 1 | |
| BudgetProcess | BudgetProcess | 1 | |
| BusinessArea | BusinessArea | 1 | |
| BusinessTransactionType | BusinessTransactionType | 1 | |
| ChartOfAccounts | ChartOfAccounts | 1 | |
| CompanyCode | CompanyCode | 1 | |
| CompanyCodeCurrency | CompanyCodeCurrency | 1 | |
| ControllingArea | ControllingArea | 1 | |
| ControllingDebitCreditCode | ControllingDebitCreditCode | 1 | |
| ControllingObjectCurrency | ControllingObjectCurrency | 1 | |
| CostAnalysisResource | CostAnalysisResource | 1 | |
| CostCenter | CostCenter | 1 | |
| CostCtrActivityType | CostCtrActivityType | 1 | |
| CostSourceUnit | CostSourceUnit | 1 | |
| Customer | Customer | 1 | |
| CustomerBasicAuthorizationGrp | CustomerBasicAuthorizationGrp | 1 | |
| CustomerGroup | CustomerGroup | 1 | |
| CustomerSupplierCorporateGroup | CustomerSupplierCorporateGroup | 1 | |
| CustomerSupplierCountry | CustomerSupplierCountry | 1 | |
| CustomerSupplierIndustry | CustomerSupplierIndustry | 1 | |
| DistributionChannel | DistributionChannel | 1 | |
| FinancialManagementArea | FinancialManagementArea | 1 | |
| FinancialTransactionType | FinancialTransactionType | 1 | |
| FiscalPeriod | FiscalPeriod | 1 | |
| FiscalYear | FiscalYear | 1 | |
| FiscalYearPeriod | FiscalYearPeriod | 1 | |
| FiscalYearVariant | FiscalYearVariant | 1 | |
| FixedAmountInGlobalCrcy | FixedAmountInGlobalCrcy | 1 | |
| FixedAsset | FixedAsset | 1 | |
| FunctionalArea | FunctionalArea | 1 | |
| Fund | Fund | 1 | |
| GLAccount | GLAccount | 1 | |
| GLAccountAuthorizationGroup | GLAccountAuthorizationGroup | 1 | |
| GlobalCurrency | GlobalCurrency | 1 | |
| GrantID | GrantID | 1 | |
| GteeMBudgetValidityNumber | GteeMBudgetValidityNumber | 1 | |
| IsLotSizeIndependent | IsLotSizeIndependent | 1 | |
| Ledger | Ledger | 1 | |
| LedgerFiscalYear | LedgerFiscalYear | 1 | |
| MasterFixedAsset | MasterFixedAsset | 1 | |
| OrderID | OrderID | 1 | |
| OrderItem | OrderItem | 1 | |
| OrderOperation | OrderOperation | 1 | |
| OrderType | OrderType | 1 | |
| OrganizationDivision | OrganizationDivision | 1 | |
| PartnerAccountAssignmentType | PartnerAccountAssignmentType | 1 | |
| PartnerBusinessArea | PartnerBusinessArea | 1 | |
| PartnerCompany | PartnerCompany | 1 | |
| PartnerCompanyCode | PartnerCompanyCode | 1 | |
| PartnerCostCenter | PartnerCostCenter | 1 | |
| PartnerCostCtrActivityType | PartnerCostCtrActivityType | 1 | |
| PartnerFunctionalArea | PartnerFunctionalArea | 1 | |
| PartnerProfitCenter | PartnerProfitCenter | 1 | |
| PartnerProjectInternalID | PartnerProjectInternalID | 1 | |
| PartnerSegment | PartnerSegment | 1 | |
| PartnerWBSElementInternalID | PartnerWBSElementInternalID | 1 | |
| PersonnelNumber | PersonnelNumber | 1 | |
| PlanningCategory | PlanningCategory | 1 | |
| PlanPriceInCompanyCodeCurrency | PlanPriceInCompanyCodeCurrency | 1 | |
| PlanPriceInGlobalCurrency | PlanPriceInGlobalCurrency | 1 | |
| PlanPriceInTransactionCurrency | PlanPriceInTransactionCurrency | 1 | |
| Plant | Plant | 1 | |
| PostingDate | PostingDate | 1 | |
| Product | Product | 1 | |
| ProfitCenter | ProfitCenter | 1 | |
| ProjectInternalID | ProjectInternalID | 1 | |
| PubSecBudgetAccount | PubSecBudgetAccount | 1 | |
| PubSecBudgetAccountCoCode | PubSecBudgetAccountCoCode | 1 | |
| PubSecIsConsumableBudget | PubSecIsConsumableBudget | 1 | |
| ReferenceDocument | ReferenceDocument | 1 | |
| ReferenceDocumentContext | ReferenceDocumentContext | 1 | |
| ReferenceDocumentType | ReferenceDocumentType | 1 | |
| SalesDistrict | SalesDistrict | 1 | |
| SalesDocument | SalesDocument | 1 | |
| SalesDocumentItem | SalesDocumentItem | 1 | |
| SalesOrderType | SalesOrderType | 1 | |
| SalesOrganization | SalesOrganization | 1 | |
| Segment | Segment | 1 | |
| ShipToParty | ShipToParty | 1 | |
| SoldProduct | SoldProduct | 1 | |
| SponsoredClass | SponsoredClass | 1 | |
| SponsoredProgram | SponsoredProgram | 1 | |
| TransactionCurrency | TransactionCurrency | 1 | |
| ValuationQuantity | ValuationQuantity | 1 | |
| WorkCenterInternalID | WorkCenterInternalID | 1 | |
| WorkItem | WorkItem | 1 | |
| WorkPackage | WorkPackage | 1 |
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.
-- Budget Line Items Basic
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PUBSECBDGTLINEITEMBASIC (
FINANCIALPLANNINGDATAPACKET,
FINANCIALPLANNINGENTRYITEM,
FINANCIALPLANNINGREQTRANSSQNC,
_BILLINGDOCUMENTTYPE,
_BILLTOPARTY,
_BUDGETINGTYPE,
_BUDGETPERIOD,
_BUDGETPROCESS,
_BUSINESSAREA,
_BUSINESSTRANSACTIONTYPE,
_CALENDARDATE,
_CHARTOFACCOUNTS,
_COMPANYCODE,
_COMPANYCODECURRENCY,
_CONTROLLINGAREA,
_CONTROLLINGDEBITCREDITCODE,
_CONTROLLINGOBJECTCURRENCY,
_COSTANALYSISRESOURCE,
_COSTCENTER,
_COSTCTRACTIVITYTYPE,
_COSTSOURCEUNIT,
_CURRENTCOSTCENTER,
_CURRENTPROFITCENTER,
_CUSTOMER,
_CUSTOMERGROUP,
_CUSTOMERSUPPLIERCOUNTRY,
_CUSTOMERSUPPLIERINDUSTRYTEXT,
_DISTRIBUTIONCHANNEL,
_EMPLOYMENT,
_FINANCIALMANAGEMENTAREA,
_FINANCIALTRANSACTIONTYPE,
_FISCALCALENDARDATE,
_FISCALPERIODFORVARIANT,
_FISCALYEAR,
_FISCALYEARPERIODFORVARIANT,
_FISCALYEARVARIANT,
_FIXEDASSET,
_FUNCTIONALAREA,
_FUND,
_GLACCOUNTINCHARTOFACCOUNTS,
_GLACCOUNTINCOMPANYCODE,
_GLOBALCURRENCY,
_GRANT,
_INTERNALORDER,
_LEDGER,
_LEDGERFISCALYEAR,
_LEDGERFISCALYEARFORVARIANT,
_MASTERFIXEDASSET,
_ORDER,
_ORGANIZATIONDIVISION,
_PARTNERBUSINESSAREA,
_PARTNERCOMPANY,
_PARTNERCOMPANYCODE,
_PARTNERCOSTCENTER,
_PARTNERCOSTCTRACTIVITYTYPE,
_PARTNERFUNCTIONALAREA,
_PARTNERORDER,
_PARTNERORDER_2,
_PARTNERPROFITCENTER,
_PARTNERPROJECTBASICDATA,
_PARTNERSEGMENT,
_PARTNERWBSELEMENTBASICDATA,
_PLANNINGCATEGORY,
_PLANT,
_PRODUCT,
_PROFITCENTER,
_PROJECTBASICDATA,
_SALESDISTRICT,
_SALESDOCUMENT,
_SALESDOCUMENTITEM,
_SALESORGANIZATION,
_SEGMENT,
_SEMTAGGLACCOUNT,
_SHIPTOPARTY,
_SOLDPRODUCT,
_SPONSOREDCLASS,
_SPONSOREDPROGRAM,
_TRANSACTIONCURRENCY,
_WBSELEMENTBASICDATA,
_WORKPACKAGE,
_WORKPACKAGEWORKITEM,
ACCOUNTASSIGNMENTTYPE,
AMOUNTINCOMPANYCODECURRENCY,
AMOUNTINGLOBALCURRENCY,
AMOUNTINOBJECTCURRENCY,
AMOUNTINTRANSACTIONCURRENCY,
ASSETACCTTRANSCLASSFCTN,
ASSETCLASS,
ASSETDEPRECIATIONAREA,
BILLINGDOCUMENTTYPE,
BILLTOPARTY,
BUDGETDOCWORKFLOWSTATUS,
BUDGETINGTYPE,
BUDGETPERIOD,
BUDGETPROCESS,
BUSINESSAREA,
BUSINESSTRANSACTIONTYPE,
CHARTOFACCOUNTS,
COMPANYCODE,
COMPANYCODECURRENCY,
CONTROLLINGAREA,
CONTROLLINGDEBITCREDITCODE,
CONTROLLINGOBJECTCURRENCY,
COSTANALYSISRESOURCE,
COSTCENTER,
COSTCTRACTIVITYTYPE,
COSTSOURCEUNIT,
CUSTOMER,
CUSTOMERBASICAUTHORIZATIONGRP,
CUSTOMERGROUP,
CUSTOMERSUPPLIERCORPORATEGROUP,
CUSTOMERSUPPLIERCOUNTRY,
CUSTOMERSUPPLIERINDUSTRY,
DISTRIBUTIONCHANNEL,
FINANCIALMANAGEMENTAREA,
FINANCIALTRANSACTIONTYPE,
FISCALPERIOD,
FISCALYEAR,
FISCALYEARPERIOD,
FISCALYEARVARIANT,
FIXEDAMOUNTINGLOBALCRCY,
FIXEDASSET,
FUNCTIONALAREA,
FUND,
GLACCOUNT,
GLACCOUNTAUTHORIZATIONGROUP,
GLOBALCURRENCY,
GRANTID,
GTEEMBUDGETVALIDITYNUMBER,
ISLOTSIZEINDEPENDENT,
LEDGER,
LEDGERFISCALYEAR,
MASTERFIXEDASSET,
ORDERID,
ORDERITEM,
ORDEROPERATION,
ORDERTYPE,
ORGANIZATIONDIVISION,
PARTNERACCOUNTASSIGNMENTTYPE,
PARTNERBUSINESSAREA,
PARTNERCOMPANY,
PARTNERCOMPANYCODE,
PARTNERCOSTCENTER,
PARTNERCOSTCTRACTIVITYTYPE,
PARTNERFUNCTIONALAREA,
PARTNERPROFITCENTER,
PARTNERPROJECTINTERNALID,
PARTNERSEGMENT,
PARTNERWBSELEMENTINTERNALID,
PERSONNELNUMBER,
PLANNINGCATEGORY,
PLANPRICEINCOMPANYCODECURRENCY,
PLANPRICEINGLOBALCURRENCY,
PLANPRICEINTRANSACTIONCURRENCY,
PLANT,
POSTINGDATE,
PRODUCT,
PROFITCENTER,
PROJECTINTERNALID,
PUBSECBUDGETACCOUNT,
PUBSECBUDGETACCOUNTCOCODE,
PUBSECISCONSUMABLEBUDGET,
REFERENCEDOCUMENT,
REFERENCEDOCUMENTCONTEXT,
REFERENCEDOCUMENTTYPE,
SALESDISTRICT,
SALESDOCUMENT,
SALESDOCUMENTITEM,
SALESORDERTYPE,
SALESORGANIZATION,
SEGMENT,
SHIPTOPARTY,
SOLDPRODUCT,
SPONSOREDCLASS,
SPONSOREDPROGRAM,
TRANSACTIONCURRENCY,
VALUATIONQUANTITY,
WORKCENTERINTERNALID,
WORKITEM,
WORKPACKAGE,
PRIMARY KEY (FINANCIALPLANNINGDATAPACKET, FINANCIALPLANNINGENTRYITEM, FINANCIALPLANNINGREQTRANSSQNC)
);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