SAP table FKK_VBRK_SHORT (Header Data for SD Billing Document - Extracts)

SAP table FKK_VBRK_SHORT has 5 primary key fields being MANDT,BUKRS,GJAHR,OPBEL,VBELN.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
BUKRS Company Code CHAR 4 0 BUKRS
GJAHR Posting year NUMC 4 0 GJAHR_KK
OPBEL Number of Contract Accts Rec. & Payable Doc. CHAR 12 0 DFKKKO_SHORT SH_OPBEL_KK
VBELN Sales and Distribution Document Number CHAR 10 0 VBELN
XBLNR Reference Document Number CHAR 16 0 XBLNR1
WAERK SD Document Currency CUKY 5 0 WAERK
VBUND Company ID of Trading Partner CHAR 6 0 RASSC
EXPKZ Export indicator CHAR 1 0 EXPKZ
FKART Billing Type CHAR 4 0 FKART
FKDAT Billing Date DATS 8 0 FKDAT
FKSTO Billing document is canceled CHAR 1 0 FKSTO
INCO1 Incoterms (Part 1) CHAR 3 0 INCO1
INCO2 Incoterms (Part 2) CHAR 28 0 INCO2
KALSM Procedure (Pricing, Output Control, Acct. Det., Costing,...) CHAR 6 0 KALSM_D
KUNAG Sold-to Party CHAR 10 0 KUNAG
KUNRG Payer CHAR 10 0 KUNRG
SFAKN Number of canceled billing document CHAR 10 0 SFAKN
VBTYP SD Document Category CHAR 4 0 VBTYPL
# Revenue Recognition (Temporary)
$ (AFS)
& Warehouse Document
* Pick Order
+ Journal Entry (Temporary)
, Shipment Document
- Journal Entry (Temporary)
. Service Notification
0 Master Contract
1 Sales Activities (CAS)
2 External Transaction
3 Invoice List
4 Credit Memo List
5 Intercompany Invoice
6 Intercompany Credit Memo
7 Delivery/Shipping Notification
8 Shipment
: Service Order
A Inquiry
a Shipment Costs
b CRM Opportunity
B Quotation
BOS Service Entry Sheet
C Order
c Unverified Delivery
CEM ETM Shipping Document
CMMA Customer Management Master Agreement
CSCO Customer Management Service Confirmation
CSCT Customer Management Service Contract
CSVO Customer Management Service Order
D Item Proposal
d Trading Contract
e Allocation Table
E Scheduling Agreement
EBDR Billing Document Request
F Scheduling Agreement with External Service Agent
f001 Period-End Invoice
f002 Period-End Credit Memo
f003 Period-End Invoice (Intercompany Billing)
f004 Period-End Credit Memo (Intercompany Billing)
G Contract
g Rough Goods Receipt (only IS-Retail)
GBRQ Grants Management Billing Request
h Cancel Goods Issue
H Returns
i Goods Receipt
I Order Without Charge
J Delivery
j JIT Call
K Credit Memo Request
k Settlement Management Document
L Debit Memo Request
M Invoice
N Invoice Cancellation
n Reserved
O Credit Memo
o Reserved
P Debit Memo
p Goods Movement (Documentation)
PBD Preliminary Billing Document
PBDR Billing Document Request for Prof. Serv.
PBRQ Project Billing Request
q Reserved
Q WMS Transfer Order
R Goods Movement
r TD Transport (Only IS-Oil)
S Credit Memo Cancellation
s Load Confirmation, Reposting (Only IS-Oil)
SBRQ Subscription Billing Request
SOLO Solution Order
t Gain / Loss (Only IS-Oil)
T Returns Delivery for Order
TMFO Freight Order
TMFU Freight Unit
U Pro Forma Invoice
u Reentry into Storage (Only IS-Oil)
v Data Collation (Only IS-Oil)
V Purchase Order
W Independent Reqts Plan
w Reservation (Only IS-Oil)
X Handling Unit
x Load Confirmation, Goods Receipt (Only IS-Oil)
Y Rebate Agreement
^ Reserved
| Reserved
~ Revenue Cancellation (Temporary)
ยง Revenue Recognition/New View (Temporary)
NETWR Value of invoice CHAR 16 0 TXW_NETWR_CS
AWTYP Reference procedure CHAR 5 0 AWTYP
AWKEY Reference Key CHAR 20 0 AWKEY
BSTNK_VF Customer Reference CHAR 35 0 BSTKD
KNUMV Number of the Document Condition CHAR 10 0 KNUMV
VKORG Sales Organization CHAR 4 0 VKORG
ZTERM Terms of payment key CHAR 4 0 DZTERM
LAND1 Destination Country/Region CHAR 3 0 LLAND
LANDTX Tax Departure Country/Region CHAR 3 0 LANDTX
LOGSYS Logical system CHAR 10 0 LOGSYS

FKK_VBRK_SHORT foreign key relationships

Table Field Check Table Check Field
0 FKK_VBRK_SHORT OPBEL DFKKKO_SHORT Header Data for Contract Accounting Document - Extracts BUKRS
0 FKK_VBRK_SHORT OPBEL DFKKKO_SHORT Header Data for Contract Accounting Document - Extracts GJAHR