SAP ABAP Table CIFSRCOA (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	CIFSRCOA	Table Relationship Diagram
Short Description	Generated Table for View

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	EBELN	☑	EBELN	EBELN	CHAR	10	0	Purchasing Document Number
3	EBELP	☑	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document
4	BSTYP	☐	EBSTYP	EBSTYP	CHAR	1	0	Purchasing Document Category
5	BSART	☐	ESART	BSART	CHAR	4	0	Purchasing Document Type	T161
6	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
7	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
8	KDATB	☐	KDATB	DATUM	DATS	8	0	Start of Validity Period
9	KDATE	☐	KDATE	DATUM	DATS	8	0	End of Validity Period
10	RESWK	☐	RESWK	WERKS	CHAR	4	0	Supplying (issuing) plant in case of stock transport order	T001W
11	FRGRL	☐	FRGRL	XFELD	CHAR	1	0	Release Not Yet Completely Effected
12	STATU	☐	ESTAK	ESTAK	CHAR	1	0	Status of Purchasing Document
13	LOEKZ	☐	ELOEK	ELOEK	CHAR	1	0	Deletion indicator in purchasing document
14	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
15	WERKS	☐	EWERK	WERKS	CHAR	4	0	Plant	T001W
16	PSTYP	☐	PSTYP	PSTYP	CHAR	1	0	Item category in purchasing document	T163
17	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
18	ELIKZ	☐	ELIKZ	XFELD	CHAR	1	0	"Delivery Completed" Indicator
19	APOMS	☐	APOMS	APOMS	CHAR	1	0	APO as Planning System
20	PLIFZ	☐	EPLIF	DEC3	DEC	3	0	Planned Delivery Time in Days
21	BSTME	☐	BSTME	MEINS	UNIT	3	0	Order unit	T006
22	UMREZ	☐	UMBSZ	UMBSZ	DEC	5	0	Numerator for Conversion of Order Unit to Base Unit
23	UMREN	☐	UMBSN	UMBSN	DEC	5	0	Denominator for Conversion of Order Unit to Base Unit
24	LMEIN	☐	LAGME	MEINS	UNIT	3	0	Base Unit of Measure	T006
25	IDNLF	☐	IDNLF	IDNEX	CHAR	35	0	Material Number Used by Vendor
26	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	T163K
27	KZVBR	☐	KZVBR	KZVBR	CHAR	1	0	Consumption posting
28	ABDAT	☐	ABDAT	DATUM	DATS	8	0	Reconciliation date for agreed cumulative quantity
29	ABFTZ	☐	ABFTZ	MENG13	QUAN	13	3	Agreed Cumulative Quantity
30	ETFZ1	☐	ETFZ1	PACK2	DEC	3	0	Firm Zone (Go-Ahead for Production)
31	ETFZ2	☐	ETFZ2	PACK2	DEC	3	0	Trade-Off Zone (Go-Ahead for Materials Procurement)
32	EMLIF	☐	EMLIF	LIFNR	CHAR	10	0	Vendor to be supplied/who is to receive delivery	LFA1
33	LBLKZ	☐	LBLKZ	XFELD	CHAR	1	0	Subcontracting vendor
34	WEBAZ	☐	WEBAZ	DEC3	DEC	3	0	Goods receipt processing time in days
35	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
36	EKGRP	☐	BKGRP	EKGRP	CHAR	3	0	Purchasing Group	T024
37	UEBTO	☐	UEBTO	PRZ21	DEC	3	1	Overdelivery Tolerance Limit
38	UNTTO	☐	UNTTO	PRZ21	DEC	3	1	Underdelivery Tolerance Limit
39	ZBD1T	☐	DZBDET	ZBDXT	DEC	3	0	Cash (Prompt Payment) Discount Days
40	ZBD2T	☐	DZBDET	ZBDXT	DEC	3	0	Cash (Prompt Payment) Discount Days
41	ZBD3T	☐	DZBDET	ZBDXT	DEC	3	0	Cash (Prompt Payment) Discount Days
42	ZBD1P	☐	DZBD1P	PRZ23	DEC	5	3	Cash discount percentage 1
43	ZBD2P	☐	DZBD2P	PRZ23	DEC	5	3	Cash Discount Percentage 2
44	INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	TINC
45	INCO2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
46	INCO1P	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	TINC
47	INCO2P	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
48	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
49	WEBRE	☐	WEBRE	XFELD	CHAR	1	0	Indicator: GR-Based Invoice Verification
50	XERSY	☐	XERSY	XFELD	CHAR	1	0	Evaluated Receipt Settlement (ERS)
51	SKTOF	☐	ESKTOF	XFELD	CHAR	1	0	Item Does Not Qualify for Cash Discount
52	REPOS	☐	REPOS	XFELD	CHAR	1	0	Invoice receipt indicator
53	NETPR	☐	BPREI	WERT11	CURR	11	2	Net Price in Purchasing Document (in Document Currency)
54	PEINH	☐	EPEIN	DEC5	DEC	5	0	Price unit
55	BPRME	☐	BBPRM	MEINS	UNIT	3	0	Order Price Unit (purchasing)	T006
56	BPUMZ	☐	BPUMZ	UMBSZ	DEC	5	0	Numerator for Conversion of Order Price Unit into Order Unit
57	BPUMN	☐	BPUMN	UMBSN	DEC	5	0	Denominator for Conv. of Order Price Unit into Order Unit
58	LIFRE	☐	LIFRE	LIFNR	CHAR	10	0	Different Invoicing Party	LFA1
59	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
60	EREKZ	☐	EREKZ	XFELD	CHAR	1	0	Final Invoice Indicator
61	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
62	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
63	UEBTK	☐	UEBTK	XFELD	CHAR	1	0	Indicator: Unlimited Overdelivery Allowed

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CIFSRCOA	BPRME	T006	MSEHI	REF	1	N
2	CIFSRCOA	BSART	T161	BSART	REF	1	N
3	CIFSRCOA	BSTME	T006	MSEHI	REF	1	N
4	CIFSRCOA	EKGRP	T024	EKGRP	REF	1	N
5	CIFSRCOA	EKORG	T024E	EKORG	REF	1	N
6	CIFSRCOA	EMLIF	LFA1	LIFNR	KEY	1	N
7	CIFSRCOA	INCO1	TINC	INCO1	REF	1	N
8	CIFSRCOA	INCO1P	TINC	INCO1	REF	1	N
9	CIFSRCOA	KNTTP	T163K	KNTTP	REF	1	N
10	CIFSRCOA	LGORT	T001L	LGORT	REF	1	N
11	CIFSRCOA	LIFNR	LFA1	LIFNR	REF	1	N
12	CIFSRCOA	LIFRE	LFA1	LIFNR	REF	1	N
13	CIFSRCOA	LMEIN	T006	MSEHI	REF	1	N
14	CIFSRCOA	MANDT	T000	MANDT	KEY	1	N
15	CIFSRCOA	MATNR	MARA	MATNR	REF	1	N
16	CIFSRCOA	MWSKZ	T007A	MWSKZ	KEY	1	CN
17	CIFSRCOA	PSTYP	T163	PSTYP	REF	1	N
18	CIFSRCOA	RESWK	T001W	WERKS	REF	1	N
19	CIFSRCOA	SOBKZ	T148	SOBKZ	REF	1	N
20	CIFSRCOA	TXJCD	TTXJ	TXJCD	REF	1	CN
21	CIFSRCOA	WAERS	TCURC	WAERS	REF	1	N
22	CIFSRCOA	WERKS	T001W	WERKS	REF	1	N

History

Last changed by/on	SAP	20140121
SAP Release Created in