SAP ABAP Table CRM_BILLING_MANDATE_VH (Value help structure for SEPA mandates in CRM BTX)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-SLO (Application Component) Sales Transaction
     ⤷ CRM_UIU_BT_SALES_ORDER (Package) UIU: Sales Orders

Basic Data

Table Category	INTTAB	Structure
Structure	CRM_BILLING_MANDATE_VH	Table Relationship Diagram
Short Description	Value help structure for SEPA mandates in CRM BTX

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MNDID	☐	SEPA_MNDID	ID035	CHAR	35	0	Unique Referene to Mandate per Payment Recipient
2	VAL_FROM_DATE	☐	SEPA_VAL_FROM_DATE	DATUM	DATS	8	0	SEPA: Validity Date of Mandate (From)
3	VAL_TO_DATE	☐	SEPA_VAL_TO_DATE	DATUM	DATS	8	0	SEPA: Validity Date of Mandate (To)
4	SIGN_CITY	☐	SEPA_SIGN_CITY	TEXT40	CHAR	40	0	Location of Signature
5	SIGN_DATE	☐	SEPA_SIGN_DATE	DATUM	DATS	8	0	Date of Signature
6	STATUS	☐	SEPA_STATUS	SEPA_STATUS	CHAR	1	0	SEPA: Mandate Status
7	ERNAM	☐	SEPA_ERNAM	SYCHAR12	CHAR	12	0	User who Created the Current Version of the Mandate
8	ERDAT	☐	SEPA_ERDAT	DATUM	DATS	8	0	Date on Which the Current Mandate Version was Created
9	ERTIM	☐	SEPA_ERTIM	UZEIT	TIMS	6	0	Time at Which the Current Mandate Version was Created
10	ORIGIN_REC_CRDID	☐	SEPA_CRDID_ORIGIN	ID035	CHAR	35	0	SEPA Mandate: Original Creditor ID of Mandate
11	SND_ID	☐	SEPA_SND_ID	SWO_TYPEID	CHAR	70	0	SEPA Mandate: Sender ID
12	SND_NAME1	☐	BU_NAMEP_L	BU_NAME	CHAR	40	0	Last name of business partner (person)
13	SND_NAME2	☐	BU_NAMEP_F	BU_NAME	CHAR	40	0	First name of business partner (person)
14	REC_ID_CRDID	☐	SEPA_ID_CRDID	ID035	CHAR	35	0	Creditor ID Without Business Code

History

Last changed by/on	SAP	20130604
SAP Release Created in	713