C_PubSecFormBundleKPI

Form Bundle Smart Business KPIs | view: CPSFORMBNDLSBKPI | Extraction: Not supported | Component: Public Sector Contract Accounts Receivable and Payable
Tables used: CRM_JSTO, BUT000, BUT0IS, TFK068F, TFK068FT, TFK001P, TFK001PT, TB038A, TB038B, DFMCA_RETURN, TFMCA_FORMPROC, TFMCA_REVTYPE, TFMCA_FPF_FBT, TFMCA_FPF_FBTT, TFMCA_FORMPROCT, TFMCA_REVTYPET, TJ02, TJ02T, TB038
Column Name Description
PublicSectorFormBundleUUID Technical Key of Carrying Object
Column Name Description
💲 Tax Return Currency (TransactionCurrency):
TaxAmountInTransCrcy Tax Return Amount
Column Name Description
Column Name Description
CAStartDateOfBillingPeriod Billing Period From
CAEndDateOfBillingPeriod Billing Period To
DueDate Tax Due Date
Column Name Description
FormBndlSystStsIsReplicated Status replicated Show values
Column Name Description Domain name
PublicSectorFormBundle Number of a Form Bundle FBNUM_PS
NumberOfPubSecFormBundles Number of Form Bundles INT4
PublicSectorFormProcessName Description for Form-Based Process PHASET_PS
PubSecFormBundleTypeName Form Bundle Type Description TXT50
PublicSectorRevenueTypeName Revenue Type TEXT30
AuthorizationGroup Authorization Group BEGRU
TaxPayerName null
TaxpayerContract Taxpayer Contract Object Number VTREF_KK
IndustryKeyShortDescription Description TEXT20
JointTaxpayerContract Joint Taxpayer Contract Object Number VTREF_KK
CAPeriodCodeName Text for Period Key TXT50
PubSecFormBundleSystSts1 FPF: System Status of a Form Bundle CRM_J_STATUS
PubSecFormBundleSystSts1Name Object status TEXT30
PubSecFormBundleSystSts2 FPF: System Status of a Form Bundle CRM_J_STATUS
PubSecFormBundleSystSts2Name Object status TEXT30
PubSecFormBundleUserStatus FPF: User Status of a Form Bundle CRM_J_STATUS
PubSecFormBundleCurVersion Current TTF-Form Version
CACommunicationChannelName Description of Communication Channel TEXT50
Master Data Relations Join Conditions
Communication Channel
  • Communication Channel
  • Client
  • C_PUBSECFORMBUNDLEKPI.CACOMMUNICATIONCHANNEL == TFK068F.INPCH
  • C_PUBSECFORMBUNDLEKPI.MANDT == TFK068F.MANDT
Joint Taxpayer Number
  • Joint Taxpayer Number
  • Client
  • C_PUBSECFORMBUNDLEKPI.JOINTTAXPAYER == BUT000.PARTNER
  • C_PUBSECFORMBUNDLEKPI.MANDT == BUT000.CLIENT
Joint Taxpayer Account Number
  • Joint Taxpayer Number
  • Joint Taxpayer Account Number
  • Client
  • C_PUBSECFORMBUNDLEKPI.JOINTTAXPAYER == FKKVKP.GPART
  • C_PUBSECFORMBUNDLEKPI.JOINTTAXPAYERACCOUNT == FKKVKP.VKONT
  • C_PUBSECFORMBUNDLEKPI.MANDT == FKKVKP.MANDT
Joint Taxpayer Identification Number
  • Joint Taxpayer Number
  • Joint Taxpayer Identification Number
  • Joint Taxpayer Identification Type
  • Client
  • C_PUBSECFORMBUNDLEKPI.JOINTTAXPAYER == BUT0ID.PARTNER
  • C_PUBSECFORMBUNDLEKPI.JOINTTAXPAYERIDENTIFICATION == BUT0ID.IDNUMBER
  • C_PUBSECFORMBUNDLEKPI.JOINTTAXPAYERIDNTYPE == BUT0ID.TYPE
  • C_PUBSECFORMBUNDLEKPI.MANDT == BUT0ID.CLIENT
Joint Taxpayer Identification Type
  • Joint Taxpayer Identification Type
  • Client
  • C_PUBSECFORMBUNDLEKPI.JOINTTAXPAYERIDNTYPE == TB039A.TYPE
  • C_PUBSECFORMBUNDLEKPI.MANDT == TB039A.CLIENT
Form Bundle Type Description
  • Form Bundle Type Description
  • Client
Form-Based Process
  • Form-Based Process
  • Client
Revenue Type
  • Revenue Type
  • Client
Taxpayer Number
  • Client
  • Taxpayer Number
  • C_PUBSECFORMBUNDLEKPI.MANDT == BUT000.CLIENT
  • C_PUBSECFORMBUNDLEKPI.TAXPAYER == BUT000.PARTNER
Taxpayer Account Number
  • Taxpayer Account Number
  • Client
  • Taxpayer Number
  • C_PUBSECFORMBUNDLEKPI.TAXPAYERACCOUNT == FKKVKP.VKONT
  • C_PUBSECFORMBUNDLEKPI.MANDT == FKKVKP.MANDT
  • C_PUBSECFORMBUNDLEKPI.TAXPAYER == FKKVKP.GPART
Authorization Group
  • Authorization Group
  • ?
  • Client
  • C_PUBSECFORMBUNDLEKPI.TAXPAYERAUTHORIZATIONGROUP == TB037.AUGRP
  • C_PUBSECFORMBUNDLEKPI.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
  • C_PUBSECFORMBUNDLEKPI.MANDT == TB037.CLIENT
Taxpayer Identification Number
  • Taxpayer Identification Type
  • Taxpayer Identification Number
  • Client
  • Taxpayer Number
  • C_PUBSECFORMBUNDLEKPI.TAXPAYERIDENTIFICATIONTYPE == BUT0ID.TYPE
  • C_PUBSECFORMBUNDLEKPI.TAXPAYERIDENTIFICATION == BUT0ID.IDNUMBER
  • C_PUBSECFORMBUNDLEKPI.MANDT == BUT0ID.CLIENT
  • C_PUBSECFORMBUNDLEKPI.TAXPAYER == BUT0ID.PARTNER
Taxpayer Identification Type
  • Taxpayer Identification Type
  • Client
  • C_PUBSECFORMBUNDLEKPI.TAXPAYERIDENTIFICATIONTYPE == TB039A.TYPE
  • C_PUBSECFORMBUNDLEKPI.MANDT == TB039A.CLIENT
Taxpayer Standard Industry
  • ?
  • Client
  • Taxpayer Standard Industry
  • C_PUBSECFORMBUNDLEKPI.[column in domain "BU_ISTYPE"] == TB038A.ISTYPE
  • C_PUBSECFORMBUNDLEKPI.MANDT == TB038A.CLIENT
  • C_PUBSECFORMBUNDLEKPI.TAXPAYERSTANDARDINDUSTRY == TB038A.IND_SECTOR
Other Relations | to Master Data Relations ↑ Join Conditions
Key for Period Assignment
  • Key for Period Assignment
  • Client
  • C_PUBSECFORMBUNDLEKPI.CAPERIODCODE == TFKPERIOD.PERSL
  • C_PUBSECFORMBUNDLEKPI.MANDT == TFKPERIOD.MANDT