I_PubSecBdgtLineItemBasic

Budget Line Items Basic | view: IPSMS4BDLNBSC | Extraction: Not supported | Component: Information system
Tables used: ACDOCP, T001, TKA02, SKB1, T001, FCOMC_CATEGORY, PSM_D_GLACCTX, FINSC_FISC_DATE, FINSC_PERIOD
Column Name Description
FinancialPlanningReqTransSqnc Financial Planning Request Transaction Sequence Number
FinancialPlanningDataPacket Financial Planning Data Packet Number
FinancialPlanningEntryItem Financial Planning Entry Item
Column Name Description
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
PlanPriceInTransactionCurrency Price in Transaction Currency
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
PlanPriceInCompanyCodeCurrency Price in Company Code Currency
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
FixedAmountInGlobalCrcy Fixed Amount in Global Currency
PlanPriceInGlobalCurrency Price in Global Currency
💲 CO Object Currency (ControllingObjectCurrency):
AmountInObjectCurrency Amount in CO Object Currency
Column Name Description
📏 Unit of Measure (CostSourceUnit):
ValuationQuantity Valuation quantity
Column Name Description
PostingDate Posting Date
Column Name Description
IsLotSizeIndependent Is Lot Size Independent Show values
ControllingDebitCreditCode CO Debit/Credit Indicator Show values
Column Name Description Domain name
FiscalYear Fiscal Year GJAHR
LedgerFiscalYear Ledger Fiscal Year GJAHR
WBSElementInternalID WBS Element Internal ID FIS_WBSINT_NO_CONV
PartnerWBSElementInternalID Partner WBS Element Internal ID FIS_WBSINT_NO_CONV
WorkPackage Plan Item /CPD/PLAN_ITEM_ID
WorkItem Work Item ID /CPD/PFP_WORKITEM_ID
ReferenceDocumentType Reference Document Type AWTYP
ReferenceDocumentContext Reference Document Context AWORG
ReferenceDocument Reference document number AWREF
FiscalYearVariant Fiscal Year Variant PERIV
FiscalPeriod Fiscal Period POPER
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
SalesDocument Sales Document VBELN
SalesDocumentItem Sales Document Item POSNR
PersonnelNumber Personnel Number PERNR
CustomerSupplierCorporateGroup Corporate Group of Customer or Supplier KONZS
PubSecBudgetAccount Budget Account SAKNR
PubSecBudgetAccountCoCode Budget Account Company Code BUKRS
OrderOperation Operation/Activity Number VORNR
OrderItem Order item number CO_POSNR
GLAccountAuthorizationGroup Authorization Group BRGRU
CustomerBasicAuthorizationGrp Authorization Group BRGRU
OrderType Order Type AUFART
SalesOrderType Sales Document Type AUART
Master Data Relations Join Conditions
Transaction Type Category I_PUBSECBDGTLINEITEMBASIC.ASSETACCTTRANSCLASSFCTN == FAAI_MOVCAT.MOVCAT
Billing Type
  • Billing Type
  • Client
  • I_PUBSECBDGTLINEITEMBASIC.BILLINGDOCUMENTTYPE == TVFK.FKART
  • I_PUBSECBDGTLINEITEMBASIC.MANDT == TVFK.MANDT
Bill-to Party
  • Bill-to Party
  • Client
  • I_PUBSECBDGTLINEITEMBASIC.BILLTOPARTY == KNA1.KUNNR
  • I_PUBSECBDGTLINEITEMBASIC.MANDT == KNA1.MANDT
Budget Type (Subcategory)
  • Budget Type (Subcategory)
  • Client
Budget Period
  • Client
  • Budget Period
  • I_PUBSECBDGTLINEITEMBASIC.MANDT == FMBUDGETPD.MANDT
  • I_PUBSECBDGTLINEITEMBASIC.BUDGETPERIOD == FMBUDGETPD.BUDGET_PD
Budget Process Type
  • Client
  • Budget Process Type
Business Area
  • Business Area
  • Client
  • I_PUBSECBDGTLINEITEMBASIC.BUSINESSAREA == TGSB.GSBER
  • I_PUBSECBDGTLINEITEMBASIC.MANDT == TGSB.MANDT
Business Transaction Category
  • Business Transaction Category
  • Client
  • I_PUBSECBDGTLINEITEMBASIC.BUSINESSTRANSACTIONTYPE == FINSC_BTTYPE.BTTYPE
  • I_PUBSECBDGTLINEITEMBASIC.MANDT == FINSC_BTTYPE.MANDT
Chart of Accounts
  • Client
  • Chart of Accounts
  • I_PUBSECBDGTLINEITEMBASIC.MANDT == T004.MANDT
  • I_PUBSECBDGTLINEITEMBASIC.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Client
  • Company Code
  • I_PUBSECBDGTLINEITEMBASIC.MANDT == T001.MANDT
  • I_PUBSECBDGTLINEITEMBASIC.COMPANYCODE == T001.BUKRS
Controlling Area
  • Controlling Area
  • Client
  • I_PUBSECBDGTLINEITEMBASIC.CONTROLLINGAREA == TKA01.KOKRS
  • I_PUBSECBDGTLINEITEMBASIC.MANDT == TKA01.MANDT
Cost Center
  • Controlling Area
  • ?
  • Client
  • Cost Center
  • I_PUBSECBDGTLINEITEMBASIC.CONTROLLINGAREA == CSKS.KOKRS
  • I_PUBSECBDGTLINEITEMBASIC.[column in domain "DATBI"] == CSKS.DATBI
  • I_PUBSECBDGTLINEITEMBASIC.MANDT == CSKS.MANDT
  • I_PUBSECBDGTLINEITEMBASIC.COSTCENTER == CSKS.KOSTL
Customer Number
  • Customer Number
  • Client
  • I_PUBSECBDGTLINEITEMBASIC.CUSTOMER == KNA1.KUNNR
  • I_PUBSECBDGTLINEITEMBASIC.MANDT == KNA1.MANDT
Customer Group
  • Client
  • Customer Group
  • I_PUBSECBDGTLINEITEMBASIC.MANDT == T151.MANDT
  • I_PUBSECBDGTLINEITEMBASIC.CUSTOMERGROUP == T151.KDGRP
Country/Region of Customer or Supplier
  • Country/Region of Customer or Supplier
  • Client
  • I_PUBSECBDGTLINEITEMBASIC.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1
  • I_PUBSECBDGTLINEITEMBASIC.MANDT == T005.MANDT
Industry Key
  • Client
  • Industry Key
  • I_PUBSECBDGTLINEITEMBASIC.MANDT == T016.MANDT
  • I_PUBSECBDGTLINEITEMBASIC.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH
Distribution Channel
  • Distribution Channel
  • Client
  • I_PUBSECBDGTLINEITEMBASIC.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • I_PUBSECBDGTLINEITEMBASIC.MANDT == TVTW.MANDT
Financial Management Area
  • Financial Management Area
  • Client
  • I_PUBSECBDGTLINEITEMBASIC.FINANCIALMANAGEMENTAREA == FM01.FIKRS
  • I_PUBSECBDGTLINEITEMBASIC.MANDT == FM01.MANDT
Transaction type
  • Client
  • Transaction type
  • I_PUBSECBDGTLINEITEMBASIC.MANDT == T856.MANDT
  • I_PUBSECBDGTLINEITEMBASIC.FINANCIALTRANSACTIONTYPE == T856.TRTYP
Functional Area
  • Client
  • Functional Area
  • I_PUBSECBDGTLINEITEMBASIC.MANDT == TFKB.MANDT
  • I_PUBSECBDGTLINEITEMBASIC.FUNCTIONALAREA == TFKB.FKBER
Fund
  • Financial Management Area
  • Fund
  • Client
  • I_PUBSECBDGTLINEITEMBASIC.FINANCIALMANAGEMENTAREA == FMFINCODE.FIKRS
  • I_PUBSECBDGTLINEITEMBASIC.FUND == FMFINCODE.FINCODE
  • I_PUBSECBDGTLINEITEMBASIC.MANDT == FMFINCODE.MANDT
G/L Account
  • Client
  • Chart of Accounts
  • G/L Account
  • I_PUBSECBDGTLINEITEMBASIC.MANDT == SKA1.MANDT
  • I_PUBSECBDGTLINEITEMBASIC.CHARTOFACCOUNTS == SKA1.KTOPL
  • I_PUBSECBDGTLINEITEMBASIC.GLACCOUNT == SKA1.SAKNR
Grant
  • Client
  • Grant
  • I_PUBSECBDGTLINEITEMBASIC.MANDT == GMGR.CLIENT
  • I_PUBSECBDGTLINEITEMBASIC.GRANTID == GMGR.GRANT_NBR
Budget Validity Number
  • ?
  • ?
  • Client
  • Grant
  • Budget Validity Number
  • I_PUBSECBDGTLINEITEMBASIC.[column in domain "GM_BDGT_STATUS"] == GMBDGTVALIDITY.RELEASE_STATUS
  • I_PUBSECBDGTLINEITEMBASIC.[column in domain "GM_BDGT_PHASE"] == GMBDGTVALIDITY.BDGT_PHASE
  • I_PUBSECBDGTLINEITEMBASIC.MANDT == GMBDGTVALIDITY.CLIENT
  • I_PUBSECBDGTLINEITEMBASIC.GRANTID == GMBDGTVALIDITY.GRANT_NBR
  • I_PUBSECBDGTLINEITEMBASIC.GTEEMBUDGETVALIDITYNUMBER == GMBDGTVALIDITY.BDGT_VLDTY_NBR
Ledger
  • Ledger
  • Client
Organization Division
  • Organization Division
  • Client
  • I_PUBSECBDGTLINEITEMBASIC.ORGANIZATIONDIVISION == TSPA.SPART
  • I_PUBSECBDGTLINEITEMBASIC.MANDT == TSPA.MANDT
Partner Business Area
  • Client
  • Partner Business Area
  • I_PUBSECBDGTLINEITEMBASIC.MANDT == TGSB.MANDT
  • I_PUBSECBDGTLINEITEMBASIC.PARTNERBUSINESSAREA == TGSB.GSBER
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • I_PUBSECBDGTLINEITEMBASIC.PARTNERCOMPANY == T880.RCOMP
  • I_PUBSECBDGTLINEITEMBASIC.MANDT == T880.MANDT
Partner Cost Center
  • Controlling Area
  • ?
  • Client
  • Partner Cost Center
  • I_PUBSECBDGTLINEITEMBASIC.CONTROLLINGAREA == CSKS.KOKRS
  • I_PUBSECBDGTLINEITEMBASIC.[column in domain "DATBI"] == CSKS.DATBI
  • I_PUBSECBDGTLINEITEMBASIC.MANDT == CSKS.MANDT
  • I_PUBSECBDGTLINEITEMBASIC.PARTNERCOSTCENTER == CSKS.KOSTL
Partner Functional Area
  • Client
  • Partner Functional Area
  • I_PUBSECBDGTLINEITEMBASIC.MANDT == TFKB.MANDT
  • I_PUBSECBDGTLINEITEMBASIC.PARTNERFUNCTIONALAREA == TFKB.FKBER
Partner Profit Center
  • Controlling Area
  • ?
  • Client
  • Partner Profit Center
  • I_PUBSECBDGTLINEITEMBASIC.CONTROLLINGAREA == CEPC.KOKRS
  • I_PUBSECBDGTLINEITEMBASIC.[column in domain "DATBI"] == CEPC.DATBI
  • I_PUBSECBDGTLINEITEMBASIC.MANDT == CEPC.MANDT
  • I_PUBSECBDGTLINEITEMBASIC.PARTNERPROFITCENTER == CEPC.PRCTR
Partner Segment for Segmental Reporting
  • Client
  • Partner Segment for Segmental Reporting
  • I_PUBSECBDGTLINEITEMBASIC.MANDT == FAGL_SEGM.MANDT
  • I_PUBSECBDGTLINEITEMBASIC.PARTNERSEGMENT == FAGL_SEGM.SEGMENT
Plan Category
  • Plan Category
  • Client
Plant
  • Client
  • Plant
  • I_PUBSECBDGTLINEITEMBASIC.MANDT == T001W.MANDT
  • I_PUBSECBDGTLINEITEMBASIC.PLANT == T001W.WERKS
Product Number
  • Product Number
  • Client
  • I_PUBSECBDGTLINEITEMBASIC.PRODUCT == MARA.MATNR
  • I_PUBSECBDGTLINEITEMBASIC.MANDT == MARA.MANDT
Profit Center
  • Controlling Area
  • ?
  • Profit Center
  • Client
  • I_PUBSECBDGTLINEITEMBASIC.CONTROLLINGAREA == CEPC.KOKRS
  • I_PUBSECBDGTLINEITEMBASIC.[column in domain "DATBI"] == CEPC.DATBI
  • I_PUBSECBDGTLINEITEMBASIC.PROFITCENTER == CEPC.PRCTR
  • I_PUBSECBDGTLINEITEMBASIC.MANDT == CEPC.MANDT
Sales District
  • Client
  • Sales District
  • I_PUBSECBDGTLINEITEMBASIC.MANDT == T171.MANDT
  • I_PUBSECBDGTLINEITEMBASIC.SALESDISTRICT == T171.BZIRK
Sales Organization
  • Client
  • Sales Organization
  • I_PUBSECBDGTLINEITEMBASIC.MANDT == TVKO.MANDT
  • I_PUBSECBDGTLINEITEMBASIC.SALESORGANIZATION == TVKO.VKORG
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • I_PUBSECBDGTLINEITEMBASIC.MANDT == FAGL_SEGM.MANDT
  • I_PUBSECBDGTLINEITEMBASIC.SEGMENT == FAGL_SEGM.SEGMENT
Ship-to Party
  • Ship-to Party
  • Client
  • I_PUBSECBDGTLINEITEMBASIC.SHIPTOPARTY == KNA1.KUNNR
  • I_PUBSECBDGTLINEITEMBASIC.MANDT == KNA1.MANDT
Product Sold
  • Client
  • Product Sold
  • I_PUBSECBDGTLINEITEMBASIC.MANDT == MARA.MANDT
  • I_PUBSECBDGTLINEITEMBASIC.SOLDPRODUCT == MARA.MATNR
Sponsored Class
  • Client
  • Sponsored Class
  • I_PUBSECBDGTLINEITEMBASIC.MANDT == GMSPCLASS.CLIENT
  • I_PUBSECBDGTLINEITEMBASIC.SPONSOREDCLASS == GMSPCLASS.SPONSORED_CLASS
Sponsored Program
  • Client
  • Sponsored Program
  • I_PUBSECBDGTLINEITEMBASIC.MANDT == GMSPPROGRAM.CLIENT
  • I_PUBSECBDGTLINEITEMBASIC.SPONSOREDPROGRAM == GMSPPROGRAM.SPONSORED_PROG
Object ID of the resource
  • ?
  • Object ID of the resource
  • Client
  • I_PUBSECBDGTLINEITEMBASIC.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • I_PUBSECBDGTLINEITEMBASIC.WORKCENTERINTERNALID == CRID.OBJID
  • I_PUBSECBDGTLINEITEMBASIC.MANDT == CRID.MANDT