BKKPOMND

Payment order Enriched with Mandate details | #transactional | Component: Payment Order
Column Name Description
MANDT Client
PO_MGUID SEPA Mandate: GUID of Mandate
PO_MVERS Version of Mandate used for Enrichment
Column Name Description
Column Name Description
Column Name Description
SIGN_DATE Date of Signature
VAL_FROM_DATE SEPA: Validity Date of Mandate (From)
VAL_TO_DATE SEPA: Validity Date of Mandate (To)
ERDAT Date on Which the Current Mandate Version was Created
ERTIM Time at Which the Current Mandate Version was Created
GLOCK_VAL_FROM Global Mandate Lock - Valid From
GLOCK_VAL_TO Global Mandate Lock - Valid Until
ORI_ERDAT Date on Which Original Mandate Created
ORI_ERTIM Time when Original Mandate Was Created
CREATE_DAT Date on which the object was created
CREATE_TIM Time at which the object was created
CHANGE_DAT Date on which the object was last changed
CHANGE_TIM Time at Which Object was Last Changed
Column Name Description
PAY_TYPE SEPA: Payment Type Show values
STATUS SEPA: Mandate Status Show values
B2B SEPA-Mandate: B2B Mandate Show values
CHG_REASON SEPA: Reason for Change Show values
GLOCK Global Lock Set in Mandate Show values
MAND_TYPE Mandate Type Show values
MAND_FREQ Mandate Frequency Show values
Column Name Description Domain name
MNDID Unique Reference to Mandate for each Payee ID035
SIGN_CITY Location of Signature TEXT40
ERNAM User who Created the Current Version of the Mandate SYCHAR12
ORIGIN Single-Character Flag CHAR1
ORIGIN_REC_CRDID SEPA Mandate: Original Creditor ID of Mandate ID035
ORIGIN_MNDID SEPA Mandate: Original Mandate of Mandate ID035
ANWND SEPA: Application for Which Mandate Relevant SEPA_ANWND
ORI_ERNAM User who Created the Original Mandate SYCHAR12
SND_TYPE SEPA Mandate: Sender Type OJ_NAME
SND_ID SEPA Mandate: Sender ID SWO_TYPEID
SND_NAME1 Last name of business partner (person) BU_NAME
SND_NAME2 First name of business partner (person) BU_NAME
SND_STREET Street TEXT60
SND_HOUSENUM House Number TEXT10
SND_POSTAL City postal code CHAR10
SND_CITY City TEXT40
SND_IBAN IBAN (International Bank Account Number) IBAN
SND_BIC SWIFT/BIC for International Payments SWIFT
SND_DIR_NAME SEPA: Name of Alternative Debtor BU_NAME
SND_DIR_ID SEPA: ID of Alternative Debtor SWO_TYPEID
SND_DEBTOR_ID SEPA: ID Number of Sender (External Reference) ID035
REC_TYPE SEPA Mandate: Recipient Type OJ_NAME
REC_ID SEPA Mandate: Recipient ID SWO_TYPEID
REC_NAME1 Name 1 of organization BU_NAME
REC_NAME2 Name 2 of organization BU_NAME
REC_CRDID Creditor Identification Number ID035
REC_STREET Street TEXT60
REC_HOUSENUM House Number TEXT10
REC_POSTAL City postal code CHAR10
REC_CITY City TEXT40
REC_DIR_NAME SEPA: Name of Alternative Payee BU_NAME
REC_DIR_ID SEPA: ID of Alternative Payee SWO_TYPEID
CREATE_USR User who created the object USNAM
CHANGE_USR Last user to change object USNAM
REC_CRDID_OLD Creditor Identification Number ID035
REC_NAME1_OLD Name 1 of organization BU_NAME
REC_NAME2_OLD Name 2 of organization BU_NAME
SND_IBAN_OLD IBAN (International Bank Account Number) IBAN
SND_BIC_OLD SWIFT/BIC for International Payments SWIFT
Master Data Relations Join Conditions
Reason Code for Status Change
  • SEPA: Mandate Status
  • Client
  • ?
  • Reason Code for Status Change
Country/Region Key
  • Country/Region Key
  • Client
  • BKKPOMND.REC_COUNTRY == T005.LAND1
  • BKKPOMND.MANDT == T005.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • BKKPOMND.SND_COUNTRY == T005.LAND1
  • BKKPOMND.MANDT == T005.MANDT
Language Key BKKPOMND.SND_LANGUAGE == T002.SPRAS