I_PubSecFormBundleEnhanced

Form Bundle with Status Profile | view: IPSFORMBNDLENH | Extraction: Not supported | Component: Public Sector Contract Accounts Receivable and Payable
Tables used: CRM_JSTO, DFMCA_RETURN
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
FormSubmissionDeferralDate Deferral Date for Submission of Form
RefundDate Refund Complete Date
PostmarkExtensionDate Postmark Extension Date
ReconciliationDate Checked on
FilingDate Last Filing Date
StatuteOfLimitationDate Statute of Limitation Date
KeyDate Key Date for Determination of BRF Events
DeferralRequestDate As Filed Extension Date
Column Name Description
TaxpayerSubapplication Subapplication in Contract Accounts Receivable and Payable Show values
JointTaxpayerSubapplication Subapplication in Contract Accounts Receivable and Payable Show values
FormBndlSystStsIsReplicated Status replicated Show values
PubSecFormBundleIsCnsldtd Consolidating Tax Return Show values
PubSecFormBundleIsEstimated Estimated Form Bundle Show values
PublicSectorMassProcessingCode Process Indicator Show values
Column Name Description Domain name
PublicSectorFormBundle Number of a Form Bundle FBNUM_PS
AuthorizationGroup Authorization Group BEGRU
TaxpayerContract Taxpayer Contract Object Number VTREF_KK
JointTaxpayerContract Joint Taxpayer Contract Object Number VTREF_KK
PubSecFormBundleSystSts1 FPF: System Status of a Form Bundle CRM_J_STATUS
PubSecFormBundleSystSts2 FPF: System Status of a Form Bundle CRM_J_STATUS
PubSecFormBundleUserStatus FPF: User Status of a Form Bundle CRM_J_STATUS
ReceiptDateTime Received On TZNTSTMPS
PostmarkDateTime Postmark TZNTSTMPS
ValidationDateTime Time When Validation Started TZNTSTMPS
PubSecFormBundleCurVersion Current TTF-Form Version
ConsolidatingFormBundleUUID Technical Case Key (Case GUID) SYSUUID_C
DuplicateToFormBundleUUID Technical Case Key (Case GUID) SYSUUID_C
CADocMgmtSrvcStorageLocation Identification of Storage Location of Document CHAR16
CADocMgmtSrvcBatch Identification Number of Lot CHAR12
CASubAreaForParallelization Subarea for Parallelization in Mass Processing NUMC3
CreatedByUser Name of Person Responsible for Creating the Object USNAM
CreationDateTime Time at Which Object Was Created TZNTSTMPS
LastChangedByUser Name of Person Who Changed Object USNAM
LastChangeDateTime Last Changed At TZNTSTMPS
Master Data Relations Join Conditions
Communication Channel
  • Communication Channel
  • Client
  • I_PUBSECFORMBUNDLEENHANCED.CACOMMUNICATIONCHANNEL == TFK068F.INPCH
  • I_PUBSECFORMBUNDLEENHANCED.MANDT == TFK068F.MANDT
Joint Taxpayer Number
  • Joint Taxpayer Number
  • Client
  • I_PUBSECFORMBUNDLEENHANCED.JOINTTAXPAYER == BUT000.PARTNER
  • I_PUBSECFORMBUNDLEENHANCED.MANDT == BUT000.CLIENT
Joint Taxpayer Account Number
  • Joint Taxpayer Account Number
  • Joint Taxpayer Number
  • Client
  • I_PUBSECFORMBUNDLEENHANCED.JOINTTAXPAYERACCOUNT == FKKVKP.VKONT
  • I_PUBSECFORMBUNDLEENHANCED.JOINTTAXPAYER == FKKVKP.GPART
  • I_PUBSECFORMBUNDLEENHANCED.MANDT == FKKVKP.MANDT
Joint Taxpayer Identification Number
  • Joint Taxpayer Identification Type
  • Joint Taxpayer Identification Number
  • Joint Taxpayer Number
  • Client
  • I_PUBSECFORMBUNDLEENHANCED.JOINTTAXPAYERIDNTYPE == BUT0ID.TYPE
  • I_PUBSECFORMBUNDLEENHANCED.JOINTTAXPAYERIDENTIFICATION == BUT0ID.IDNUMBER
  • I_PUBSECFORMBUNDLEENHANCED.JOINTTAXPAYER == BUT0ID.PARTNER
  • I_PUBSECFORMBUNDLEENHANCED.MANDT == BUT0ID.CLIENT
Joint Taxpayer Identification Type
  • Joint Taxpayer Identification Type
  • Client
  • I_PUBSECFORMBUNDLEENHANCED.JOINTTAXPAYERIDNTYPE == TB039A.TYPE
  • I_PUBSECFORMBUNDLEENHANCED.MANDT == TB039A.CLIENT
Form Bundle Type Description
  • Form Bundle Type Description
  • Client
  • I_PUBSECFORMBUNDLEENHANCED.PUBLICSECTORFORMBUNDLETYPE == TFMCA_FPF_FBT.FBTYP
  • I_PUBSECFORMBUNDLEENHANCED.MANDT == TFMCA_FPF_FBT.MANDT
Form-Based Process
  • Form-Based Process
  • Client
Revenue Type
  • Revenue Type
  • Client
  • I_PUBSECFORMBUNDLEENHANCED.PUBLICSECTORREVENUETYPE == TFMCA_REVTYPE.ABTYP
  • I_PUBSECFORMBUNDLEENHANCED.MANDT == TFMCA_REVTYPE.MANDT
Status Profile
  • Status Profile
  • Client
  • I_PUBSECFORMBUNDLEENHANCED.STATUSPROFILE == TJ20.STSMA
  • I_PUBSECFORMBUNDLEENHANCED.MANDT == TJ20.MANDT
Tax Adviser
  • Tax Adviser
  • Client
  • I_PUBSECFORMBUNDLEENHANCED.TAXADVISER == BUT000.PARTNER
  • I_PUBSECFORMBUNDLEENHANCED.MANDT == BUT000.CLIENT
Taxpayer Number
  • Client
  • Taxpayer Number
  • I_PUBSECFORMBUNDLEENHANCED.MANDT == BUT000.CLIENT
  • I_PUBSECFORMBUNDLEENHANCED.TAXPAYER == BUT000.PARTNER
Taxpayer Account Number
  • Taxpayer Account Number
  • Client
  • Taxpayer Number
  • I_PUBSECFORMBUNDLEENHANCED.TAXPAYERACCOUNT == FKKVKP.VKONT
  • I_PUBSECFORMBUNDLEENHANCED.MANDT == FKKVKP.MANDT
  • I_PUBSECFORMBUNDLEENHANCED.TAXPAYER == FKKVKP.GPART
Taxpayer Identification Number
  • Taxpayer Identification Type
  • Taxpayer Identification Number
  • Client
  • Taxpayer Number
  • I_PUBSECFORMBUNDLEENHANCED.TAXPAYERIDENTIFICATIONTYPE == BUT0ID.TYPE
  • I_PUBSECFORMBUNDLEENHANCED.TAXPAYERIDENTIFICATION == BUT0ID.IDNUMBER
  • I_PUBSECFORMBUNDLEENHANCED.MANDT == BUT0ID.CLIENT
  • I_PUBSECFORMBUNDLEENHANCED.TAXPAYER == BUT0ID.PARTNER
Taxpayer Identification Type
  • Taxpayer Identification Type
  • Client
  • I_PUBSECFORMBUNDLEENHANCED.TAXPAYERIDENTIFICATIONTYPE == TB039A.TYPE
  • I_PUBSECFORMBUNDLEENHANCED.MANDT == TB039A.CLIENT
Other Relations | to Master Data Relations ↑ Join Conditions
Key for Period Assignment
  • Key for Period Assignment
  • Client
  • I_PUBSECFORMBUNDLEENHANCED.CAPERIODCODE == TFKPERIOD.PERSL
  • I_PUBSECFORMBUNDLEENHANCED.MANDT == TFKPERIOD.MANDT