SAP ABAP Table CRMT_BUAG_CLEANSING (Business Agreement: Struct. for Data Cleansing (GET_DETAILS))
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-MD-BP-BAG (Application Component) Business Agreements
⤷ CRM_BUPA_FRG0130 (Package) CRM Business Agreements for Business Partner
⤷ CRM-MD-BP-BAG (Application Component) Business Agreements
⤷ CRM_BUPA_FRG0130 (Package) CRM Business Agreements for Business Partner
Basic Data
Table Category | INTTAB | Structure |
Structure | CRMT_BUAG_CLEANSING | Table Relationship Diagram |
Short Description | Business Agreement: Struct. for Data Cleansing (GET_DETAILS) |
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 | .INCLUDE | 0 | 0 | Specific Data on Business Agreement | |||||
2 | BUAG_TEXT | CRMT_BUAG_TEXT | CHAR30LOW | CHAR | 30 | 0 | Text for Business Agreement | ||
3 | BUAG_DEFAULT | CRMT_BUAG_DEFAULT | CRMT_BUAG_DEFAULT | CHAR | 1 | 0 | Standard Business Agreement | ||
4 | BUAG_CLASS | CRMT_BUAG_CLASS | CRMT_BUAG_CLASS | CHAR | 10 | 0 | Business Agreement Class | CRMC_BUAG_CLASS | |
5 | ADDR_NO | AD_ADDRNUM | AD_ADDRNUM | CHAR | 10 | 0 | Address number | * | |
6 | REF_NUMBER | CRMT_BUAG_REF_NUMBER | CHAR25 | CHAR | 25 | 0 | Reference Number of Business Agreement | ||
7 | BANK_INC | CRMT_BUAG_BDID_IN | CHAR04 | CHAR | 4 | 0 | Bank Details ID for Incoming Payments | ||
8 | BANK_OUTG | CRMT_BUAG_BDID_OUT | CHAR04 | CHAR | 4 | 0 | Bank details ID for outgoing payments | ||
9 | CREDIT_CARD_INC | CRMT_BUAG_CCARD_IN | CHAR6 | CHAR | 6 | 0 | Payment Card ID for Incoming Payments | ||
10 | CREDIT_CARD_OUTG | CRMT_BUAG_CCARD_OUT | CHAR6 | CHAR | 6 | 0 | Payment Card ID for Outgoing Payments | ||
11 | PAYER_BUAG_ID | CRMT_BUAG_ID_PAYER | CRMT_BUAG_ID | CHAR | 12 | 0 | Number of the Payer Business Agreement | ||
12 | ADDR_DR | CRMT_BUAG_ADDRDUNN | AD_ADDRNUM | CHAR | 10 | 0 | Address Number for Alternative Dunning Recipient | * | |
13 | ADDR_PY | CRMT_BUAG_ADDRPAYER | AD_ADDRNUM | CHAR | 10 | 0 | Address Number for Alternative Payer | * | |
14 | ADDR_PR | CRMT_BUAG_ADDRPAYREC | AD_ADDRNUM | CHAR | 10 | 0 | Address Number for alternative Payee | * | |
15 | ADDR_IR | CRMT_BUAG_ADDRINVREC | AD_ADDRNUM | CHAR | 10 | 0 | Address Number for Alternative Invoice Recipient | * | |
16 | ADDR_TAX | CRMT_BUAG_ADDRTAX | AD_ADDRNUM | CHAR | 10 | 0 | Address Number of the Tax-Relevant Address | * | |
17 | TAX_CATEGORY | CRMT_BUAG_TAXCAT | CRMT_BUAG_TAXCAT | CHAR | 2 | 0 | Tax Type | * | |
18 | TAX_CODE | CRMT_BUAG_TAXCODE | CRMT_BUAG_TAXCODE | CHAR | 2 | 0 | Tax Characteristic | * | |
19 | DIRECT_DEBIT_AMOUNT | CRMT_BUAG_DD_AMOUNT_BAPI | BAPICURR | DEC | 23 | 4 | Direct Debit Limit (BAPI Format) | ||
20 | DIRECT_DEBIT_CURRENCY | CRMT_BUAG_DD_CURRENCY | WAERS | CUKY | 5 | 0 | Currency of Direct Debit Limit | * | |
21 | DIRECT_DEBIT_CURRENCY_ISO | CRMT_BUAG_DD_CURRENCY_ISO | ISOCD | CHAR | 3 | 0 | Currency of Direct Debit Limit (ISO Format) | ||
22 | DIRECT_DEBIT_MONTHS | CRMT_BUAG_DD_MONTHS | NUM02 | NUMC | 2 | 0 | Number of Months for Calculation of Direct Debit Limit | ||
23 | DIRECT_DEBIT_ROLLING | CRMT_BUAG_DD_ROLLING | XFELD | CHAR | 1 | 0 | Indicator: Rolling Calculation of Direct Debit Limit | ||
24 | BUAG_DELETION_FLAG | CRMT_BUAG_DELETION_FLAG | CRMT_BUAG_DELETION_FLAG | CHAR | 1 | 0 | Deletion Indicator for Business Agreement | ||
25 | BUAG_TEXT35 | CRMT_BUAG_TEXT35 | CRMT_BUAG_TEXT35 | CHAR | 35 | 0 | Text for Business Agreement (length 35) | ||
26 | BUAG_IS_COLL_BILL | CRMT_BUAG_IS_COLL_BILL | CRMT_BUAG_IS_COLL_BILL | CHAR | 1 | 0 | Indicator: Business Agreement is usable for Collective Bills | ||
27 | COLL_BILL_BUAG_ID | CRMT_BUAG_ID_COLL_BILL | CRMT_BUAG_ID | CHAR | 12 | 0 | Alternative Business Agreement Number for Collective Bills | ||
28 | PPACC_RELATION | CRMT_ISX_PA_RELATION | CRM_ISX_PA_RELATION | CHAR | 1 | 0 | Business Agreement: Prepaid Account Relation | ||
29 | SEPA_MNDID | CRMT_BUAG_SEPA_MNDID | CRMT_BUAG_SEPA_MNDID | CHAR | 35 | 0 | Unique Reference to Mandate per Payment Recipient | ||
30 | BUAG_ID_LEGACY | CRMT_BUAG_ID_LEGACY | CHAR20 | CHAR | 20 | 0 | Business Agreement Number in Legacy System | ||
31 | .INCLUDE | 0 | 0 | General Data on Business Agreement | |||||
32 | BABR_TEXT | CRMT_BABR_TEXT | CHAR | 30 | 0 | Description of the Business Agreement (General Part) | |||
33 | METHOD_INC | CRMT_BUAG_PAYMETH_IN | CRM_BUAG_PAYMETH | CHAR | 1 | 0 | Incoming Payment Method | * | |
34 | METHOD_OUTG | CRMT_BUAG_PAYMETH_OUT | CHAR5 | CHAR | 5 | 0 | Outgoing Payment Method | ||
35 | SENDCONTROL_DR | CRMT_BUAG_SNDCTRL_DR | CRMT_BUAG_SENDCONTROL | CHAR | 4 | 0 | Shipping Control for Alternative Dunning Recipient | * | |
36 | TOFPAYM | CRMT_PMNTTRMS | CRM_PMNTTRMS | CHAR | 4 | 0 | Terms of Payment | CRMC_PMNTTRMS | |
37 | SENDCONTROL_BR | CRMT_BUAG_SNDCTRL_BR | CRMT_BUAG_SENDCONTROL | CHAR | 4 | 0 | Shipping Control for Alternative Payer | * | |
38 | CORRESP_VARIANT | CRMT_BUAG_CORRESPONDENCE_VAR | CRMT_BUAG_CORRESPONDENCE_VAR | CHAR | 5 | 0 | Correspondence Variant | * | |
39 | SENDCONTROL_BP | CRMT_BUAG_SNDCTRL_BP | CRMT_BUAG_SENDCONTROL | CHAR | 4 | 0 | Shipping Control for Business Partner | * | |
40 | .INCLUDE | 0 | 0 | Business Agreement: All Partner Functions | |||||
41 | ALTERNATIVE_PAYER | CRMT_BUAG_PF_ALTERNATIVE_PAYER | BU_PARTNER | CHAR | 10 | 0 | Alternative Payer | * | |
42 | BILL_TO_PARTY | CRMT_BUAG_PF_BILL_TO_PARTY | BU_PARTNER | CHAR | 10 | 0 | Bill-To Party | * | |
43 | CORRESP_RECIPIENT | CRMT_BUAG_PF_CORRESP_RECIPIENT | BU_PARTNER | CHAR | 10 | 0 | Correspondence Recipient | * | |
44 | DUNNING_RECIPIENT | CRMT_BUAG_PF_DUNNING_RECIPIENT | BU_PARTNER | CHAR | 10 | 0 | Dunning Recipient | * | |
45 | PAYEE | CRMT_BUAG_PF_PAYEE | BU_PARTNER | CHAR | 10 | 0 | Payment Recipient | * | |
46 | PAYER | CRMT_BUAG_PF_PAYER | BU_PARTNER | CHAR | 10 | 0 | Payer | * |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | CRMT_BUAG_CLEANSING | BUAG_CLASS | CRMC_BUAG_CLASS | BUAG_CLASS | |||
2 | CRMT_BUAG_CLEANSING | TOFPAYM | CRMC_PMNTTRMS | PAYMENT_TERMS |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in | 400 |