Form Data for SVA1 (TRM) - Example

DataSource Transactional Data: 3PSCD_TRM_FORM_DATA_SVA1

This is an example we deliver to show how a DataSource that loads form data for a scenario could look like. Our example is used for our scenario SVA1 (Tax on Sales/Purchases) which is included in our sample content for Tax and Revenue Management (TRM). For other scenarios you have to create your own DataSource. For more information, see the documentation for Customizing activity Generate DataSource for ISR Forms that you can find in Customizing for Contract Accounts Receivable and Payable.

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 Tax and Revenue Management incl. Withholding Tax
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- Images with Deletion Flag via Delta Queue delta update process.

Note Note

If you want to use delta extraction for this DataSource, that is 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.

The Fields of Origin for the Extract Structure table stated below is not complete as it does not contain all form fields. To obtain a complete list, use transaction code rsa2, enter DataSource 3PSCD_TRM_FORM_DATA_SVA1 navigate to the Extract tab and double-click the FMCA_FPF_FORM_DATA_SVA1_BI extract structure.

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
RETURN_ID	Technical Key of Carrying Object	DFMCA_FORMS	RETURN_ID
FORM	Form for ISR Scenario	DFMCA_FORMS	FORM
FORM_NUMBER	Form Number	DFMCA_FORMS	FORM_NUMBER
CASE_GUID	Technical Key of Form	DFMCA_FORMS	CASE_GUID
TIMESTAMP	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	DFMCA_FORMS	TIMESTAMP
FORM_CLASS	Form Class	DFMCA_FORMS	FORM_CLASS
FORM_STATUS	Form Status		FORM_STATUS
FORM_STATUS_TS	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	DFMCA_FORMS	FORM_STATUS_TS
SUPERSEDED_BY	Technical Key of Form	DFMCA_FORMS	SUPERSEDED_BY
SUPERSEDE_TO	Technical Key of Form	DFMCA_FORMS	SUPERSEDE_TO
RECEIPT_TS	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)		RECEIPT_TS
TEMPLATE_VER	Form Template Version	DFMCA_FORMS	TEMPLATE_VER
BATCH_ID	Identification Number of Lot	DFMCA_FORMS	BATCH_ID
LOCATOR_NUMBER	Identification of Storage Location of Document	DFMCA_FORMS	LOCATOR_NUMBER
FBTYP	Form Bundle Type	DFMCA_RETURN	FBTYP
FBNUM	Number of a Form Bundle	DFMCA_RETURN	FBNUM
RECORDMODE	BW Delta Process: Record Mode
A_2F01_REGISTRA	Identification Key for Contract Object
A_2F02_PERIOD	Key for Period Assignment