Form Bundle Header (TRM)

DataSource Transactional Data: 0PSCD_TRM_FB_HEADER_01

This DataSource loads header data for form bundles.

Note Note

This DataSource is only available if you have implemented SAP enhancement package 5 for SAP ERP 6.0 and activated the Tax and Revenue Management incl. Withholding Tax business function.

End of the note.

Technical Data

Application Component	Public Sector Collection and Disbursement (PSCD)
Available as of Release	SAP enhancement package 5 for SAP ERP 6.0, Business Function PSCD, Collections and Correspondence Management
Shipment	SAP NetWeaver 7.0 BI Content Add-On 5 SP01
Content Versions	No Content versions exist.
RemoteCube-Capable	No
Delta-Capable	Yes
Extraction from Archives	No
Verifiable	No

Data Modeling

Delta Update

This DataSource uses the After Image via Delta Queue delta update process.

Note Note

If you want to use delta extraction for this DataSource, in other words, only changed or new data records are extracted to the business warehouse system, the system administrator has to start the Update Delta Queues for Form Bundles function (transaction code FMCAPFBI) to populate the delta queue. Execute this step prior to each delta extraction process into the business warehouse system.

End of the note.

Fields of Origin for the Extract Structure
Fields in the Extract Structure	Description of the Field in the Extract Structure	Table of Origin	Field in the Table of Origin
CASE_GUID	Technical Key of Carrying Object	DFMCA_RETURN	CASE_GUID
FBNUM	Number of a Form Bundle	DFMCA_RETURN	FBNUM
REVENUE_TYPE	Revenue Type	DFMCA_RETURN	REVENUE_TYPE
TAXPAYER	Business Partner Number	DFMCA_RETURN	TAXPAYER
JOINT_FILER	Business Partner Number	DFMCA_RETURN	JOINT_FILER
BU_ID_TYPE	Identification Type	DFMCA_RETURN	BU_ID_TYPE
TAXPAYER_ID	Identification Number	DFMCA_RETURN	TAXPAYER_ID
JOINT_ID_TYPE	Identification Type	DFMCA_RETURN	JOINT_ID_TYPE
JOINT_FILER_ID	Identification Number	DFMCA_RETURN	JOINT_FILER_ID
ACCOUNT	Contract Account Number	DFMCA_RETURN	ACCOUNT
REG_ID	Reference Specifications from Contract	DFMCA_RETURN	REG_ID
REG_TYPE	Subapplication in Contract Accounts Receivable and Payable	DFMCA_RETURN	REG_TYPE
JOINT_ACCOUNT	Contract Account Number	DFMCA_RETURN	JOINT_ACCOUNT
JOINT_REG_ID	Reference Specifications from Contract	DFMCA_RETURN	JOINT_REG_ID
JOINT_REG_TYPE	Subapplication in Contract Accounts Receivable and Payable	DFMCA_RETURN	JOINT_REG_TYPE
APPLY_FROM	Lower Limit of Settlement Period	DFMCA_RETURN	APPLY_FROM
APPLY_TO	Upper Limit of the Billing Period	DFMCA_RETURN	APPLY_TO
PERIOD_KEY	Key for Period Assignment	DFMCA_RETURN	PERIOD_KEY
BEGRU	Authorization Group	DFMCA_RETURN	BEGRU
CONSOLIDATED_BY	Technical Case Key (Case GUID)	DFMCA_RETURN	CONSOLIDATED_BY
DUPLICATE_TO	Technical Case Key (Case GUID)	DFMCA_RETURN	DUPLICATE_TO
FORMPROC	Form-Based Process	DFMCA_RETURN	FORMPROC
X_CONS	Checkbox	DFMCA_RETURN	X_CONS
FBTYP	Form Bundle Type	DFMCA_RETURN	FBTYP
BETRW	Tax Return Amount	DFMCA_RETURN	BETRW
WAERS	Tax Return Currency	DFMCA_RETURN	WAERS
ERNAM	Name of Person Who Created Object	DFMCA_RETURN	ERNAM
ERDAT	Date on Which Record Was Created	DFMCA_RETURN	ERDAT
ERTIM	Time at which the object was created	DFMCA_RETURN	ERTIM
AENAM	Name of Person Who Changed Object	DFMCA_RETURN	AENAM
AETSP	Last Changed At	DFMCA_RETURN	AETSP
KEYDT	Key Date for Determination of BRF Events	DFMCA_RETURN	KEYDT
VALIDATION	Time When Validation Started	DFMCA_RETURN	VALIDATION
POSTMARK	Postmark	DFMCA_RETURN	POSTMARK
RECEIPT	Receipt	DFMCA_RETURN	RECEIPT
DUE_DATE	Due Date for Tax Return	DFMCA_RETURN	DUE_DATE
DEFERRAL_DATE	Deferral Date for Submission of Form	DFMCA_RETURN	DEFERRAL_DATE
REFUND_COMPLETE	Refund Complete Date	DFMCA_RETURN	REFUND_COMPLETE
POSTMARK_EXT	Postmark Extension Date	DFMCA_RETURN	POSTMARK_EXT
RECONCILIATION	Checked on	DFMCA_RETURN	RECONCILIATION
LAST_FILING	Last Filing Date	DFMCA_RETURN	LAST_FILING
AS_FILED_EXT	As Filed Extension Date	DFMCA_RETURN	AS_FILED_EXT
DATE_SOL	Statute of Limitation Date	DFMCA_RETURN	DATE_SOL
BATCH_ID	Identification Number of Lot	DFMCA_RETURN	BATCH_ID
LOCATOR_NUMBER	Identification of Storage Location of Document	DFMCA_RETURN	LOCATOR_NUMBER
TRANSACTION_TYPE	Transaction Type for Tax Processing	DFMCA_RETURN	TRANSACTION_TYPE
IN_CHANNEL	Communication Channel	DFMCA_RETURN	IN_CHANNEL
TAX_PREPARER	Tax Adviser	DFMCA_RETURN	TAX_PREPARER
FBSTA	System Status of a Form Bundle	DFMCA_RETURN	FBSTA
FBSTB	System Status of a Form Bundle	DFMCA_RETURN	FBSTB
FBUST	User Status of a Form Bundle	DFMCA_RETURN	FBUST