SAP Table MCASSOC

GTM: Communication Structure Association

MCASSOC (GTM: Communication Structure Association) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link MCASSOC to other SAP tables.

MCASSOC table fields

Field

Data element

Checktable

Datatype

Length

Decimals

SUPKZ

Statistics update indicator (post in/post out)

SUPKZ

CHAR

Possible values

1	Old status: charge off (negative posting)
2	New status: record
3	Standard item in a return (SD only)
0	Returns item in standard order (SD only)

MANDT

Client

MANDT

T000

CLNT

TEW_TYPE

Trading Execution Workbench Type

WB2_TEW_TYPE

TEWTYPE

CHAR

ASSOC_STEP_FROM

Association Mngt: Process Step That Contains An Association

WB2_ASSOC_STEP_FROM

TEWSTEP

CHAR

RNUMBER

Assoc. Mngt: Number of Document to Which Doc. is Assigned

WB2_RECEIVING_NUMBER

CHAR

RPOSNR

Assoc. Mngt: Item No. of Document to Which Doc.is Assigned

WB2_RECEIVING_POSNR

CHAR

RPOSNR_SUB

Assoc. Mngt: Sub-Item No. of Doc. to Which Doc. is Assigned

WB2_RECEIVING_POSNR_SUB

NUMC

ASSOC_STEP_TO

Association Management: Process Step That is Associated

WB2_ASSOC_STEP_TO

TEWSTEP

CHAR

ANUMBER

Assoc. Mngt: Number of a Document that is Assigned

WB2_ASSOCIATED_NUMBER

CHAR

APOSNR

Assoc. Mngt: Item No. of a Doc. that is Assigned to a Doc.

WB2_ASSOCIATED_POSNR

CHAR

APOSNR_SUB

Assoc. Mngt: Sub-Item No. of Doc. That is Assigned to Doc.

WB2_ASSOCIATED_POSNR_SUB

NUMC

REC_BASE

Assoc. Mngt: Basis for Receiving Document

WB2_RECEIVING_BASE

CHAR

Possible values

MM	Purchasing Side
SD	Sales Side

BAS_DOCTYPE_REC

Document Type

WB2_DOC_TYPE

CHAR

Possible values

A	Sales Order
B	Contract (SD)
C	Purchase Order
D	Delivery
E	Inbound Delivery
F	Vendor Billing Document
G	Goods Receipt
H	Invoice Verification
I	Accounting Document
J	Settlement Requests
K	Invoice
L	Goods Issue
M	Picking
N	Contract (MM)
O	RFQ (MM)
P	Scheduling Agreement (MM)
Q	Trading Contract
*	All Document Categories
K1	Credit memo
K2	Debit memo
A1	Credit Memo Request
A2	Debit Memo Request
J1	Settlement Request List
J2	Posting List
J3	Remuneration List
A3	RFQ/Inquiry
A4	Quotation
A5	Scheduling Agreement (SD)
A6	Returns
K3	Invoice Reversal
K4	Credit Memo Reversal
E1	Return Delivery for Order
K5	Pro Forma Invoice
A7	Independent Requirements Plan
K6	Invoice List
K7	Credit Memo List
K8	Internal Settlement, Invoice
K9	Internal Settlement, Credit Memo
L1	Goods Movement
S1	Held Goods Reciept Document (Purchase Order)
S2	Held Goods Reciept Document (Inb. Delivery)
1	Pricing Document (Internal)
Q1	Sales-Side Trading Contract (Only WBGT Entries for BW)
Z1	For cust.enhancements
Z2	For cust.enhancements
Z3	For cust.enhancements
Z4	For cust.enhancements
Z5	For cust.enhancements
Z6	For cust.enhancements
Z7	For cust.enhancements
Z8	For cust.enhancements
Z9	For cust.enhancements
Z0	For cust.enhancements
ZA	For cust.enhancements
ZB	For cust.enhancements
ZC	For cust.enhancements
ZD	For cust.enhancements
ZE	For cust.enhancements
ZF	For cust.enhancements
ZG	For cust.enhancements
ZH	For cust.enhancements
ZI	For cust.enhancements
ZJ	For cust.enhancements
ZK	For cust.enhancements
ZL	For cust.enhancements
ZM	For cust.enhancements
ZN	For cust.enhancements
ZO	For cust.enhancements
ZP	For cust.enhancements
ZQ	For cust.enhancements
ZR	For cust.enhancements
ZS	For cust.enhancements
ZT	For cust.enhancements
ZU	For cust.enhancements
ZV	For cust.enhancements
ZW	For cust.enhancements
ZX	For cust.enhancements
ZY	For cust.enhancements
ZZ	For cust.enhancements
##	Not used and is not written to database
T	Forward Exchange Transaction
XX	Undefined Document Type
R	Nomination
U1	Handling Unit
V1	Difference Calculation
SH	shadow
W	Period End Valuation: Invoice
W1	Period End Valuation: Credit Memo
W3	Period End Valuation: Invoice Reversal
W4	Period End Valuation: Credit Memo Reversal
W8	Period End Valuation: Intercompany invoice
W9	Period End Valuation: Intercompany credit memo

BAS_DOCNR_REC

Assoc. Mngt: Base Document Receiving Associations

WB2_BASE_DOCUMENT_RECEIVING

CHAR

BAS_ITEM_REC

Assoc. Mngt: Item Number in Base Document

WB2_BASE_ITEM

NUMC

BAS_S_ITEM_REC

Assoc. Mngt: Sub-Item Number in Base Document

WB2_BASE_SUB_ITEM

NUMC

PORTFOLIO_REC

Global Trade: (Internal) Portfolio Number

WB2_PORTFOLIO

KONHM

CHAR

RMATNR

Material Number

MATNR

MARA

CHAR

BAS_DOCTYPE_ASSO

Document Type

WB2_DOC_TYPE

CHAR

Possible values

A	Sales Order
B	Contract (SD)
C	Purchase Order
D	Delivery
E	Inbound Delivery
F	Vendor Billing Document
G	Goods Receipt
H	Invoice Verification
I	Accounting Document
J	Settlement Requests
K	Invoice
L	Goods Issue
M	Picking
N	Contract (MM)
O	RFQ (MM)
P	Scheduling Agreement (MM)
Q	Trading Contract
*	All Document Categories
K1	Credit memo
K2	Debit memo
A1	Credit Memo Request
A2	Debit Memo Request
J1	Settlement Request List
J2	Posting List
J3	Remuneration List
A3	RFQ/Inquiry
A4	Quotation
A5	Scheduling Agreement (SD)
A6	Returns
K3	Invoice Reversal
K4	Credit Memo Reversal
E1	Return Delivery for Order
K5	Pro Forma Invoice
A7	Independent Requirements Plan
K6	Invoice List
K7	Credit Memo List
K8	Internal Settlement, Invoice
K9	Internal Settlement, Credit Memo
L1	Goods Movement
S1	Held Goods Reciept Document (Purchase Order)
S2	Held Goods Reciept Document (Inb. Delivery)
1	Pricing Document (Internal)
Q1	Sales-Side Trading Contract (Only WBGT Entries for BW)
Z1	For cust.enhancements
Z2	For cust.enhancements
Z3	For cust.enhancements
Z4	For cust.enhancements
Z5	For cust.enhancements
Z6	For cust.enhancements
Z7	For cust.enhancements
Z8	For cust.enhancements
Z9	For cust.enhancements
Z0	For cust.enhancements
ZA	For cust.enhancements
ZB	For cust.enhancements
ZC	For cust.enhancements
ZD	For cust.enhancements
ZE	For cust.enhancements
ZF	For cust.enhancements
ZG	For cust.enhancements
ZH	For cust.enhancements
ZI	For cust.enhancements
ZJ	For cust.enhancements
ZK	For cust.enhancements
ZL	For cust.enhancements
ZM	For cust.enhancements
ZN	For cust.enhancements
ZO	For cust.enhancements
ZP	For cust.enhancements
ZQ	For cust.enhancements
ZR	For cust.enhancements
ZS	For cust.enhancements
ZT	For cust.enhancements
ZU	For cust.enhancements
ZV	For cust.enhancements
ZW	For cust.enhancements
ZX	For cust.enhancements
ZY	For cust.enhancements
ZZ	For cust.enhancements
##	Not used and is not written to database
T	Forward Exchange Transaction
XX	Undefined Document Type
R	Nomination
U1	Handling Unit
V1	Difference Calculation
SH	shadow
W	Period End Valuation: Invoice
W1	Period End Valuation: Credit Memo
W3	Period End Valuation: Invoice Reversal
W4	Period End Valuation: Credit Memo Reversal
W8	Period End Valuation: Intercompany invoice
W9	Period End Valuation: Intercompany credit memo

BAS_DOCNR_ASSO

Assoc. Mngt: Base Document That is Associated

WB2_BASE_DOCUMENT_ASSOCIATED

CHAR

BAS_ITEM_ASSO

Assoc. Mngt: Item Number in Base Document

WB2_BASE_ITEM

NUMC

BAS_S_ITEM_ASSO

Assoc. Mngt: Sub-Item Number in Base Document

WB2_BASE_SUB_ITEM

NUMC

PORTFOLIO_ASSOC

Global Trade: (Internal) Portfolio Number

WB2_PORTFOLIO

KONHM

CHAR

AMATNR

Material Number

MATNR

MARA

CHAR

UNIT_OF_QUAN

Association Management: Association Unit of Measure

WB2_ASSO_UNIT

T006

UNIT

ASSOC_QUAN_ORIG

Assoc. Mngt: Originally Associated Quantity of an Item

WB2_ASSOC_QUAN_ORIG

QUAN

ASSOC_QUAN

Assoc. Mngt: Actually Associated Quantity of an Item

WB2_ASSOCIATED_QUAN

QUAN

LOCKED_QUAN

Assoc. Mngt: Locked Quantity

WB2_LOCKED_QUAN

QUAN

LOCK_FLAG

Assoc. Mngt: Flag for Locked Quantity

WB2_LOCK_FLAG

CHAR

Possible values

X	TRUE
NULL	FALSE

LOCK_REASON

Assoc. Mngt: Lock Reason

WB2_ASS_LOCK_REASON

CHAR

COMPLETED

Assoc. Mngt: Indicates Whether Asc.Qty is Transferred inFull

WB2_ASSOC_TRANSFER_COMPLETED

CHAR

Possible values

X	TRUE
NULL	FALSE

DOC_TYPE_FROM

Assoc. Mngt: Document Category Receiving Association

WB2_ASSOC_DOC_TYPE_FROM

CHAR

Possible values

A	Sales Order
B	Contract (SD)
C	Purchase Order
D	Delivery
E	Inbound Delivery
F	Vendor Billing Document
G	Goods Receipt
H	Invoice Verification
I	Accounting Document
J	Settlement Requests
K	Invoice
L	Goods Issue
M	Picking
N	Contract (MM)
O	RFQ (MM)
P	Scheduling Agreement (MM)
Q	Trading Contract
*	All Document Categories
K1	Credit memo
K2	Debit memo
A1	Credit Memo Request
A2	Debit Memo Request
J1	Settlement Request List
J2	Posting List
J3	Remuneration List
A3	RFQ/Inquiry
A4	Quotation
A5	Scheduling Agreement (SD)
A6	Returns
K3	Invoice Reversal
K4	Credit Memo Reversal
E1	Return Delivery for Order
K5	Pro Forma Invoice
A7	Independent Requirements Plan
K6	Invoice List
K7	Credit Memo List
K8	Internal Settlement, Invoice
K9	Internal Settlement, Credit Memo
L1	Goods Movement
S1	Held Goods Reciept Document (Purchase Order)
S2	Held Goods Reciept Document (Inb. Delivery)
1	Pricing Document (Internal)
Q1	Sales-Side Trading Contract (Only WBGT Entries for BW)
Z1	For cust.enhancements
Z2	For cust.enhancements
Z3	For cust.enhancements
Z4	For cust.enhancements
Z5	For cust.enhancements
Z6	For cust.enhancements
Z7	For cust.enhancements
Z8	For cust.enhancements
Z9	For cust.enhancements
Z0	For cust.enhancements
ZA	For cust.enhancements
ZB	For cust.enhancements
ZC	For cust.enhancements
ZD	For cust.enhancements
ZE	For cust.enhancements
ZF	For cust.enhancements
ZG	For cust.enhancements
ZH	For cust.enhancements
ZI	For cust.enhancements
ZJ	For cust.enhancements
ZK	For cust.enhancements
ZL	For cust.enhancements
ZM	For cust.enhancements
ZN	For cust.enhancements
ZO	For cust.enhancements
ZP	For cust.enhancements
ZQ	For cust.enhancements
ZR	For cust.enhancements
ZS	For cust.enhancements
ZT	For cust.enhancements
ZU	For cust.enhancements
ZV	For cust.enhancements
ZW	For cust.enhancements
ZX	For cust.enhancements
ZY	For cust.enhancements
ZZ	For cust.enhancements
##	Not used and is not written to database
T	Forward Exchange Transaction
XX	Undefined Document Type
R	Nomination
U1	Handling Unit
V1	Difference Calculation
SH	shadow
W	Period End Valuation: Invoice
W1	Period End Valuation: Credit Memo
W3	Period End Valuation: Invoice Reversal
W4	Period End Valuation: Credit Memo Reversal
W8	Period End Valuation: Intercompany invoice
W9	Period End Valuation: Intercompany credit memo

DOC_TYPE_TO

Assoc. Mngt: Document Category That Is Associated

WB2_ASSOC_DOC_TYPE_TO

CHAR

Possible values

A	Sales Order
B	Contract (SD)
C	Purchase Order
D	Delivery
E	Inbound Delivery
F	Vendor Billing Document
G	Goods Receipt
H	Invoice Verification
I	Accounting Document
J	Settlement Requests
K	Invoice
L	Goods Issue
M	Picking
N	Contract (MM)
O	RFQ (MM)
P	Scheduling Agreement (MM)
Q	Trading Contract
*	All Document Categories
K1	Credit memo
K2	Debit memo
A1	Credit Memo Request
A2	Debit Memo Request
J1	Settlement Request List
J2	Posting List
J3	Remuneration List
A3	RFQ/Inquiry
A4	Quotation
A5	Scheduling Agreement (SD)
A6	Returns
K3	Invoice Reversal
K4	Credit Memo Reversal
E1	Return Delivery for Order
K5	Pro Forma Invoice
A7	Independent Requirements Plan
K6	Invoice List
K7	Credit Memo List
K8	Internal Settlement, Invoice
K9	Internal Settlement, Credit Memo
L1	Goods Movement
S1	Held Goods Reciept Document (Purchase Order)
S2	Held Goods Reciept Document (Inb. Delivery)
1	Pricing Document (Internal)
Q1	Sales-Side Trading Contract (Only WBGT Entries for BW)
Z1	For cust.enhancements
Z2	For cust.enhancements
Z3	For cust.enhancements
Z4	For cust.enhancements
Z5	For cust.enhancements
Z6	For cust.enhancements
Z7	For cust.enhancements
Z8	For cust.enhancements
Z9	For cust.enhancements
Z0	For cust.enhancements
ZA	For cust.enhancements
ZB	For cust.enhancements
ZC	For cust.enhancements
ZD	For cust.enhancements
ZE	For cust.enhancements
ZF	For cust.enhancements
ZG	For cust.enhancements
ZH	For cust.enhancements
ZI	For cust.enhancements
ZJ	For cust.enhancements
ZK	For cust.enhancements
ZL	For cust.enhancements
ZM	For cust.enhancements
ZN	For cust.enhancements
ZO	For cust.enhancements
ZP	For cust.enhancements
ZQ	For cust.enhancements
ZR	For cust.enhancements
ZS	For cust.enhancements
ZT	For cust.enhancements
ZU	For cust.enhancements
ZV	For cust.enhancements
ZW	For cust.enhancements
ZX	For cust.enhancements
ZY	For cust.enhancements
ZZ	For cust.enhancements
##	Not used and is not written to database
T	Forward Exchange Transaction
XX	Undefined Document Type
R	Nomination
U1	Handling Unit
V1	Difference Calculation
SH	shadow
W	Period End Valuation: Invoice
W1	Period End Valuation: Credit Memo
W3	Period End Valuation: Invoice Reversal
W4	Period End Valuation: Credit Memo Reversal
W8	Period End Valuation: Intercompany invoice
W9	Period End Valuation: Intercompany credit memo

STATUS

Assoc. Mngt: Association Status, Only Needed Internally

WB2_ASSO_STATUS

CHAR

Possible values

NULL	Always Available
X	Only Available Temporarily
C	Cross-Referenced
V	Only cross-referenced and available temporarily

CHARG_ASSO

Assoc. Management: Batch Number of Associated Item

WB2_ASSO_CHARG

CHAR

CHARG_REC

Assoc. Mngt: Batch Number of Item Receiving Association

WB2_REC_CHARG

CHAR

PRED_STEP_FROM

Association Mngt: Process Step That Contains An Association

WB2_ASSOC_STEP_FROM

CHAR

PRED_STEP_TO

Association Management: Process Step That is Associated

WB2_ASSOC_STEP_TO

CHAR

PRED_QUAN_FROM

Assoc. Mngt: Quantity Transferred from Preceding Association

WB2_TRANSFERRED_QUANTITY

QUAN

PRED_QUAN_TO

Assoc. Mngt: Quantity Transferred from Preceding Association

WB2_TRANSFERRED_QUANTITY

QUAN

ERDAT

Date on Which Record Was Created

ERDAT

DATS

ERNAM

Name of Person who Created the Object

ERNAM

CHAR

IGNORE_ASSO

Association Management: Ignore Active Association Quantity?

WB2_IGNORE_ACTIVE_ASSOC_QUAN

CHAR

Possible values

NULL	Active Association Quantity Is Included
X	Active Association Quantity Is Ignored

UPDKZ

Update indicator

UPDKZ_D

CHAR

GJAHR_TO

Fiscal Year

GJAHR

NUMC

UPDAS

Update indicator

UPDKZ_D

CHAR

MCASSOC foreign key relationships

Table	Field	Foreign key table	Foreign key field	Check table		Check field
MCASSOC	AMATNR	MCASSOC	MANDT	MARA	General Material Data	MANDT
MCASSOC	AMATNR	MCASSOC	AMATNR	MARA	General Material Data	MATNR
MCASSOC	ASSOC_STEP_FROM	MCASSOC	TEW_TYPE	TEWSTEP	Business Process Step	TEW_TYPE
MCASSOC	ASSOC_STEP_FROM	MCASSOC	ASSOC_STEP_FROM	TEWSTEP	Business Process Step	STEP
MCASSOC	ASSOC_STEP_FROM	MCASSOC	MANDT	TEWSTEP	Business Process Step	MANDT
MCASSOC	ASSOC_STEP_TO	MCASSOC	MANDT	TEWSTEP	Business Process Step	MANDT
MCASSOC	ASSOC_STEP_TO	MCASSOC	TEW_TYPE	TEWSTEP	Business Process Step	TEW_TYPE
MCASSOC	ASSOC_STEP_TO	MCASSOC	ASSOC_STEP_TO	TEWSTEP	Business Process Step	STEP
MCASSOC	MANDT	MCASSOC	MANDT	T000	Clients	MANDT
MCASSOC	PORTFOLIO_ASSOC	MCASSOC	PORTFOLIO_ASSOC	KONHM	Portfolio Determination - Data Part	KNUMH
MCASSOC	PORTFOLIO_ASSOC	MCASSOC	MANDT	KONHM	Portfolio Determination - Data Part	MANDT
MCASSOC	PORTFOLIO_REC	MCASSOC	MANDT	KONHM	Portfolio Determination - Data Part	MANDT
MCASSOC	PORTFOLIO_REC	MCASSOC	PORTFOLIO_REC	KONHM	Portfolio Determination - Data Part	KNUMH
MCASSOC	RMATNR	MCASSOC	MANDT	MARA	General Material Data	MANDT
MCASSOC	RMATNR	MCASSOC	RMATNR	MARA	General Material Data	MATNR
MCASSOC	TEW_TYPE	MCASSOC	MANDT	TEWTYPE	Trading Execution Workbench Type	MANDT
MCASSOC	TEW_TYPE	MCASSOC	TEW_TYPE	TEWTYPE	Trading Execution Workbench Type	TEW_TYPE
MCASSOC	UNIT_OF_QUAN	MCASSOC	MANDT	T006	Units of Measurement	MANDT
MCASSOC	UNIT_OF_QUAN	MCASSOC	UNIT_OF_QUAN	T006	Units of Measurement	MSEHI