SAP ABAP Table BAPIBUSISM008_BDS_OUT (IS-M/AM: Billing Dataset)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JAS (Package) Application development R/3 Publishing Advertising System***

Basic Data

Table Category	INTTAB	Structure
Structure	BAPIBUSISM008_BDS_OUT	Table Relationship Diagram
Short Description	IS-M/AM: Billing Dataset

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	DOCUMENT_NO	☑	AVM_NR	AVM_NR	CHAR	10	0	IS-M/AM: Sales Document Number	*
2	ITEM_NUMBER	☑	POS_NR	AVM_PNR	NUMC	3	0	IS-M: Order Item Number	*
3	BILLING_DATASET_NO	☑	GRUPPABRNR	GRUPPABR	NUMC	3	0	IS-M/AM: Billing Dataset	*
4	ADVERTISER	☐	INSERENT	GPNR	CHAR	10	0	IS-M: Advertiser	JGTGPNR
5	INITIAL_BOOKING_UNIT	☐	UR_BELEINH	BELEINH	CHAR	10	0	IS-M: Initial Booking Unit for the OPM Item	JJTBE
6	BASIC_BOOKING_UNIT	☐	BE_BASIS	BELEINH	CHAR	10	0	IS-M: Basic Booking Unit	JJTBE
7	SERVICE_PERFORMANCE_DATE	☐	BER_TERMIN	DATUM	DATS	8	0	IS-M: Date Services were Created for Settlement Purposes
8	SERVICE_PERFORMANCE_DATE_TO	☐	BER_TERMIN_BIS	DATUM	DATS	8	0	IS-M: End Date for Service Creation in Terms of Settlement
9	SERVICE_PERFORMANCE_COPY_NO	☐	ISM_BER_HEFT	PAM_PERIOD	CHAR	14	0	IS-M: Service Creation Copy Number for Settlement
10	AD_SPEC_NO	☐	MOTIV_NR	PAM_MOTIV	NUMC	6	0	IS-M: Ad Spec Number (Ad)	JHAMOT
11	SEPARATE_AGENCY_COMMISSION	☐	XAEPROV	XFELD	CHAR	1	0	IS-M: Agency Commission Credit Memo Indicator
12	TWIN_BILLING_DATASET_NO	☐	ISM_TWIN_BILLING_DATASET_NO	GRUPPABR	NUMC	3	0	IS-M: Twinned Billing Dataset for Separate Agency Commission	*
13	COMMERCIAL_TIMESLICE	☐	WS_TIMESLC	WS_TIMESLC	CHAR	2	0	IS-M: Commercial Time Slice	*
14	COMMERCIAL_CLUSTER	☐	WS_BLOCK	WS_BLOCK	CHAR	2	0	IS-M: Commercial Cluster	*
15	COMMERCIAL_POSITION	☐	WS_STELLE	NUMC3	NUMC	3	0	IS-M: Position (Sequence) Within a Commercial Cluster
16	QUANTITY	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
17	BASE_UNIT	☐	LAGME	MEINS	UNIT	3	0	Base Unit of Measure	*
18	BASE_UNIT_ISO	☐	MEINS_ISO	ISOCD_UNIT	CHAR	3	0	Base unit of measure in ISO code	*
19	PRICE1	☐	ISM_ORDER_PRICE1	BAPICURR	DEC	23	4	IS-M: Price Field 1 in the Order
20	PRICE2	☐	ISM_ORDER_PRICE2	BAPICURR	DEC	23	4	IS-M: Price Field 2 in the Order
21	CURRENCY	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
22	CURRENCY_ISO	☐	WAERS_ISO	ISOCD	CHAR	3	0	ISO code currency
23	PERCENTAGE_DISCOUNT1	☐	JRABPROZ	DEC4_3	DEC	7	3	IS-M/AM: Percentage discount
24	PERCENTAGE_DISCOUNT1_REASON	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
25	PERCENTAGE_DISCOUNT2	☐	JRABPROZ	DEC4_3	DEC	7	3	IS-M/AM: Percentage discount
26	PERCENTAGE_DISCOUNT2_REASON	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
27	PERCENTAGE_DISCOUNT3	☐	JRABPROZ	DEC4_3	DEC	7	3	IS-M/AM: Percentage discount
28	PERCENTAGE_DISCOUNT3_REASON	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
29	QUANTITY_DISCOUNT	☐	JRABMEIN	WERTV6	CURR	11	2	IS-M/AM: Quantity-dependent discount
30	QUANTITY_DISCOUNT_P_UNT	☐	PAMPEIN	KPEIN	DEC	5	0	IS-M: Price Unit (Surcharge Discount, Basic Price)
31	QUANTITY_DISCOUNT_UOM	☐	PAMMEIN	ISPEINH_PR	UNIT	3	0	IS-M: Unit of Measure (Discount, Surcharge, Basic Price)	TJH51
32	QUANTITY_DISCOUNT_UOM_ISO	☐	KVMEI_ISO	ISOCD_UNIT	CHAR	3	0	Condition Unit in ISO Code	T006I
33	QUANTITY_DISCOUNT_REASON	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
34	AMOUNT_DISCOUNT	☐	ISM_AMOUNT_DISCOUNT	BAPICURR	DEC	23	4	IS-M/AM: Amount Discount (BAPICURR)
35	AMOUNT_DISCOUNT_REASON	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
36	PERCENTAGE_SURCHARGE1	☐	JZUSPROZ	DEC4_3	DEC	7	3	IS-M/AM: Percentage Surcharge
37	PERCENTAGE_SURCHARGE1_REASON	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
38	PERCENTAGE_SURCHARGE2	☐	JZUSPROZ	DEC4_3	DEC	7	3	IS-M/AM: Percentage Surcharge
39	PERCENTAGE_SURCHARGE2_REASON	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
40	PERCENTAGE_SURCHARGE3	☐	JZUSPROZ	DEC4_3	DEC	7	3	IS-M/AM: Percentage Surcharge
41	PERCENTAGE_SURCHARGE3_REASON	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
42	QUANTITY_SURCHARGE	☐	JZUSMEIN	WERTV6	CURR	11	2	IS-M/AM: Quantity-dependent surcharge
43	QUANTITY_SURCHARGE_P_UNT	☐	PAMPEIN	KPEIN	DEC	5	0	IS-M: Price Unit (Surcharge Discount, Basic Price)
44	QUANTITY_SURCHARGE_UOM	☐	PAMMEIN	ISPEINH_PR	UNIT	3	0	IS-M: Unit of Measure (Discount, Surcharge, Basic Price)	TJH51
45	QUANTITY_SURCHARGE_UOM_ISO	☐	KVMEI_ISO	ISOCD_UNIT	CHAR	3	0	Condition Unit in ISO Code	T006I
46	QUANTITY_SURCHARGE_REASON	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
47	AMOUNT_SURCHARGE	☐	ISM_AMOUNT_SURCHARGE	BAPICURR	DEC	23	4	IS-M/AM: Amount Surcharge (BAPICURR)
48	AMOUNT_SURCHARGE_REASON	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
49	BASIC_PRICE	☐	ISM_BASIC_PRICE	BAPICURR	DEC	23	4	IS-M/AM: Basic Price (BAPICURR)
50	BASIC_PRICE_P_UNT	☐	PAMPEIN	KPEIN	DEC	5	0	IS-M: Price Unit (Surcharge Discount, Basic Price)
51	BASIC_PRICE_UOM	☐	PAMMEIN	ISPEINH_PR	UNIT	3	0	IS-M: Unit of Measure (Discount, Surcharge, Basic Price)	TJH51
52	BASIC_PRICE_UOM_ISO	☐	KVMEI_ISO	ISOCD_UNIT	CHAR	3	0	Condition Unit in ISO Code	T006I
53	BASIC_PRICE_REASON	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
54	AGREED_PRICE	☐	ISM_AGREED_PRICE	BAPICURR	DEC	23	4	IS-M/AM: Agreed Price (BAPICURR)
55	AGREED_PRICE_REASON	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
56	DISCOUNT_SURCHARGE_CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
57	DISCOUNT_SURCHARGE_CURRENCYISO	☐	WAERS_ISO	ISOCD	CHAR	3	0	ISO code currency
58	PRICE_DATE	☐	PRSDT	DATUM	DATS	8	0	Date for pricing and exchange rate
59	PLANNED_BILLING_DATE	☐	JHFKTER	DATUM	DATS	8	0	IS-M: Planned Billing/Settlement Date
60	BILL_BLOCK	☐	PAM_FAKSP	FAKSP	CHAR	2	0	IS-M: Billing Block	TVFS
61	PMNTTRMS	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
62	FIX_VAL_DY	☐	VALDT	DATUM	DATS	8	0	Fixed value date
63	ADD_VAL_DY	☐	VALTG	TAGE2	NUMC	2	0	Additional value days
64	BILL_SCHED	☐	PERFK	WFCID	CHAR	2	0	Invoice dates (calendar identification)	TFACD
65	PRICE_GRP	☐	KONDA	KONDA	CHAR	2	0	Price Group (Customer)	*
66	CASH_DISC	☐	SKTOF	XFELD	CHAR	1	0	Cash discount indicator
67	LOCAL_CUSTOMER	☐	XORTSPREIS	XFELD	CHAR	1	0	IS-M/AM: Local Customer Indicator
68	SEPARATE_BILLING_DOCUMENT	☐	XSEPFKKOPF	XFELD	CHAR	1	0	Separate billing document for sales order
69	ADVANCE_BILLING	☐	VORAUSKNZ	XFELD	CHAR	1	0	IS-M: Indicates Whether Advance Billing Required
70	TAX_CLASS_MATERIAL1	☐	TAXM1	TAXKM	CHAR	1	0	Tax classification material	*
71	TAX_CLASS_MATERIAL2	☐	TAXM2	TAXKM	CHAR	1	0	Tax classification material	*
72	TAX_CLASS_MATERIAL3	☐	TAXM3	TAXKM	CHAR	1	0	Tax classification material	*
73	TAX_CLASS_MATERIAL4	☐	TAXM4	TAXKM	CHAR	1	0	Tax Classification 4 Material	*
74	TAX_CLASS_MATERIAL5	☐	TAXM5	TAXKM	CHAR	1	0	Tax classification 5 for material	*
75	TAX_CLASS_MATERIAL6	☐	TAXM6	TAXKM	CHAR	1	0	Tax classification 6 for material	*
76	TAX_CLASS_MATERIAL7	☐	TAXM7	TAXKM	CHAR	1	0	Tax classification 7 for material	*
77	TAX_CLASS_MATERIAL8	☐	TAXM8	TAXKM	CHAR	1	0	Tax Classification 8 Material	*
78	TAX_CLASS_MATERIAL9	☐	TAXM9	TAXKM	CHAR	1	0	Tax Classification 9 Material	*
79	OVERALL_CREDIT_STATUS	☐	ISMAM_CMGST	CMGST	CHAR	1	0	IS-M/AM: Credit Management: Overall Status of Credit Checks
80	NO_OF_QUA_DISCOUNT_PUBL_OT_BUS	☐	ANZ_ANFS	ANZ_ANFS	NUMC	3	0	IS-M: No.of Placements Qual.for Disc.Due to Pub.in Other BUs
81	NO_OF_QUA_DISCOUNT_PUBL_OT_DAY	☐	ANZ_WNFS	ANZ_ANFS	NUMC	3	0	IS-M: No.of Placements Qual.For Dis.Due to Publc.On Oth.Days
82	CC_AUTTH_NO	☐	AUNUM	CHAR10	CHAR	10	0	Payment cards: Authorization number
83	AUTH_REFNO	☐	AUTRA	CHAR15	CHAR	15	0	Payment cards: Authoriz. reference code of clearing house
84	AUTHAMOUNT	☐	ACPI_CAUTW	BAPICURR	DEC	23	4	Payment Cards: Authorized Amount
85	AUTH_DATE	☐	AUDAT_CC	DATUM	DATS	8	0	Payment cards: Authorization date
86	AUTH_TIME	☐	AUTIM	UZEIT	TIMS	6	0	Payment cards: Authorization time
87	PRICING_COMPLETED	☐	XPREIS_EE	XFELD	CHAR	1	0	IS-M: Pricing completed
88	CREDIT_CHECK_FAILED	☐	XCMP_FAILED	XFELD	CHAR	1	0	IS-M/AM: Credit check failed
89	CC_AUTHORIZATION_REQUIRED	☐	XCCAUTNOTW	XFELD	CHAR	1	0	IS-M/AM: Payment card authorization required
90	BILLED	☐	XFAKT_EE	XFELD	CHAR	1	0	IS-M: Billed Indicator
91	AGENT_ASSIGNMENT_INCOMPLETE	☐	XUVVZ	XFELD	CHAR	1	0	IS-M: Sales Agent Assignment Incomplete
92	PARTIALLY_COMMISSIONED	☐	XPROVMIN1	XFELD	CHAR	1	0	Partial Commission (At Least 1 Sales Agent Assignment Comm.)
93	FULLY_COMMISSIONED	☐	XPROVALL	XFELD	CHAR	1	0	Commission Calculated For All Sales Agent Assignments Ind.
94	STATUS_CHARACTERISTIC0	☐	MERK0_GA	XFELD	CHAR	1	0	IS-M: Characteristic 9 for Individual Use (Billing Dataset)
95	STATUS_CHARACTERISTIC1	☐	MERK1_GA	XFELD	CHAR	1	0	IS-M: Characteristic 1 for Individual Use (Billing Dataset)
96	STATUS_CHARACTERISTIC2	☐	MERK2_GA	XFELD	CHAR	1	0	IS-M: Characteristic 2 for Individual Use (Billing Dataset)
97	STATUS_CHARACTERISTIC3	☐	MERK3_GA	XFELD	CHAR	1	0	IS-M: Characteristic 3 for Individual Use (Billing Dataset)
98	STATUS_CHARACTERISTIC4	☐	MERK4_GA	XFELD	CHAR	1	0	IS-M: Characteristic 4 for Individual Use (Billing Dataset)
99	STATUS_CHARACTERISTIC5	☐	MERK5_GA	XFELD	CHAR	1	0	IS-M: Characteristic 5 for Individual Use (Billing Dataset)
100	STATUS_CHARACTERISTIC6	☐	MERK6_GA	XFELD	CHAR	1	0	IS-M: Characteristic 6 for Individual Use (Billing Dataset)
101	STATUS_CHARACTERISTIC7	☐	MERK7_GA	XFELD	CHAR	1	0	IS-M: Characteristic 7 for Individual Use (Billing Dataset)
102	STATUS_CHARACTERISTIC8	☐	MERK8_GA	XFELD	CHAR	1	0	IS-M: Characteristic 8 for Individual Use (Billing Dataset)
103	STATUS_CHARACTERISTIC9	☐	MERK9_GA	XFELD	CHAR	1	0	IS-M: Characteristic 9 for Individual Use (Billing Dataset)
104	CANCELLED	☐	XSTORNIERT	XFELD	CHAR	1	0	IS-M: Canceled Order Object Indicator
105	CANCELLATION_REASON	☐	STOGRD_PAM	STOGRD_PAM	CHAR	3	0	IS-M: Cancellation Reason	TJHSTOG
106	STATUS	☐	GF_STATUS	PAM_STATUS	CHAR	2	0	IS-M: Billing Dataset Status
107	GROSS_AMOUNT	☐	ISM_ORDER_GROSS_AMOUNT	BAPICURR	DEC	23	4	IS-M: Gross Value
108	NET_AMOUNT	☐	ISM_ORDER_NET_AMOUNT	BAPICURR	DEC	23	4	IS-M/AM: Net Value
109	TAX_AMOUNT	☐	ISM_ORDER_TAX_AMOUNT	BAPICURR	DEC	23	4	IS-M/AM: Tax Values

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BAPIBUSISM008_BDS_OUT	ADVERTISER	JGTGPNR	GPNR	KEY	C	CN
2	BAPIBUSISM008_BDS_OUT	AD_SPEC_NO	JHAMOT	MOTIV	KEY	C	CN
3	BAPIBUSISM008_BDS_OUT	BASIC_BOOKING_UNIT	JJTBE	BELEINH	KEY	C	CN
4	BAPIBUSISM008_BDS_OUT	BASIC_PRICE_UOM	TJH51	ISPEINH_PR	REF	1	CN
5	BAPIBUSISM008_BDS_OUT	BASIC_PRICE_UOM_ISO	T006I	ISOCODE	REF	1	CN
6	BAPIBUSISM008_BDS_OUT	BILL_BLOCK	TVFS	FAKSP	REF	1	CN
7	BAPIBUSISM008_BDS_OUT	BILL_SCHED	TFACD	IDENT	REF	1	CN
8	BAPIBUSISM008_BDS_OUT	CANCELLATION_REASON	TJHSTOG	STORNOGRD	REF	1	CN
9	BAPIBUSISM008_BDS_OUT	CURRENCY	TCURC	WAERS	REF	1	CN
10	BAPIBUSISM008_BDS_OUT	DISCOUNT_SURCHARGE_CURRENCY	TCURC	WAERS	REF	1	CN
11	BAPIBUSISM008_BDS_OUT	INITIAL_BOOKING_UNIT	JJTBE	BELEINH	KEY	C	CN
12	BAPIBUSISM008_BDS_OUT	QUANTITY_DISCOUNT_UOM	TJH51	ISPEINH_PR	REF	1	CN
13	BAPIBUSISM008_BDS_OUT	QUANTITY_DISCOUNT_UOM_ISO	T006I	ISOCODE	REF	1	CN
14	BAPIBUSISM008_BDS_OUT	QUANTITY_SURCHARGE_UOM	TJH51	ISPEINH_PR	REF	1	CN
15	BAPIBUSISM008_BDS_OUT	QUANTITY_SURCHARGE_UOM_ISO	T006I	ISOCODE	REF	1	CN

History

Last changed by/on	SAP	20071120
SAP Release Created in	464