I_PubSecBdgtActlItemBasic

Budget Cmtmt and Actual Items Basic | view: IPSMS4CBDACTBSC | Extraction: Not supported | Component: Information system

Tables used: SCAL_TT_DATE, AFKO, PRTE, ACDOCA, ACDOCP, T001, TKA02, SKB1, AUFK, PROJ, PSM_D_BDGTCNSTY, T001, FCOMC_CATEGORY, PRPS, PRPS, PSM_D_GLACCTX, FINSC_LEDGER_REP, FINSC_FISC_DATE, FINSC_PERIOD

🔑 Keys (8)
💰 Amounts (15)
∑ Quantities (4)
📅 Dates (3)
☰ Categorical (10)
Other (43)
🔗 Relations (71)

Column Name	Description
SourceLedger FK	Source Ledger
Ledger FK	Ledger in General Ledger Accounting
CompanyCode FK	Company Code
FiscalYear	Fiscal Year
AccountingDocument	Journal Entry
FinancialPlanningReqTransSqnc	Financial Planning Request Transaction Sequence Number
FinancialPlanningDataPacket	Financial Planning Data Packet Number
ActualPlanJournalEntryItem	Actual Plan Journal Entry Item

Column Name	Description
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency	Amount in Transaction Currency
ActualAmountInTransactionCrcy	Actual Amount in Transaction Currency
PlanAmountInTransactionCrcy	Plan Amount in Transaction Currency
PlanPriceInTransactionCurrency	Price in Transaction Currency
ActlPlnDiffAmtInTransCrcy	Actual plan difference in transaction currency
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency	Amount in Company Code Currency
ActualAmountInCompanyCodeCrcy	Actual Amount in Company Code Currency
PlanAmountInCompanyCodeCrcy	Plan Amount in Company Code Currency
PlanPriceInCompanyCodeCurrency	Price in Company Code Currency
ActlPlnDiffAmtInCoCodeCrcy	Actual plan difference in company code currency
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency	Amount in Global Currency
ActualAmountInGlobalCurrency	Actual Amount in Global Currency
PlanAmountInGlobalCurrency	Plan Amount in Global Currency
PlanPriceInGlobalCurrency	Price in Global Currency
ActlPlnDiffAmtInGlobalCrcy	Actual plan difference in global currency

Column Name	Description
📏 Cost Source Unit (CostSourceUnit):
ValuationQuantity	Valuation quantity
ActualValuationQuantity	Actual Valuation Quantity
PlanValuationQuantity	Plan Valuation Quantity
ActlPanDiffValuationQuantity	Actual Plan Difference Valuation Quantity

Column Name	Description
PostingDate	Posting Date
ServicesRenderedDate	Date on which services are rendered
PubSecBudgetCnsmpnDate	Budget Consumption Date

Column Name	Description
ActualPlanCode	Actual Plan Code	Show values
FinancialAccountType	Account Type	Show values
ControllingDebitCreditCode	Controlling Debit Credit Code	Show values
IsStatisticalOrder	Indicator: Internal Order is Statistical Account Assignment	Show values
IsStatisticalCostCenter	Indicator: Cost Center is Statistical Account Assignment	Show values
IsStatisticalSalesDocument	Sales Document is statistical	Show values
WBSIsStatisticalWBSElement	Indicator: WBS Element is Statistical Account Assignment	Show values
IsCommitment	Indicator: Is Commitment	Show values
PubSecBudgetCnsmpnAmtType	Budget Consumption Amount Type	Show values
PubSecBudgetIsRelevant	Budget-Relevant Indicator	Show values

Column Name	Description	Domain name
LedgerGLLineItem	Ledger Journal Entry Item	DOCLN6
FinancialPlanningEntryItem	Financial Planning Entry Item	RSNUMRECORD
LedgerFiscalYear	Ledger Fiscal Year	GJAHR
ProjectExternalID	Project External ID	FIS_PROJECTEXT_NO_CONV
PartnerProjectExternalID	Partner Project External ID	FIS_PROJECTEXT_NO_CONV
WBSElementInternalID	WBS Element Internal ID	FIS_WBSINT_NO_CONV
WBSElementExternalID	WBS Element External ID	FIS_WBSEXT_NO_CONV
PartnerWBSElementInternalID	Partner WBS Element Internal ID	FIS_WBSINT_NO_CONV
PartnerWBSElementExternalID	Partner WBS Element External ID	FIS_WBSEXT_NO_CONV
WorkPackage	Plan Item	/CPD/PLAN_ITEM_ID
WorkItem	Work Item ID	/CPD/PFP_WORKITEM_ID
PartnerGrant	Partner Grant	GM_GRANT_NBR
PartnerWBSElement	Partner WBS Element	FIS_WBS
ReferenceDocumentContext	Reference Document Context	AWORG
ReferenceDocument	Reference document number	AWREF
FiscalPeriod	Fiscal Period	POPER
FiscalYearPeriod	Fiscal Year Period	FIS_JAHRPER_CONV
PlanningCategory	Plan Category	FCOM_CATEGORY
PersonnelNumber	Personnel Number	PERNR
SalesDocumentItem	Sales Document Item	POSNR
CustomerSupplierCorporateGroup	Customer Supplier Corporate Group	KONZS
OrderOperation	Operation/Activity Number	VORNR
OrderItem	Order item number	CO_POSNR
SourceReferenceDocumentCntxt	Source Reference Document Context	AWORG
SourceReferenceDocument	Source Reference Document	AWREF
SourceReferenceDocumentItem	Source Reference Document Item	NUMC6
SourceReferenceDocSubitem	Source Reference Document Subitem	NUMC6
GrantID	Grant	GM_GRANT_NBR
SponsoredClass	Sponsored Class	GM_SPONSORED_CLASS
SponsoredProgram	Sponsored Program	GM_SPONSORED_PROG
GteeMBudgetValidityNumber	Budget Validity Number	GM_BDGT_VLDTY_NBR
PubSecBudgetAccount	Budget Account	SAKNR
PubSecBudgetAccountCoCode	Budget Account Company Code	BUKRS
PubSecBudgetCnsmpnFsclPeriod	CC Fiscal Period for Budget Consumption Date	POPER
PubSecBudgetCnsmpnFsclYear	CC Fiscal Year for Budget Consumption Date	GJAHR
BudgetProcess	Budget Process Type	BUDGET_PROCESS
BudgetingType	Budget Type (Subcategory)	BUDGET_SUBCATEGORY
GLAccountAuthorizationGroup	Authorization Group	BRGRU
SupplierBasicAuthorizationGrp	Authorization Group	BRGRU
CustomerBasicAuthorizationGrp	Authorization Group	BRGRU
AcctgDocTypeAuthorizationGroup	Authorization Group	BRGRU
OrderType	Order Type	AUFART
SalesOrderType	Sales Document Type	AUART

Master Data Relations	Join Conditions
Journal Entry Type Client Journal Entry Type	`I_PUBSECBDGTACTLITEMBASIC.MANDT == T003.MANDT` `I_PUBSECBDGTACTLITEMBASIC.ACCOUNTINGDOCUMENTTYPE == T003.BLART`
Asset Class Asset Class Client	`I_PUBSECBDGTACTLITEMBASIC.ASSETCLASS == ANKA.ANLKL` `I_PUBSECBDGTACTLITEMBASIC.MANDT == ANKA.MANDT`
Billing Type Client Billing Type	`I_PUBSECBDGTACTLITEMBASIC.MANDT == TVFK.MANDT` `I_PUBSECBDGTACTLITEMBASIC.BILLINGDOCUMENTTYPE == TVFK.FKART`
Bill-to Party Client Bill-to Party	`I_PUBSECBDGTACTLITEMBASIC.MANDT == KNA1.MANDT` `I_PUBSECBDGTACTLITEMBASIC.BILLTOPARTY == KNA1.KUNNR`
Budget Period Client Fund Budget Period Financial Management Area	`I_PUBSECBDGTACTLITEMBASIC.MANDT == FMFUNDBPD.MANDT` `I_PUBSECBDGTACTLITEMBASIC.FUND == FMFUNDBPD.FINCODE` `I_PUBSECBDGTACTLITEMBASIC.BUDGETPERIOD == FMFUNDBPD.BUDGET_PD` `I_PUBSECBDGTACTLITEMBASIC.FINANCIALMANAGEMENTAREA == FMFUNDBPD.FIKRS`
Business Area Client Business Area	`I_PUBSECBDGTACTLITEMBASIC.MANDT == TGSB.MANDT` `I_PUBSECBDGTACTLITEMBASIC.BUSINESSAREA == TGSB.GSBER`
Business Transaction Type Client Business Transaction Type	`I_PUBSECBDGTACTLITEMBASIC.MANDT == FINSC_CUSTBTTYPE.MANDT` `I_PUBSECBDGTACTLITEMBASIC.BUSINESSTRANSACTIONTYPE == FINSC_CUSTBTTYPE.CBTTYPE`
Cash Origin Account Chart of Accounts Client Cash Origin Account	`I_PUBSECBDGTACTLITEMBASIC.CHARTOFACCOUNTS == SKA1.KTOPL` `I_PUBSECBDGTACTLITEMBASIC.MANDT == SKA1.MANDT` `I_PUBSECBDGTACTLITEMBASIC.CASHLEDGERACCOUNT == SKA1.SAKNR`
Cash Origin Company Code Client Cash Origin Company Code	`I_PUBSECBDGTACTLITEMBASIC.MANDT == T001.MANDT` `I_PUBSECBDGTACTLITEMBASIC.CASHLEDGERCOMPANYCODE == T001.BUKRS`
Chart of Accounts Chart of Accounts Client	`I_PUBSECBDGTACTLITEMBASIC.CHARTOFACCOUNTS == T004.KTOPL` `I_PUBSECBDGTACTLITEMBASIC.MANDT == T004.MANDT`
Company Code Client Company Code	`I_PUBSECBDGTACTLITEMBASIC.MANDT == T001.MANDT` `I_PUBSECBDGTACTLITEMBASIC.COMPANYCODE == T001.BUKRS`
Company Code Currency Client Company Code Currency	`I_PUBSECBDGTACTLITEMBASIC.MANDT == TCURC.MANDT` `I_PUBSECBDGTACTLITEMBASIC.COMPANYCODECURRENCY == TCURC.WAERS`
Controlling Area Client Controlling Area	`I_PUBSECBDGTACTLITEMBASIC.MANDT == TKA01.MANDT` `I_PUBSECBDGTACTLITEMBASIC.CONTROLLINGAREA == TKA01.KOKRS`
Cost Analysis Resource Client Cost Analysis Resource ? Controlling Area	`I_PUBSECBDGTACTLITEMBASIC.MANDT == CSKR.MANDT` `I_PUBSECBDGTACTLITEMBASIC.COSTANALYSISRESOURCE == CSKR.RESRC` `I_PUBSECBDGTACTLITEMBASIC.[column in domain "DATBI"] == CSKR.DATBI` `I_PUBSECBDGTACTLITEMBASIC.CONTROLLINGAREA == CSKR.KOKRS`
Cost Center Client Cost Center ? Controlling Area	`I_PUBSECBDGTACTLITEMBASIC.MANDT == CSKS.MANDT` `I_PUBSECBDGTACTLITEMBASIC.COSTCENTER == CSKS.KOSTL` `I_PUBSECBDGTACTLITEMBASIC.[column in domain "DATBI"] == CSKS.DATBI` `I_PUBSECBDGTACTLITEMBASIC.CONTROLLINGAREA == CSKS.KOKRS`
Activity Type Client Activity Type ? Controlling Area	`I_PUBSECBDGTACTLITEMBASIC.MANDT == CSLA.MANDT` `I_PUBSECBDGTACTLITEMBASIC.COSTCTRACTIVITYTYPE == CSLA.LSTAR` `I_PUBSECBDGTACTLITEMBASIC.[column in domain "DATBI"] == CSLA.DATBI` `I_PUBSECBDGTACTLITEMBASIC.CONTROLLINGAREA == CSLA.KOKRS`
Cost Source Unit Client Cost Source Unit	`I_PUBSECBDGTACTLITEMBASIC.MANDT == T006.MANDT` `I_PUBSECBDGTACTLITEMBASIC.COSTSOURCEUNIT == T006.MSEHI`
Customer Number Client Customer Number	`I_PUBSECBDGTACTLITEMBASIC.MANDT == KNA1.MANDT` `I_PUBSECBDGTACTLITEMBASIC.CUSTOMER == KNA1.KUNNR`
Customer Group Client Customer Group	`I_PUBSECBDGTACTLITEMBASIC.MANDT == T151.MANDT` `I_PUBSECBDGTACTLITEMBASIC.CUSTOMERGROUP == T151.KDGRP`
Customer or Supplier Country/Region Client Customer or Supplier Country/Region	`I_PUBSECBDGTACTLITEMBASIC.MANDT == T005.MANDT` `I_PUBSECBDGTACTLITEMBASIC.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1`
Customer Supplier Industry Client Customer Supplier Industry	`I_PUBSECBDGTACTLITEMBASIC.MANDT == T016.MANDT` `I_PUBSECBDGTACTLITEMBASIC.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH`
Distribution Channel Client Distribution Channel	`I_PUBSECBDGTACTLITEMBASIC.MANDT == TVTW.MANDT` `I_PUBSECBDGTACTLITEMBASIC.DISTRIBUTIONCHANNEL == TVTW.VTWEG`
Financial Management Area Client Financial Management Area	`I_PUBSECBDGTACTLITEMBASIC.MANDT == FM01.MANDT` `I_PUBSECBDGTACTLITEMBASIC.FINANCIALMANAGEMENTAREA == FM01.FIKRS`
Financial Transaction Type Client Financial Transaction Type	`I_PUBSECBDGTACTLITEMBASIC.MANDT == T856.MANDT` `I_PUBSECBDGTACTLITEMBASIC.FINANCIALTRANSACTIONTYPE == T856.TRTYP`
Fiscal Year Variant Fiscal Year Variant Client	`I_PUBSECBDGTACTLITEMBASIC.FISCALYEARVARIANT == T009.PERIV` `I_PUBSECBDGTACTLITEMBASIC.MANDT == T009.MANDT`
Functional Area Client Functional Area	`I_PUBSECBDGTACTLITEMBASIC.MANDT == TFKB.MANDT` `I_PUBSECBDGTACTLITEMBASIC.FUNCTIONALAREA == TFKB.FKBER`
Fund Client Fund Financial Management Area	`I_PUBSECBDGTACTLITEMBASIC.MANDT == FMFINCODE.MANDT` `I_PUBSECBDGTACTLITEMBASIC.FUND == FMFINCODE.FINCODE` `I_PUBSECBDGTACTLITEMBASIC.FINANCIALMANAGEMENTAREA == FMFINCODE.FIKRS`
G/L Account G/L Account Client Company Code	`I_PUBSECBDGTACTLITEMBASIC.GLACCOUNT == SKB1.SAKNR` `I_PUBSECBDGTACTLITEMBASIC.MANDT == SKB1.MANDT` `I_PUBSECBDGTACTLITEMBASIC.COMPANYCODE == SKB1.BUKRS`
Global Currency Client Global Currency	`I_PUBSECBDGTACTLITEMBASIC.MANDT == TCURC.MANDT` `I_PUBSECBDGTACTLITEMBASIC.GLOBALCURRENCY == TCURC.WAERS`
Ledger in General Ledger Accounting Ledger in General Ledger Accounting Source Ledger Client	`I_PUBSECBDGTACTLITEMBASIC.LEDGER == FINSC_LEDGER.RLDNR` `I_PUBSECBDGTACTLITEMBASIC.SOURCELEDGER == FINSC_LEDGER.RLDNR` `I_PUBSECBDGTACTLITEMBASIC.MANDT == FINSC_LEDGER.MANDT`
Order ID Client Order ID	`I_PUBSECBDGTACTLITEMBASIC.MANDT == AUFK.MANDT` `I_PUBSECBDGTACTLITEMBASIC.ORDERID == AUFK.AUFNR`
Organization Division Client Organization Division	`I_PUBSECBDGTACTLITEMBASIC.MANDT == TSPA.MANDT` `I_PUBSECBDGTACTLITEMBASIC.ORGANIZATIONDIVISION == TSPA.SPART`
Origin Cost Center Client Origin Cost Center ? Controlling Area	`I_PUBSECBDGTACTLITEMBASIC.MANDT == CSKS.MANDT` `I_PUBSECBDGTACTLITEMBASIC.ORIGINCOSTCENTER == CSKS.KOSTL` `I_PUBSECBDGTACTLITEMBASIC.[column in domain "DATBI"] == CSKS.DATBI` `I_PUBSECBDGTACTLITEMBASIC.CONTROLLINGAREA == CSKS.KOKRS`
Origin Cost Center Activity Type Client ? Controlling Area Origin Cost Center Activity Type	`I_PUBSECBDGTACTLITEMBASIC.MANDT == CSLA.MANDT` `I_PUBSECBDGTACTLITEMBASIC.[column in domain "DATBI"] == CSLA.DATBI` `I_PUBSECBDGTACTLITEMBASIC.CONTROLLINGAREA == CSLA.KOKRS` `I_PUBSECBDGTACTLITEMBASIC.ORIGINCOSTCTRACTIVITYTYPE == CSLA.LSTAR`
Origin Profit Center Client ? Controlling Area Origin Profit Center	`I_PUBSECBDGTACTLITEMBASIC.MANDT == CEPC.MANDT` `I_PUBSECBDGTACTLITEMBASIC.[column in domain "DATBI"] == CEPC.DATBI` `I_PUBSECBDGTACTLITEMBASIC.CONTROLLINGAREA == CEPC.KOKRS` `I_PUBSECBDGTACTLITEMBASIC.ORIGINPROFITCENTER == CEPC.PRCTR`
FM: Partner Budget Period Client FM: Partner Budget Period Partner Fund Financial Management Area	`I_PUBSECBDGTACTLITEMBASIC.MANDT == FMFUNDBPD.MANDT` `I_PUBSECBDGTACTLITEMBASIC.PARTNERBUDGETPERIOD == FMFUNDBPD.BUDGET_PD` `I_PUBSECBDGTACTLITEMBASIC.PARTNERFUND == FMFUNDBPD.FINCODE` `I_PUBSECBDGTACTLITEMBASIC.FINANCIALMANAGEMENTAREA == FMFUNDBPD.FIKRS`
Partner Business Area Client Partner Business Area	`I_PUBSECBDGTACTLITEMBASIC.MANDT == TGSB.MANDT` `I_PUBSECBDGTACTLITEMBASIC.PARTNERBUSINESSAREA == TGSB.GSBER`
Company ID of Trading Partner Company ID of Trading Partner Client	`I_PUBSECBDGTACTLITEMBASIC.PARTNERCOMPANY == T880.RCOMP` `I_PUBSECBDGTACTLITEMBASIC.MANDT == T880.MANDT`
Partner Company Code Client Partner Company Code	`I_PUBSECBDGTACTLITEMBASIC.MANDT == T001.MANDT` `I_PUBSECBDGTACTLITEMBASIC.PARTNERCOMPANYCODE == T001.BUKRS`
Partner Cost Center Client ? Controlling Area Partner Cost Center	`I_PUBSECBDGTACTLITEMBASIC.MANDT == CSKS.MANDT` `I_PUBSECBDGTACTLITEMBASIC.[column in domain "DATBI"] == CSKS.DATBI` `I_PUBSECBDGTACTLITEMBASIC.CONTROLLINGAREA == CSKS.KOKRS` `I_PUBSECBDGTACTLITEMBASIC.PARTNERCOSTCENTER == CSKS.KOSTL`
Partner Cost Center Activity Type Client Partner Cost Center Activity Type ? Controlling Area	`I_PUBSECBDGTACTLITEMBASIC.MANDT == CSLA.MANDT` `I_PUBSECBDGTACTLITEMBASIC.PARTNERCOSTCTRACTIVITYTYPE == CSLA.LSTAR` `I_PUBSECBDGTACTLITEMBASIC.[column in domain "DATBI"] == CSLA.DATBI` `I_PUBSECBDGTACTLITEMBASIC.CONTROLLINGAREA == CSLA.KOKRS`
Partner Functional Area Client Partner Functional Area	`I_PUBSECBDGTACTLITEMBASIC.MANDT == TFKB.MANDT` `I_PUBSECBDGTACTLITEMBASIC.PARTNERFUNCTIONALAREA == TFKB.FKBER`
Partner Fund Client Partner Fund Financial Management Area	`I_PUBSECBDGTACTLITEMBASIC.MANDT == FMFINCODE.MANDT` `I_PUBSECBDGTACTLITEMBASIC.PARTNERFUND == FMFINCODE.FINCODE` `I_PUBSECBDGTACTLITEMBASIC.FINANCIALMANAGEMENTAREA == FMFINCODE.FIKRS`
Partner Order Partner Order Client	`I_PUBSECBDGTACTLITEMBASIC.PARTNERORDER == AUFK.AUFNR` `I_PUBSECBDGTACTLITEMBASIC.MANDT == AUFK.MANDT`
Partner Profit Center Partner Profit Center Client ? Controlling Area	`I_PUBSECBDGTACTLITEMBASIC.PARTNERPROFITCENTER == CEPC.PRCTR` `I_PUBSECBDGTACTLITEMBASIC.MANDT == CEPC.MANDT` `I_PUBSECBDGTACTLITEMBASIC.[column in domain "DATBI"] == CEPC.DATBI` `I_PUBSECBDGTACTLITEMBASIC.CONTROLLINGAREA == CEPC.KOKRS`
Partner Project Internal ID Client Partner Project Internal ID	`I_PUBSECBDGTACTLITEMBASIC.MANDT == PROJ.MANDT` `I_PUBSECBDGTACTLITEMBASIC.PARTNERPROJECTINTERNALID == PROJ.PSPNR`
Partner Segment for Segmental Reporting Partner Segment for Segmental Reporting Client	`I_PUBSECBDGTACTLITEMBASIC.PARTNERSEGMENT == FAGL_SEGM.SEGMENT` `I_PUBSECBDGTACTLITEMBASIC.MANDT == FAGL_SEGM.MANDT`
Plant Client Plant	`I_PUBSECBDGTACTLITEMBASIC.MANDT == T001W.MANDT` `I_PUBSECBDGTACTLITEMBASIC.PLANT == T001W.WERKS`
Product Number Client Product Number	`I_PUBSECBDGTACTLITEMBASIC.MANDT == MARA.MANDT` `I_PUBSECBDGTACTLITEMBASIC.PRODUCT == MARA.MATNR`
Profit Center Profit Center Client ? Controlling Area	`I_PUBSECBDGTACTLITEMBASIC.PROFITCENTER == CEPC.PRCTR` `I_PUBSECBDGTACTLITEMBASIC.MANDT == CEPC.MANDT` `I_PUBSECBDGTACTLITEMBASIC.[column in domain "DATBI"] == CEPC.DATBI` `I_PUBSECBDGTACTLITEMBASIC.CONTROLLINGAREA == CEPC.KOKRS`
Project Internal ID Client Project Internal ID	`I_PUBSECBDGTACTLITEMBASIC.MANDT == PROJ.MANDT` `I_PUBSECBDGTACTLITEMBASIC.PROJECTINTERNALID == PROJ.PSPNR`
Budget Consumption Type Client Budget Consumption Type	`I_PUBSECBDGTACTLITEMBASIC.MANDT == PSM_D_BDGTCNSTY.CLIENT` `I_PUBSECBDGTACTLITEMBASIC.PUBSECBUDGETCNSMPNTYPE == PSM_D_BDGTCNSTY.BDGT_CNSMPN_TYPE`
Reference Document Type	`I_PUBSECBDGTACTLITEMBASIC.REFERENCEDOCUMENTTYPE == TTYP.AWTYP`
Sales District Client Sales District	`I_PUBSECBDGTACTLITEMBASIC.MANDT == T171.MANDT` `I_PUBSECBDGTACTLITEMBASIC.SALESDISTRICT == T171.BZIRK`
Sales Organization Client Sales Organization	`I_PUBSECBDGTACTLITEMBASIC.MANDT == TVKO.MANDT` `I_PUBSECBDGTACTLITEMBASIC.SALESORGANIZATION == TVKO.VKORG`
Segment for Segmental Reporting Client Segment for Segmental Reporting	`I_PUBSECBDGTACTLITEMBASIC.MANDT == FAGL_SEGM.MANDT` `I_PUBSECBDGTACTLITEMBASIC.SEGMENT == FAGL_SEGM.SEGMENT`
Service Contract ID Client Service Contract ID Service Contract Item ID Service Contract Type	`I_PUBSECBDGTACTLITEMBASIC.MANDT == FCO_SRVDOC.MANDT` `I_PUBSECBDGTACTLITEMBASIC.SERVICECONTRACT == FCO_SRVDOC.SERVICE_DOC_ID` `I_PUBSECBDGTACTLITEMBASIC.SERVICECONTRACTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID` `I_PUBSECBDGTACTLITEMBASIC.SERVICECONTRACTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE`
Service Contract Item ID Client Service Contract ID Service Contract Item ID Service Contract Type	`I_PUBSECBDGTACTLITEMBASIC.MANDT == FCO_SRVDOC.MANDT` `I_PUBSECBDGTACTLITEMBASIC.SERVICECONTRACT == FCO_SRVDOC.SERVICE_DOC_ID` `I_PUBSECBDGTACTLITEMBASIC.SERVICECONTRACTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID` `I_PUBSECBDGTACTLITEMBASIC.SERVICECONTRACTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE`
Service Contract Type Client Service Contract Type	`I_PUBSECBDGTACTLITEMBASIC.MANDT == CRMC_PROC_TYPE.CLIENT` `I_PUBSECBDGTACTLITEMBASIC.SERVICECONTRACTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE`
Service Document ID Client Service Document Item ID Service Document ID Service Document Type	`I_PUBSECBDGTACTLITEMBASIC.MANDT == FCO_SRVDOC.MANDT` `I_PUBSECBDGTACTLITEMBASIC.SERVICEDOCUMENTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID` `I_PUBSECBDGTACTLITEMBASIC.SERVICEDOCUMENT == FCO_SRVDOC.SERVICE_DOC_ID` `I_PUBSECBDGTACTLITEMBASIC.SERVICEDOCUMENTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE`
Service Document Item ID Client Service Document Item ID Service Document ID Service Document Type	`I_PUBSECBDGTACTLITEMBASIC.MANDT == FCO_SRVDOC.MANDT` `I_PUBSECBDGTACTLITEMBASIC.SERVICEDOCUMENTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID` `I_PUBSECBDGTACTLITEMBASIC.SERVICEDOCUMENT == FCO_SRVDOC.SERVICE_DOC_ID` `I_PUBSECBDGTACTLITEMBASIC.SERVICEDOCUMENTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE`
Service Document Type Client Service Document Type	`I_PUBSECBDGTACTLITEMBASIC.MANDT == CRMC_PROC_TYPE.CLIENT` `I_PUBSECBDGTACTLITEMBASIC.SERVICEDOCUMENTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE`
Ship-to Party Client Ship-to Party	`I_PUBSECBDGTACTLITEMBASIC.MANDT == KNA1.MANDT` `I_PUBSECBDGTACTLITEMBASIC.SHIPTOPARTY == KNA1.KUNNR`
Product Sold Client Product Sold	`I_PUBSECBDGTACTLITEMBASIC.MANDT == MARA.MANDT` `I_PUBSECBDGTACTLITEMBASIC.SOLDPRODUCT == MARA.MATNR`
Source Ledger Client Ledger in General Ledger Accounting Source Ledger	`I_PUBSECBDGTACTLITEMBASIC.MANDT == FINSC_LEDGER.MANDT` `I_PUBSECBDGTACTLITEMBASIC.LEDGER == FINSC_LEDGER.RLDNR` `I_PUBSECBDGTACTLITEMBASIC.SOURCELEDGER == FINSC_LEDGER.RLDNR`
Source Logical System	`I_PUBSECBDGTACTLITEMBASIC.SOURCELOGICALSYSTEM == TBDLS.LOGSYS`
Source Reference Document Type	`I_PUBSECBDGTACTLITEMBASIC.SOURCEREFERENCEDOCUMENTTYPE == TTYP.AWTYP`
Supplier Client Supplier	`I_PUBSECBDGTACTLITEMBASIC.MANDT == LFA1.MANDT` `I_PUBSECBDGTACTLITEMBASIC.SUPPLIER == LFA1.LIFNR`
Transaction Currency Client Transaction Currency	`I_PUBSECBDGTACTLITEMBASIC.MANDT == TCURC.MANDT` `I_PUBSECBDGTACTLITEMBASIC.TRANSACTIONCURRENCY == TCURC.WAERS`
Valuation area Client Valuation area	`I_PUBSECBDGTACTLITEMBASIC.MANDT == T001K.MANDT` `I_PUBSECBDGTACTLITEMBASIC.VALUATIONAREA == T001K.BWKEY`
Object ID of the resource Client ? Object ID of the resource	`I_PUBSECBDGTACTLITEMBASIC.MANDT == CRID.MANDT` `I_PUBSECBDGTACTLITEMBASIC.[column in domain "CR_OBJTY"] == CRID.OBJTY` `I_PUBSECBDGTACTLITEMBASIC.WORKCENTERINTERNALID == CRID.OBJID`